How to fetch date colum from the back end in wpf?

To ensure that the date is correctly fetched from the database and not editable by users in the UI, you need to bind the date property from your database to the TextBox without allowing user input. Additionally, make sure your data fetching logic is correctly implemented.

Here’s how you can revise your code:

1. Make the TextBox read-only.
2. Ensure your data fetching method retrieves the date from the database.
3. Bind the date property in a way that it reflects the data from your database.

XAML Code

Update the TextBox to make it read-only:

View Class

Ensure that the Date property in the view class is correctly set:

public DateTime Date
{
    get
    {
        DateTime date;
        if (DateTime.TryParse(DateTextBox.Text, out date))
        {
            return date;
        }
        return DateTime.MinValue;
    }
    set
    {
        DateTextBox.Text = value.ToString("M/d/yyyy");
    }
}

Method to Fetch Date

Update your method to correctly fetch and set the date:

public void GetDateForBatch(int batchNumber)
{
    Managers.PremixControlManager.SetAdriotConnection();
    var controlSheet = Managers.PremixControlManager.GetPremixControlByPK(batchNumber);

    if (controlSheet != null)
    {
        View.Date = controlSheet.Date;
    }
    else
    {
        View.Date = DateTime.MinValue;
    }
}

PremixControlManager Class

Ensure the PremixControlManager correctly fetches data from the stored procedure:

class PremixControlManager
{
    // Get primary key from the table.
    public static PremixControl GetPremixControlByPK(int batchID)
    {
        return DataAccessProvider.GetEntity(PremixControl.PROC_NAME_GET, new object[] { "PK", batchID });
    }
}

IPremixBatch Interface

Ensure your interface correctly defines the Date property:

public interface IPremixBatch
{
    DateTime Date { get; set; }
}

Presenter Class

Your presenter class method to fetch and set the date:

public void GetDateForBatch(int batchNumber)
{
    Managers.PremixControlManager.SetAdriotConnection();
    var controlSheet = Managers.PremixControlManager.GetPremixControlByPK(batchNumber);

    if (controlSheet != null)
    {
        View.Date = controlSheet.Date;
    }
    else
    {
        View.Date = DateTime.MinValue;
    }
}

Summary

With these adjustments, the DateTextBox will be read-only, and the date will be correctly fetched from the database using your stored procedure. The users will not be able to edit the date directly in the UI, ensuring the integrity of the data displayed.

If this solution works for you, please accept the answer to help others who might have the same question!