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 IQueryable <T> DisplayAllDB <T>() where T : class { SalariesLINQDataContext db = new SalariesLINQDataContext(con); var selectQuery = from emp in db.GetTable <T>() select emp; return(selectQuery); }
public static IQueryable <Salary> DiplayWorkersSalariesDB(int workerID) { SalariesLINQDataContext db = new SalariesLINQDataContext(con); var selectQuery = from sal in db.GetTable <Salary>() where sal.WorkerID == workerID select sal; return(selectQuery); }
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); } }