public bool UpdateReportOffsetById(ReportOffsetModel reportOffsetModel)
{
bool result = false;
if (!string.IsNullOrEmpty(reportOffsetModel.Id.ToString()))
{
using (var connection = new SqlConnection(appSettings.GetConnectionString()))
{
var query = "Update [ReportOffset] set Columnoffset=" + reportOffsetModel.ColumnOffset + " Where Id=" + reportOffsetModel.Id;
result = connection.Query <bool>(query).FirstOrDefault();
}
}
return(result);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (btnSave.Content.ToString() == "Edit")
{
btnSave.Content = "Save";
btnCancel.Visibility = Visibility.Visible;
int j = 1;
for (int i = 0; i < dgReportOffset.Items.Count; i++)
{
var reportOffsetModel = (ReportOffsetModel)dgReportOffset.Items[i];
ContentPresenter myCp = dgReportOffset.Columns[j].GetCellContent(reportOffsetModel) as ContentPresenter;
var myTemplate = myCp.ContentTemplate;
TextBox mytxtbox = myTemplate.FindName("txtColumnOffset", myCp) as TextBox;
mytxtbox.IsEnabled = true;
}
}
else
{
int j = 1;
for (int i = 0; i < dgReportOffset.Items.Count; i++)
{
var reportOffsetModel = (ReportOffsetModel)dgReportOffset.Items[i];
ContentPresenter myCp = dgReportOffset.Columns[j].GetCellContent(reportOffsetModel) as ContentPresenter;
var myTemplate = myCp.ContentTemplate;
TextBox mytxtbox = myTemplate.FindName("txtColumnOffset", myCp) as TextBox;
if (string.IsNullOrEmpty(mytxtbox.Text))
{
var messageBoxResult = WpfMessageBox.Show(StatusMessages.AppTitle, "Enter valid data", MessageBoxButton.OK, EnumUtility.MessageBoxImage.Warning);
return;
}
else
{
ReportOffsetModel reportOffsetModel1 = (ReportOffsetModel)myCp.Content;
reportOffsetModel1.ColumnOffset = Convert.ToInt32(mytxtbox.Text);
var result = printReceiptViewModel.UpdateReportOffsetById(reportOffsetModel1);
}
}
btnCancel_Click(null, null);
}
}
