internal static MiscRateEntity GetMiscRates() { MiscRateEntity rates = null; DataSet result = null; try { result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetMiscRates, null); if (result == null || result.Tables == null || result.Tables.Count == 0 || result.Tables[0].Rows.Count == 0) { return rates; } rates = new MiscRateEntity(); rates.NotchRate = double.Parse(result.Tables[0].Rows[0][ColumnNames.NOTCH_RATE].ToString()); rates.HingeRate = double.Parse(result.Tables[0].Rows[0][ColumnNames.HINGE_RATE].ToString()); rates.PatchRate = double.Parse(result.Tables[0].Rows[0][ColumnNames.PATCH_RATE].ToString()); rates.MinimumTotalSqft = double.Parse(result.Tables[0].Rows[0][ColumnNames.MinimumTotalSqft].ToString()); } catch (Exception ex) { Logger.LogException(ex); } return rates; }
internal static bool UpdateMiscRate(MiscRateEntity miscRate) { bool result = true; try { SqlParameter pNotchRate = new SqlParameter(); pNotchRate.ParameterName = "NotchRate"; pNotchRate.Value = miscRate.NotchRate; SqlParameter pHingeRate = new SqlParameter(); pHingeRate.ParameterName = "HingeRate"; pHingeRate.Value = miscRate.HingeRate; SqlParameter pPatchRate = new SqlParameter(); pPatchRate.ParameterName = "PatchRate"; pPatchRate.Value = miscRate.PatchRate; SqlParameter pMinimumTotalSqft = new SqlParameter(); pMinimumTotalSqft.ParameterName = "MinimumTotalSqft"; pMinimumTotalSqft.Value = miscRate.MinimumTotalSqft; SQLHelper.ExecuteStoredProcedure(StoredProcedures.UpdateMiscRate, pNotchRate, pHingeRate, pPatchRate, pMinimumTotalSqft); } catch (Exception ex) { Logger.LogException(ex); result = false; } return result; }
private void btnSaveMiscRate_Click(object sender, RoutedEventArgs e) { try { MiscRateEntity miscRate = new MiscRateEntity(); miscRate.NotchRate = double.Parse(txtNotchRate.Text); miscRate.HingeRate = double.Parse(txtHingeRate.Text); miscRate.PatchRate = double.Parse(txtPatchRate.Text); miscRate.MinimumTotalSqft = double.Parse(txtMinimumTotalSqft.Text); if (BusinessLogic.UpdateMiscRate(miscRate)) { Helper.ShowInformationMessageBox("Misc Rates updated successfully!"); } else { Helper.ShowErrorMessageBox("Error while saving Misc Rates. Kindly contact your vendor."); } txtNotchRate.IsReadOnly = true; txtHingeRate.IsReadOnly = true; txtPatchRate.IsReadOnly = true; txtMinimumTotalSqft.IsReadOnly = true; btnEditMiscRate.IsEnabled = true; btnSaveMiscRate.IsEnabled = false; btnCancelMiscRate.IsEnabled = false; } catch (Exception ex) { Logger.LogException(ex); } }