public ClaimOther addClaimOther(string details, int claimId) { try { using (var db = new ProjeEntities()) { ClaimOther co = new ClaimOther(); co.Details = details; co.EmployeeClaimId = claimId; db.ClaimOthers.Add(co); db.SaveChanges(); return(co); } } catch (Exception) { throw; } }
public int delUserAnn(int id) { try { using (var db = new ProjeEntities()) { var ua = db.UserAnnouncements.Where(z => z.AnnouncementId == id).ToList(); foreach (var item in ua) { db.UserAnnouncements.Remove(item); } var number = db.SaveChanges(); return(number); } } catch (Exception) { throw; } }
public EmployeeClaim addEmpClaim(int typeId, int empId) { try { using (var db = new ProjeEntities()) { EmployeeClaim ec = new EmployeeClaim(); ec.EmployeeId = empId; ec.ClaimTypeId = typeId; db.EmployeeClaims.Add(ec); db.SaveChanges(); return(ec); } } catch (Exception) { throw; } }
public int delEmpLog(int id) { try { using (var db = new ProjeEntities()) { var el = db.LoginEmployees.Where(x => x.EmployeeId == id).ToList(); foreach (var item in el) { db.LoginEmployees.Remove(item); } var numberofdel = db.SaveChanges(); return(numberofdel); } } catch (Exception) { throw; } }
public Userr AddUser(string name, string surname, string username, string password) { try { using (var db = new ProjeEntities()) { Userr u = new Userr(); u.Name = name; u.Surname = surname; u.UserName = username; u.Password = password; db.Userrs.Add(u); db.SaveChanges(); return(u); } } catch (Exception) { throw; } }
public ClaimHoliday addHoliday(int claimId, string _start, string _finish) { try { using (var db = new ProjeEntities()) { ClaimHoliday ch = new ClaimHoliday(); ch.EmployeeClaimId = claimId; ch.FinishDate = Convert.ToDateTime(_finish); ch.StartDate = Convert.ToDateTime(_start); ch.Accept = false; db.ClaimHolidays.Add(ch); db.SaveChanges(); return(ch); } } catch (Exception) { throw; } }
public Employee UpdaEmp(Employee _emp) { try { using (var db = new ProjeEntities()) { var tempemp = db.Employees.Where(x => x.Id == _emp.Id).FirstOrDefault(); tempemp.Name = _emp.Name; tempemp.Surname = _emp.Surname; tempemp.Password = _emp.Password; tempemp.UserName = _emp.UserName; tempemp.CompanyId = _emp.CompanyId; tempemp.CardNumber = _emp.CardNumber; db.SaveChanges(); return(tempemp); } } catch (Exception) { throw; } }
public Employee AddNewEmployee(string name, string surname, string username, string password, string cardId, int companyid) { try { using (var db = new ProjeEntities()) { Employee emp = new Employee(); emp.Name = name; emp.Surname = surname; emp.UserName = username; emp.Password = password; emp.CompanyId = companyid; emp.CardNumber = cardId; db.Employees.Add(emp); db.SaveChanges(); return(emp); } } catch (Exception) { throw; } }
public Employee delEmployee(int id) { try { using (var db = new ProjeEntities()) { var emp = db.Employees.Where(x => x.Id == id).FirstOrDefault(); if (emp != null) { delEmpClaim(id); delEmpShift(id); delEmpLog(id); db.Employees.Remove(emp); db.SaveChanges(); } return(emp); } } catch (Exception) { throw; } }