//method to add fixed overhead detaisl returne true if successfull els false
public bool addFixedOverHead(FixedOverHeadData fixOh)//this method adds data to fixed overhead db table
{
try
{
FixedOverhead fixadd = new FixedOverhead();
fixadd.Year = fixOh.Year;
fixadd.Month = fixOh.Month;
fixadd.Electricity = (decimal)fixOh.Elect;
fixadd.Tax = (decimal)fixOh.Tax;
fixadd.Water = (decimal)fixOh.Water;
fixadd.Salary = (decimal)fixOh.Salary;
fixadd.RentOrMortgage = (decimal)fixOh.Rent;
fixadd.PhoneAnInternet = (decimal)fixOh.PhInt;
fixadd.Fuel = (decimal)fixOh.Fule;
fixadd.Misc = (decimal)fixOh.Mess;
fixadd.Ot = (decimal)fixOh.Ot;
fixadd.Other = (decimal)fixOh.Other;
_context.FixedOverheads.Add(fixadd);
int chk = _context.SaveChanges();
if (chk >= 0)
return true;
else
return false;
}
catch (InvalidOperationException invalidOperationException)
{
addException(invalidOperationException, "addFixedOverHead");
return false;
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEntityValidationException)
{
addException(dbEntityValidationException, "addFixedOverHead()");
return false;
}
}//addFixedOverHead method ends
}//getmonth methods ends
//this method updates fixed overhead details and return true if success else return false
public bool updateFixData(FixedOverHeadData data)
{
try
{
FixedOverhead fixedEdit = _context.FixedOverheads.FirstOrDefault(i => i.FixID == data.Id);
fixedEdit.Year = data.Year;
fixedEdit.Month = data.Month;
fixedEdit.Electricity = (decimal)data.Elect;
fixedEdit.Tax = (decimal)data.Tax;
fixedEdit.Water = (decimal)data.Water;
fixedEdit.Salary = (decimal)data.Salary;
fixedEdit.RentOrMortgage = (decimal)data.Rent;
fixedEdit.PhoneAnInternet = (decimal)data.Rent;
fixedEdit.Fuel = (decimal)data.Fule;
fixedEdit.Misc = (decimal)data.Mess;
fixedEdit.Ot = (decimal)data.Ot;
fixedEdit.Other = (decimal)data.Other;
int chk = _context.SaveChanges();
if (chk >= 0)
return true;
else
return false;
}
catch (InvalidOperationException invalidOperationException)
{
addException(invalidOperationException, "updateFixData()");
return false;
}
}//updateFixData method ends
private void btnFOHAdd_Click(object sender, System.Windows.RoutedEventArgs e)
{
if (getvalidationsEmptyFields())
System.Windows.MessageBox.Show("Need to fill all the fields", "Empty Fields", MessageBoxButton.OK, MessageBoxImage.Warning);
else
{
FixedOverHeadDAO fixdao = new FixedOverHeadDAO();
FixedOverHeadData fixdata = new FixedOverHeadData();
//check for the values exisit in the tabel
int mx = 0;
string fixID = "";
int mont = cmbFOHmonthComboBox.SelectedIndex + 1;
int year1 = Convert.ToInt32(cmbFOHForMonthYear.SelectedValue.ToString());
fixID = fixdao.getmonth(mont, year1);
if (fixID != null)
mx = 1;
//end of check
//parsig values to fixed overhead data objec
fixdata.Year = Convert.ToInt32(cmbFOHForMonthYear.Text);
fixdata.Month = cmbFOHmonthComboBox.SelectedIndex + 1;
fixdata.Elect = Convert.ToDouble(txtFOHAddElectricityCost.Text);
fixdata.Tax = Convert.ToDouble(txtFOHAddTaxCost.Text);
fixdata.Water = Convert.ToDouble(txtFOHAddWaterCost.Text);
fixdata.Salary = Convert.ToDouble(txtFOHAddSalaryCost.Text);
fixdata.Rent = Convert.ToDouble(txtFOHAddRentMortgageLeaseLoanCost.Text);
fixdata.PhInt = Convert.ToDouble(txtFOHAddPhoneInternetCost.Text);
fixdata.Fule = Convert.ToDouble(txtFOHAddFuleCost.Text);
fixdata.Mess = Convert.ToDouble(txtFOHAddMiscellaneousCost.Text);
fixdata.Ot = Convert.ToDouble(txtFOHAddOTCost.Text);
decimal other;
//other field is allowed be blanked. if field is blank then the value is taken as 0
if (string.IsNullOrEmpty(txtFOHAddOther.Text) || string.IsNullOrWhiteSpace(txtFOHAddOther.Text))
other = 0;
else
other = Convert.ToDecimal(txtFOHAddOther.Text);
fixdata.Other = (double)other;
//fixed overhead add
//
if (btnFOHAdd.Content.ToString() == "Add")
{
//check whether the fid overhead data for the perticular month is entered
if (mx == 0)
{
//fix overhead data in not available
if (fixdao.addFixedOverHead(fixdata))
{
this.fixedOverheadDataGrid.Items.Refresh();
_context.FixedOverheads.Load();
fixDAO.populateYears(cmbFOHEditYear, cmbFOHEditMonth);
System.Windows.MessageBox.Show("Succesfully Added", "Done", MessageBoxButton.OK, MessageBoxImage.Information);
resetAll();
}
else
System.Windows.MessageBox.Show("Faild to Add", "Faild", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
else if (mx > 0)
{
//fix overhead data available
//suggest to edit fix overhead data foe the perticualar month
MessageBoxResult msgresul = MessageBox.Show("Fixed Overheads details For this month are alredy exist do you want to update?", "Already exist", MessageBoxButton.YesNoCancel, MessageBoxImage.Question);
//get the confimation by the user to edit data
if (msgresul == MessageBoxResult.Yes)
{
//fill values to the month table
fillvalsToTextfohStriing(fixID);
}
}
else
{
}
}
else //fixed overhead edit function
{
fixdata.Id = lbleditFOHID.Content.ToString();
try
{
if (fixdao.updateFixData(fixdata))
{
this.fixedOverheadDataGrid.Items.Refresh();
_context.FixedOverheads.Load();
System.Windows.MessageBox.Show("Succesfully updated", "Done", MessageBoxButton.OK, MessageBoxImage.Information);
// resetAll();
}
else
System.Windows.MessageBox.Show("Faild to update", "Faild", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Exception");
}
}
}
}
