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);
}
}
