public int getsetAttendance(int EId, DateTime d) { eDataContext = new EmpDalDataContext(); int i = eDataContext.getIsPresent(EId, d); return(i); }
public Employee getEmpOnId(int id) { eDataContext = new EmpDalDataContext(); var q = eDataContext.getEmpOnId(id); EmpEntity.Employee e1 = new EmpEntity.Employee(); foreach (var item in q) { e1.EmpId = Convert.ToInt32(item.EmpId); e1.FirstName = item.FirstName; e1.MiddleName = item.MiddleName; e1.LastName = item.LastName; e1.Addreee = item.Address; e1.City = item.City; e1.EmailId = item.EmailId; e1.Leaves = Convert.ToInt32(item.Leaves); e1.Picture = item.Picture; e1.Position = item.Position; e1.Salary = Convert.ToDecimal(item.Salary); e1.State = item.State; e1.ZipCode = item.ZipCode; e1.PhoneNumber = item.PhoneNumber; e1.Department = item.Department; } return(e1); }
public List<EmpEntity.Employee> getEmp(string Name) { List<EmpEntity.Employee> eList = new List<EmpEntity.Employee>(); eDataContext = new EmpDalDataContext(); var e= eDataContext.getEmp(Name); foreach (var item in e) { EmpEntity.Employee e1 = new EmpEntity.Employee(); e1.EmpId=Convert.ToInt32(item.EmpId); e1.FirstName=item.FirstName; e1.MiddleName=item.MiddleName; e1.LastName=item.LastName; e1.Addreee=item.Address; e1.Department = item.Department; e1.City=item.City; e1.EmailId=item.EmailId; e1.Leaves=Convert.ToInt32(item.Leaves); e1.Picture=item.Picture; e1.Position=item.Position; e1.Salary=Convert.ToDecimal(item.Salary); e1.State=item.State; e1.ZipCode=item.ZipCode; e1.PhoneNumber = item.PhoneNumber; eList.Add(e1); } return eList; // throw new NotImplementedException(); }
public Employee getEmpOnId(int id) { eDataContext = new EmpDalDataContext(); var q =eDataContext.getEmpOnId(id); EmpEntity.Employee e1 = new EmpEntity.Employee(); foreach (var item in q) { e1.EmpId=Convert.ToInt32(item.EmpId); e1.FirstName=item.FirstName; e1.MiddleName=item.MiddleName; e1.LastName=item.LastName; e1.Addreee=item.Address; e1.City=item.City; e1.EmailId=item.EmailId; e1.Leaves=Convert.ToInt32(item.Leaves); e1.Picture=item.Picture; e1.Position=item.Position; e1.Salary=Convert.ToDecimal(item.Salary); e1.State=item.State; e1.ZipCode=item.ZipCode; e1.PhoneNumber = item.PhoneNumber; e1.Department = item.Department; } return e1; }
public List <EmpEntity.Employee> getEmp(string Name) { List <EmpEntity.Employee> eList = new List <EmpEntity.Employee>(); eDataContext = new EmpDalDataContext(); var e = eDataContext.getEmp(Name); foreach (var item in e) { EmpEntity.Employee e1 = new EmpEntity.Employee(); e1.EmpId = Convert.ToInt32(item.EmpId); e1.FirstName = item.FirstName; e1.MiddleName = item.MiddleName; e1.LastName = item.LastName; e1.Addreee = item.Address; e1.Department = item.Department; e1.City = item.City; e1.EmailId = item.EmailId; e1.Leaves = Convert.ToInt32(item.Leaves); e1.Picture = item.Picture; e1.Position = item.Position; e1.Salary = Convert.ToDecimal(item.Salary); e1.State = item.State; e1.ZipCode = item.ZipCode; e1.PhoneNumber = item.PhoneNumber; eList.Add(e1); } return(eList); // throw new NotImplementedException(); }
public string getAuthen(string u, string p) { eDataContext = new EmpDalDataContext(); string name = string.Empty; return(name = Convert.ToString(eDataContext.GetAuthorization(u, p))); }
public int changePassword(int id, string oldpassword, string newpass) { es = new EmpDalDataContext(); int i = Convert.ToInt32(es.changePassword(id.ToString(), oldpassword, newpass)); return(i); }
public int getNoofDaysAttendedMonth(int empId, int mm) { es = new EmpDalDataContext(); var Adays = es.GetSalaryonAttend(empId, mm); int k = Adays.Count(); return(k); }
public bool updateEmp(EmpEntity.Employee e) { eDataContext = new EmpDalDataContext(); eDataContext.UpdateEmp(e.EmpId, e.FirstName, e.MiddleName, e.LastName, e.Addreee, e.City, e.ZipCode, e.State, e.PhoneNumber, e.EmailId, e.Department, e.Picture, e.Salary, e.Leaves, e.Position); eDataContext.SubmitChanges(); return(true); //throw new NotImplementedException(); }
public bool insertLeave(EmpLeave el) { eDataContext = new EmpDalDataContext(); eDataContext.InsertLeave(el.EmpId, el.FromDate, el.ToDate, el.Descr); eDataContext.SubmitChanges(); return(true); }
public decimal getSalaryPerHour(int Eid) { eDataContext = new EmpDalDataContext(); var we = eDataContext.GetSalary(Eid); decimal s = Convert.ToDecimal(we.First().Salary); return(s); }
public bool deleteEmp(int id) { eDataContext = new EmpDalDataContext(); eDataContext.DeleteEmployee(id); eDataContext.SubmitChanges(); return(true); // throw new NotImplementedException(); }
public bool deleteEmp(int id) { eDataContext = new EmpDalDataContext(); eDataContext.DeleteEmployee(id); eDataContext.SubmitChanges(); return true; // throw new NotImplementedException(); }
public EmpEntity.Employee getEmpOName(string emp) { es = new EmpDalDataContext(); //var eea = es.getEmpOnName(emp); //EmpEntity.Employee e1 = new EmpEntity.Employee(); //foreach (var item in eea) //{ // e1.FirstName = item.FirstName; // e1.MiddleName = item.MiddleName; // e1.LastName = item.LastName; // e1.Addreee = item.Address; // e1.City = item.City; // e1.EmailId = item.EmailId; // e1.EmpId = Convert.ToInt32(item.EmpId); // e1.Leaves = Convert.ToInt32(item.Leaves); // e1.Picture = item.Picture; // e1.Position = item.Position; // e1.Salary = Convert.ToDecimal(item.Salary); // e1.State = item.State; // e1.ZipCode = item.ZipCode; // e1.PhoneNumber = item.PhoneNumber; //} //return e1; var eea = (from userChallenge in es.EmpDetails where userChallenge.FirstName == emp select userChallenge).FirstOrDefault(); EmpEntity.Employee e1 = new EmpEntity.Employee(); if (eea != null) { if (eea.EmpId != 0) { e1.FirstName = eea.FirstName; e1.MiddleName = eea.MiddleName; e1.LastName = eea.LastName; e1.Addreee = eea.Address; e1.City = eea.City; e1.EmailId = eea.EmailId; e1.EmpId = Convert.ToInt32(eea.EmpId); e1.Leaves = Convert.ToInt32(eea.Leaves); e1.Picture = eea.Picture; e1.Position = eea.Position; e1.Salary = Convert.ToDecimal(eea.Salary); e1.State = eea.State; e1.ZipCode = eea.ZipCode; e1.PhoneNumber = eea.PhoneNumber; e1.Department = eea.Department; } } return(e1); }
public string getAuthen(string u, string p) { es= new EmpDalDataContext(); string name = string.Empty; var e = (es.GetAuthorization(u, p)); foreach (var item in e) { name = item.username.ToString(); } return name; }
public EmpEntity.Employee getEmpOName(string emp) { es = new EmpDalDataContext(); //var eea = es.getEmpOnName(emp); //EmpEntity.Employee e1 = new EmpEntity.Employee(); //foreach (var item in eea) //{ // e1.FirstName = item.FirstName; // e1.MiddleName = item.MiddleName; // e1.LastName = item.LastName; // e1.Addreee = item.Address; // e1.City = item.City; // e1.EmailId = item.EmailId; // e1.EmpId = Convert.ToInt32(item.EmpId); // e1.Leaves = Convert.ToInt32(item.Leaves); // e1.Picture = item.Picture; // e1.Position = item.Position; // e1.Salary = Convert.ToDecimal(item.Salary); // e1.State = item.State; // e1.ZipCode = item.ZipCode; // e1.PhoneNumber = item.PhoneNumber; //} //return e1; var eea = (from userChallenge in es.EmpDetails where userChallenge.FirstName == emp select userChallenge).FirstOrDefault(); EmpEntity.Employee e1 = new EmpEntity.Employee(); if (eea!=null) { if (eea.EmpId != 0) { e1.FirstName = eea.FirstName; e1.MiddleName = eea.MiddleName; e1.LastName = eea.LastName; e1.Addreee = eea.Address; e1.City = eea.City; e1.EmailId = eea.EmailId; e1.EmpId = Convert.ToInt32(eea.EmpId); e1.Leaves = Convert.ToInt32(eea.Leaves); e1.Picture = eea.Picture; e1.Position = eea.Position; e1.Salary = Convert.ToDecimal(eea.Salary); e1.State = eea.State; e1.ZipCode = eea.ZipCode; e1.PhoneNumber = eea.PhoneNumber; e1.Department = eea.Department; } } return e1; }
public string getAuthen(string u, string p) { es = new EmpDalDataContext(); string name = string.Empty; var e = (es.GetAuthorization(u, p)); foreach (var item in e) { name = item.username.ToString(); } return(name); }
public bool getIsAdmin(string uu, string pp) { es = new EmpDalDataContext(); var e = (es.GetIsAdmin(uu, pp)); bool q = false; foreach (var item in e) { q = Convert.ToBoolean(item.IsAdmin); } return(q); }
public int getNextEmpId() { es = new EmpDalDataContext(); var eea = es.EmpDetails.OrderByDescending(i => i.EmpId).FirstOrDefault(); if (eea == null) { return(99999999); } return(eea.EmpId); //select userChallenge).FirstOrDefault(); }
public int getSalaryForDays(int Eid, int month) { eDataContext = new EmpDalDataContext(); List <EmpSal> esalList = new List <EmpSal>(); var s = eDataContext.GetLeavesApplied(Eid, month); // TimeSpan t; int Leaves = 0; foreach (var item in s) { DateTime d1 = Convert.ToDateTime(item.FromDate); DateTime d2 = Convert.ToDateTime(item.ToDate); TimeSpan d3 = d2 - d1; Leaves += d3.Days; } return(Leaves); }
public List <EmpLeave> getLeavesTaken(int id) { eDataContext = new EmpDalDataContext(); List <EmpLeave> eList = new List <EmpLeave>(); var w = eDataContext.getLeaves(id); foreach (var item in w) { EmpLeave ea = new EmpLeave(); ea.EmpId = Convert.ToInt32(item.EmpId); ea.FromDate = Convert.ToDateTime(item.FromDate); ea.ToDate = Convert.ToDateTime(item.ToDate); ea.Descr = item.Reason.ToString(); eList.Add(ea); } return(eList); }
public string getAuthen(string u, string p) { eDataContext = new EmpDalDataContext(); string name= string.Empty; return name= Convert.ToString( eDataContext.GetAuthorization(u,p)); }
public int changePassword(int id, string oldpassword, string newpass) { es = new EmpDalDataContext(); int i= Convert.ToInt32( es.changePassword(id.ToString(),oldpassword,newpass)); return i; }
public void insertEmail(string EmailBody) { es = new EmpDalDataContext(); es.InsertEmailLog(EmailBody); }
public int getNoofDaysAttendedMonth(int empId, int mm) { es = new EmpDalDataContext(); var Adays = es.GetSalaryonAttend(empId,mm); int k = Adays.Count(); return k; }
public int getNextEmpId() { es= new EmpDalDataContext(); var eea = es.EmpDetails.OrderByDescending(i=>i.EmpId).FirstOrDefault(); if (eea==null) { return 99999999; } return eea.EmpId; //select userChallenge).FirstOrDefault(); }
public int getsetAttendance(int EId, DateTime d) { eDataContext = new EmpDalDataContext(); int i = eDataContext.getIsPresent(EId, d); return i; }
public bool insertLeave(EmpLeave el) { eDataContext = new EmpDalDataContext(); eDataContext.InsertLeave(el.EmpId,el.FromDate,el.ToDate,el.Descr); eDataContext.SubmitChanges(); return true; }
public bool updateEmp(EmpEntity.Employee e) { eDataContext = new EmpDalDataContext(); eDataContext.UpdateEmp(e.EmpId,e.FirstName, e.MiddleName, e.LastName, e.Addreee, e.City, e.ZipCode, e.State, e.PhoneNumber, e.EmailId, e.Department, e.Picture, e.Salary, e.Leaves, e.Position); eDataContext.SubmitChanges(); return true; //throw new NotImplementedException(); }
public List<EmpLeave> getLeavesTaken(int id) { eDataContext = new EmpDalDataContext(); List<EmpLeave> eList = new List<EmpLeave>(); var w= eDataContext.getLeaves(id); foreach (var item in w) { EmpLeave ea = new EmpLeave(); ea.EmpId = Convert.ToInt32(item.EmpId); ea.FromDate =Convert.ToDateTime( item.FromDate); ea.ToDate =Convert.ToDateTime( item.ToDate); ea.Descr = item.Reason.ToString(); eList.Add(ea); } return eList; }
public decimal getSalaryPerHour(int Eid) { eDataContext = new EmpDalDataContext(); var we = eDataContext.GetSalary(Eid); decimal s = Convert.ToDecimal(we.First().Salary); return s; }
public bool getIsAdmin(string uu, string pp) { es = new EmpDalDataContext(); var e=(es.GetIsAdmin(uu,pp)); bool q=false; foreach (var item in e) { q= Convert.ToBoolean( item.IsAdmin); } return q; }
public int getSalaryForDays(int Eid, int month) { eDataContext = new EmpDalDataContext(); List<EmpSal> esalList = new List<EmpSal>(); var s = eDataContext.GetLeavesApplied(Eid,month); // TimeSpan t; int Leaves = 0; foreach (var item in s) { DateTime d1 = Convert.ToDateTime(item.FromDate); DateTime d2 =Convert.ToDateTime( item.ToDate); TimeSpan d3 = d2 - d1; Leaves += d3.Days; } return Leaves; }