public static bool AddSalaryDB(Worker worker, Salarycalc salaryC, Taxes_and_others TaO, Contributions cont)
{
SalariesLINQDataContext db = new SalariesLINQDataContext(con);
Salary salary = new Salary()
{
WorkerID = worker.WorkerID,
Base_sal = salaryC.base_sal,
Bonus = salaryC.bonus,
YearsInWork = salaryC.years,
ZUS = cont.ZUS,
HCDeducted = cont.hc_deducted,
HCAsessed = cont.hc_asessed,
WorksNotInLiveCity = TaO.otherCity,
TaxPercent = TaO.tax_precent,
TaxRelief = TaO.relief,
Tax = TaO.tax_complete,
Brutto = salaryC.brutto,
Netto = salaryC.netto,
DateOfContributing = DateTime.Now
};
db.Salary.InsertOnSubmit(salary);
try
{
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static bool AddWorkerDB(string na, string sur, string gen, DateTime dob, string pes)
{
SalariesLINQDataContext db = new SalariesLINQDataContext(con);
Worker worker = new Worker()
{
Name = na,
Surname = sur,
Gender = gen,
DateOfBirth = dob,
Pesel = pes
};
db.Worker.InsertOnSubmit(worker);
try
{
db.SubmitChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}