public bool UpdateTallySetupSetting(TallySetupSettingModel tallySetupSettingModel) { bool result = false; if (!string.IsNullOrEmpty(tallySetupSettingModel.Id.ToString())) { using (var connection = new SqlConnection(appSettings.GetConnectionString())) { var query = "Update [TallySetup] set LedgerName='" + tallySetupSettingModel.LedgerName + "' Where Id=" + tallySetupSettingModel.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 < dgTallySetupSetting.Items.Count; i++) { var tallySetupSettingModel = (TallySetupSettingModel)dgTallySetupSetting.Items[i]; ContentPresenter myCp = dgTallySetupSetting.Columns[j].GetCellContent(tallySetupSettingModel) as ContentPresenter; var myTemplate = myCp.ContentTemplate; TextBox mytxtbox = myTemplate.FindName("txtLedgerName", myCp) as TextBox; mytxtbox.IsEnabled = true; } } else { int j = 1; for (int i = 0; i < dgTallySetupSetting.Items.Count; i++) { var tallySetupSettingModel = (TallySetupSettingModel)dgTallySetupSetting.Items[i]; ContentPresenter myCp = dgTallySetupSetting.Columns[j].GetCellContent(tallySetupSettingModel) as ContentPresenter; var myTemplate = myCp.ContentTemplate; TextBox mytxtbox = myTemplate.FindName("txtLedgerName", myCp) as TextBox; if (string.IsNullOrEmpty(mytxtbox.Text)) { var messageBoxResult = WpfMessageBox.Show(StatusMessages.AppTitle, "Enter valid data", MessageBoxButton.OK, EnumUtility.MessageBoxImage.Warning); return; } else { TallySetupSettingModel tallySetupSettingModel1 = (TallySetupSettingModel)myCp.Content; tallySetupSettingModel1.LedgerName = mytxtbox.Text; var result = settingsViewModel.UpdateTallySetupSetting(tallySetupSettingModel1); } } btnCancel_Click(null, null); } }