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