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