internal static bool UpdateInsulationCost(InsulationCostEntity insualtionRate) { bool result = true; try { SqlParameter pCeiling1 = new SqlParameter(); pCeiling1.ParameterName = "Ceiling1"; pCeiling1.Value = insualtionRate.TierSqFt1; SqlParameter pCost1 = new SqlParameter(); pCost1.ParameterName = "Cost1"; pCost1.Value = insualtionRate.TierCost1; SqlParameter pCeiling2 = new SqlParameter(); pCeiling2.ParameterName = "Ceiling2"; pCeiling2.Value = insualtionRate.TierSqFt2; SqlParameter pCost2 = new SqlParameter(); pCost2.ParameterName = "Cost2"; pCost2.Value = insualtionRate.TierCost2; SqlParameter pCost3 = new SqlParameter(); pCost3.ParameterName = "Cost3"; pCost3.Value = insualtionRate.TierCost3; SQLHelper.ExecuteStoredProcedure(StoredProcedures.UpdateInsulationCost, pCeiling1, pCost1, pCeiling2, pCost2, pCost3); } catch (Exception ex) { Logger.LogException(ex); result = false; } return result; }
internal static InsulationCostEntity GetAllInsulationCost() { InsulationCostEntity rates = null; DataSet result = null; try { result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetAllInsulationCost, null); if (result == null || result.Tables == null || result.Tables.Count == 0 || result.Tables[0].Rows.Count == 0) { return rates; } rates = new InsulationCostEntity(); rates.TierCost1 = double.Parse(result.Tables[0].Rows[0][ColumnNames.Cost1].ToString()); rates.TierSqFt1 = int.Parse(result.Tables[0].Rows[0][ColumnNames.Ceiling1].ToString()); rates.TierCost2 = double.Parse(result.Tables[0].Rows[0][ColumnNames.Cost2].ToString()); rates.TierSqFt2 = int.Parse(result.Tables[0].Rows[0][ColumnNames.Ceiling2].ToString()); rates.TierCost3 = double.Parse(result.Tables[0].Rows[0][ColumnNames.Cost3].ToString()); } catch (Exception ex) { Logger.LogException(ex); } return rates; }
private void btnSaveInsulation_Click(object sender, RoutedEventArgs e) { try { InsulationCostEntity insualtionRate = new InsulationCostEntity(); insualtionRate.TierSqFt1 = int.Parse(txtTier1.Text); insualtionRate.TierCost1 = double.Parse(txtTierCost1.Text); insualtionRate.TierSqFt2 = int.Parse(txtTier2.Text); insualtionRate.TierCost2 = double.Parse(txtTierCost2.Text); insualtionRate.TierCost3 = double.Parse(txtTierCostMax.Text); if (BusinessLogic.UpdateInsulationCost(insualtionRate)) { Helper.ShowInformationMessageBox("Insulation cost updated successfully!"); } else { Helper.ShowErrorMessageBox("Error while saving insulation cost. Kindly contact your vendor."); } txtTier1.IsReadOnly = true; txtTierCost1.IsReadOnly = true; txtTier2.IsReadOnly = true; txtTierCost2.IsReadOnly = true; txtTierCostMax.IsReadOnly = true; btnEditInsulation.IsEnabled = true; btnSaveInsulation.IsEnabled = false; btnCancelInsulation.IsEnabled = false; } catch (Exception ex) { Logger.LogException(ex); } }