internal static bool UpdateGlassRate(GlassRateEntity updatedRate) { bool result = true; try { SqlParameter pGlassID = new SqlParameter(); pGlassID.ParameterName = "GlassID"; pGlassID.Value = updatedRate.GlassID; SqlParameter pThicknessID = new SqlParameter(); pThicknessID.ParameterName = "ThicknessID"; pThicknessID.Value = updatedRate.ThicknessID; SqlParameter pCutoutSqFtRate = new SqlParameter(); pCutoutSqFtRate.ParameterName = "cutSqft"; pCutoutSqFtRate.Value = updatedRate.CutoutSqFtRate; SqlParameter pTemperedRate = new SqlParameter(); pTemperedRate.ParameterName = "temperedSqft"; pTemperedRate.Value = updatedRate.TemperedRate; SqlParameter pPolishStraightRate = new SqlParameter(); pPolishStraightRate.ParameterName = "polishStraight"; pPolishStraightRate.Value = updatedRate.PolishStraightRate; SqlParameter pPolishShapeRate = new SqlParameter(); pPolishShapeRate.ParameterName = "polishShape"; pPolishShapeRate.Value = updatedRate.PolishShapeRate; SqlParameter pMiterRate = new SqlParameter(); pMiterRate.ParameterName = "miterRate"; pMiterRate.Value = updatedRate.MiterRate; SQLHelper.ExecuteStoredProcedure(StoredProcedures.UpdateGlassRates, pGlassID, pThicknessID, pCutoutSqFtRate, pTemperedRate, pPolishShapeRate, pPolishStraightRate, pMiterRate); } catch (Exception ex) { Logger.LogException(ex); result = false; } return result; }
private void btnSaveGlassDetails_Click(object sender, RoutedEventArgs e) { try { if (cmbGlassType.SelectedValue == null) return; if (cmbThickness.SelectedValue == null) return; GlassRateEntity updatedRate = new GlassRateEntity(); updatedRate.GlassID = int.Parse(cmbGlassType.SelectedValue.ToString()); updatedRate.ThicknessID = int.Parse(cmbThickness.SelectedValue.ToString()); updatedRate.CutoutSqFtRate = double.Parse(txtCutoutSqFtRate.Text); updatedRate.TemperedRate = double.Parse(txtTemperedRate.Text); updatedRate.PolishStraightRate = double.Parse(txtPolishStraightRate.Text); updatedRate.PolishShapeRate = double.Parse(txtPolishShapeRate.Text); updatedRate.MiterRate = double.Parse(txtMiterRate.Text); if (BusinessLogic.UpdateGlassRate(updatedRate)) { Helper.ShowInformationMessageBox("Rates are updated for selected items successfully!"); } else { Helper.ShowErrorMessageBox("Save operation failed. Please contact your vendor!"); } btnSaveGlassDetails.IsEnabled = false; btnCancelEditGlassDetails.IsEnabled = false; btnEditGlassDetails.IsEnabled = true; txtCutoutSqFtRate.IsReadOnly = true; txtTemperedRate.IsReadOnly = true; txtPolishStraightRate.IsReadOnly = true; txtPolishShapeRate.IsReadOnly = true; txtMiterRate.IsReadOnly = true; } catch (Exception ex) { Logger.LogException(ex); } }