public JsonResult DelShift(int _id) { try { using (var pe = new ProjeEntities()) { var s = pe.Shifts.FirstOrDefault(x => x.Id == _id); var empS = pe.EmployeeShifts.Where(x => x.ShiftId == s.Id).ToList(); foreach (var item in empS) { pe.EmployeeShifts.Remove(item); } pe.SaveChanges(); var sp = pe.ShiftPrices.FirstOrDefault(x => x.ShiftId == s.Id); var cs = pe.CompanyShifts.FirstOrDefault(x => x.ShiftId == s.Id); pe.ShiftPrices.Remove(sp); pe.CompanyShifts.Remove(cs); pe.SaveChanges(); pe.Shifts.Remove(s); pe.SaveChanges(); return(Json("Del")); } } catch (Exception) { throw; } }
public ActionResult Design(Employee employee) { try { using (ProjeEntities pe = new ProjeEntities()) { Employee emp = pe.Employees.FirstOrDefault(x => x.Id == employee.Id); List <EmployeeShift> lshift = pe.EmployeeShifts.Include("Shift").Where(x => x.EmployeeId == emp.Id).ToList(); List <EmployeeClaim> lclaim = pe.EmployeeClaims.Include("ClaimType").Include("ClaimOthers").Include("ClaimHolidays").Where(x => x.EmployeeId == emp.Id).ToList(); foreach (var cl in lclaim) { foreach (var info in cl.ClaimOthers) { } } ViewBag.Shift = lshift; ViewBag.Claim = lclaim; return(View(emp)); } } catch (Exception) { throw; } }
// GET: CardReader public ActionResult Index() { try { using (var db = new ProjeEntities()) { var user = Session["User"] as Userr; var usc = Session["UserCompany"] as UserCompany; var lEmployee = db.Employees.Where(x => x.CompanyId == usc.Company.Id).ToList(); ViewBag.lEmployee = lEmployee; var lShift = db.Companies.Include("CompanyShifts").Include("CompanyShifts.Shift").Where(x => x.Id == usc.Company.Id).ToList(); ViewBag.lShift = lShift; var empList = db.Employees.Include("EmployeeShifts").Include("EmployeeShifts.Shift").Where(x => x.CompanyId == usc.Company.Id).ToList(); ViewBag.empList = empList; //foreach (var item in lShift) //{ // foreach (var item2 in item.CompanyShifts) // { // item2.Shift.Name // } //} } return(View()); } catch (Exception) { throw; } }
public JsonResult AddShift(string name, string price, string cardname) { try { using (ProjeEntities pe = new ProjeEntities()) { var ch = pe.Shifts.Where(x => x.ShiftNumber == cardname).FirstOrDefault(); if (ch == null) { var cus = Session["UserCompany"] as UserCompany; var lshift = pe.CompanyShifts.Include("Shift").Where(x => x.CompanyId == cus.Company.Id).ToList(); var dbo = ProjeDB.DBO.GetInstance(); var sh = dbo.AddShift(name, cardname); var shp = dbo.AddShiftPrice(sh.Id, price); var cs = dbo.addCompanyShift((int)cus.CompanyId, sh.Id); return(Json("True")); } else { return(Json("False")); } } } catch (Exception) { throw; } }
public JsonResult AddAnnouncements(string _type, string _textArea, string _title) { try { using (ProjeEntities db = new ProjeEntities()) { var user = Session["User"] as Userr; var usc = Session["UserCompany"] as UserCompany; var LAnnouncementType = db.Companies.Include("CompanyAnnouncements").Include("CompanyAnnouncements.Announcement").Where(X => X.Id == usc.Id).ToList(); int typeid = db.Announcements.Where(x => x.Name == _type).Select(z => z.Id).FirstOrDefault(); UserAnnouncement us = new UserAnnouncement(); us.AnnouncementId = typeid; us.UserId = user.Id; us.Details = _textArea; us.Title = _title; db.UserAnnouncements.Add(us); db.SaveChanges(); return(Json("Add")); } } catch (Exception) { throw; } }
// GET: Claim public ActionResult Index() { try { using (var db = new ProjeEntities()) { var emp = Session["emp"] as Employee; var ct = db.ClaimTypes.ToList(); List <MVCProje.Models.ClaimType> ctt = new List <MVCProje.Models.ClaimType>(); foreach (ProjeDB.ClaimType item in ct) { ctt.Add(new Models.ClaimType { Id = item.Id, Name = item.Name }); } List <Models.ClaimOther> co = new List <Models.ClaimOther>(); List <Models.ClaimHoliday> ch = new List <Models.ClaimHoliday>(); var clistother = db.EmployeeClaims.Where(x => x.EmployeeId == emp.Id).Where(z => z.ClaimTypeId == 1).ToList(); var clistholiday = db.EmployeeClaims.Where(x => x.EmployeeId == emp.Id).Where(z => z.ClaimTypeId == 2).ToList(); var dbo = DBO.GetInstance(); foreach (var item in clistholiday) { var returnch = dbo.getCholidaybyId(item.Id); Models.ClaimHoliday mch = new Models.ClaimHoliday(); mch.Id = returnch.Id; mch.Start = Convert.ToDateTime(returnch.StartDate); mch.Finish = Convert.ToDateTime(returnch.FinishDate); mch.Accept = (Boolean)returnch.Accept; ch.Add(mch); } foreach (var item in clistother) { var returnch = dbo.getCOtherbyId(item.Id); Models.ClaimOther mco = new Models.ClaimOther(); mco.Id = returnch.Id; mco.Details = returnch.Details; co.Add(mco); } MVCProje.Models.ClaimModel Cmodel = new ClaimModel(); Cmodel.ClaimTypeModel = ctt; Cmodel.ClaimHolidayModel = ch; Cmodel.ClaimOtherModel = co; return(View(Cmodel)); } } catch (Exception) { throw; } }
public ActionResult Index() { try { using (ProjeEntities db = new ProjeEntities()) { var empc = Session["empCompany"] as Company; var emp = Session["emp"] as Employee; if (emp == null) { Response.Redirect("~/Login/Index"); } var cu = db.Companies.Include("UserCompanies").Include("UserCompanies.Userr").Where(z => z.Id == emp.CompanyId).ToList(); var ua = db.Userrs.Include("UserAnnouncements").Include("UserAnnouncements.Announcement").ToList(); var modelList = new List <AnnouncementsModel>(); foreach (var item in ua) { var lua = new List <DetailsAndTitle>(); foreach (var item2 in cu) { foreach (var item3 in item2.UserCompanies) { if (item.Id == item3.Userr.Id) { foreach (var item4 in item.UserAnnouncements) { var dat = new DetailsAndTitle(); dat.Details = item4.Details; dat.Title = item4.Title; dat.Id = item4.Id; lua.Add(dat); } AnnouncementsModel a = new AnnouncementsModel() { UserName = new Userr() { Id = item.Id, Name = item.Name }, DetailsAndTitle = lua }; modelList.Add(a); } } } } return(View(emp)); } } catch (Exception) { throw; } }
public JsonResult DelEmp(int id) { using (var db = new ProjeEntities()) { var dbo = DBO.GetInstance(); var cus = Session["UserCompany"] as UserCompany; var delClaim = dbo.delEmployee(id); db.SaveChanges(); return(Json("")); } }
public ActionResult returnAddAnn() { try { using (var db = new ProjeEntities()) { return(PartialView("_returnAddAnn")); } } catch (Exception) { throw; } }
public ActionResult returnHoliday() { try { using (var db = new ProjeEntities()) { return(PartialView("_HolidayClaim")); } } catch (Exception) { throw; } }
// GET: Home public ActionResult Index() { try { using (ProjeEntities pe = new ProjeEntities()) { var cus = Session["UserCompany"] as UserCompany; List <Employee> EmployeeList = pe.Employees.Where(x => x.CompanyId == cus.Company.Id).ToList(); ViewBag.EmployeeList = EmployeeList; return(View()); } } catch (Exception) { throw; } }
public JsonResult AccepFalse(int id) { try { using (var db = new ProjeEntities()) { var dbo = DBO.GetInstance(); var holiday = dbo.returnFalse(id); return(Json("")); } } catch (Exception) { throw; } }
public ActionResult Autherize(String _username, String _pass) { try { using (ProjeEntities db = new ProjeEntities()) { _username = Request.Form["_username"]; _pass = Request.Form["_pass"]; var userDetails = db.Userrs.Where(x => x.UserName == _username && x.Password == _pass).FirstOrDefault(); var empDetails = db.Employees.Where(x => x.UserName == _username && x.Password == _pass).FirstOrDefault(); if (userDetails != null) { var user = db.UserCompanies.Include("Company").Where(x => x.UserId == userDetails.Id).FirstOrDefault(); Session["UserName"] = userDetails.Name; Session["UserSurname"] = userDetails.Surname; Session["CompanyName"] = user.Company.Name; Session["UserCompany"] = user; Session["User"] = userDetails; Session["Check"] = "User"; return(RedirectToAction("Index", "User")); } else if (empDetails != null) { Session["empCompany"] = db.Companies.Where(x => x.Id == empDetails.CompanyId).Select(x => x.Name).FirstOrDefault(); Session["emp"] = empDetails; Session["Check"] = "Emp"; Session["UserName"] = empDetails.Name; Session["UserSurname"] = empDetails.Surname; var compname = db.Companies.Where(x => x.Id == empDetails.CompanyId).Select(x => x.Name).FirstOrDefault(); Session["CompanyName"] = compname; return(RedirectToAction("Index", "Employee")); } else { return(View("Index")); } } } catch (Exception exec) { throw; } }
public ActionResult Property() { var cus = Session["UserCompany"] as UserCompany; Models.PropertyModel pm = new Models.PropertyModel(); List <Models.ShiftType> sl = new List <Models.ShiftType>(); List <Models.AnnouncementType> al = new List <Models.AnnouncementType>(); var dbo = ProjeDB.DBO.GetInstance(); using (ProjeEntities db = new ProjeEntities()) { var shift = db.Companies.Include("CompanyShifts").Include("CompanyShifts.Shift").Where(x => x.Id == cus.CompanyId).ToList(); foreach (var item in shift) { foreach (var item2 in item.CompanyShifts) { var p = dbo.getPrice(item2.Shift.Id); Models.ShiftType s = new Models.ShiftType(); s.Id = item2.Shift.Id; s.Name = item2.Shift.Name; s.Price = (int)p.Price; s.CardName = item2.Shift.ShiftNumber; sl.Add(s); } } var ann = db.Companies.Include("CompanyAnnouncements").Include("CompanyAnnouncements.Announcement").Where(z => z.Id == cus.CompanyId).ToList(); foreach (var item in ann) { foreach (var item2 in item.CompanyAnnouncements) { Models.AnnouncementType a = new Models.AnnouncementType(); a.Id = item2.Announcement.Id; a.Name = item2.Announcement.Name; al.Add(a); } } pm.ShiftList = sl; pm.AnnList = al; return(View(pm)); } }
public ActionResult returnClaim() { try { using (var db = new ProjeEntities()) { var emp = Session["emp"] as Employee; int _id = emp.Id; var lclaim = db.EmployeeClaims.Include("ClaimType").Include("ClaimOthers").Include("ClaimHolidays").Where(x => x.EmployeeId == _id).ToList(); return(PartialView("_EmpClaim", lclaim)); } } catch (Exception) { throw; } }
public JsonResult AddAnn(string name) { try { using (var db = new ProjeEntities()) { var cus = Session["UserCompany"] as UserCompany; var dbo = ProjeDB.DBO.GetInstance(); var a = dbo.AddAnn(name); var ca = dbo.AddAnnCompany(a.Id, (int)cus.CompanyId); return(Json("")); } } catch (Exception) { throw; } }
public ActionResult returnLog() { try { using (var db = new ProjeEntities()) { var emp = Session["emp"] as Employee; var emplogin = db.LoginEmployees.Where(x => x.EmployeeId == emp.Id).ToList(); return(PartialView("_EmpLog", emplogin)); } } catch (Exception) { throw; } }
public JsonResult addHoliday(string _typename, string _start, string _finish) { try { using (var db = new ProjeEntities()) { int _typeid = db.ClaimTypes.Where(z => z.Name == _typename).Select(x => x.Id).FirstOrDefault(); var emp = Session["emp"] as Employee; var dba = DBO.GetInstance(); var st = dba.addEmpClaim(_typeid, emp.Id); dba.addHoliday(st.Id, _start, _finish); return(Json("")); } } catch (Exception) { throw; } }
private void timer1_Tick(object sender, EventArgs e) { try { using (var db = new ProjeEntities()) { if (label1.Text != null) { label1.Text = null; label2.Text = null; label3.Text = null; label4.Text = null; } r.Connect(); var id = r.GetCardUID(); var emp = db.Employees.FirstOrDefault(x => x.CardNumber == id); if (emp != null) { label1.Text = emp.Name; label2.Text = emp.Surname; label3.Text = emp.CardNumber; LoginEmployee l = new LoginEmployee(); l.EmployeeId = emp.Id; DateTime localDate = DateTime.Now; l.Date = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss").ToString()); label4.Text = Convert.ToString(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss").ToString())); var s = r.Watch(); label4.Text = s; var sname = db.Shifts.Where(x => x.ShiftNumber == s).FirstOrDefault(); l.Shiftname = sname.Name; db.LoginEmployees.Add(l); db.SaveChanges(); } } } catch (Exception) { throw; } }
public JsonResult upde(string name, string surname, string username, string password, int id) { try { using (var db = new ProjeEntities()) { var emp = db.Employees.FirstOrDefault(x => x.Id == id); emp.Name = name; emp.Surname = surname; emp.Password = password; emp.UserName = username; db.SaveChanges(); return(Json("")); } } catch (Exception) { throw; } }
public JsonResult DeleteAnnouncements(int _id) { try { using (ProjeEntities db = new ProjeEntities()) { var ann = db.UserAnnouncements.Where(x => x.Id == _id).FirstOrDefault(); db.UserAnnouncements.Remove(ann); db.SaveChanges(); return(Json("Delete")); } } catch (Exception) { throw; } }
public JsonResult AddEmployeeShift(string _cardId, string _shiftid, string _start, string _finish) { try { using (var db = new ProjeEntities()) { EmployeeShift es = new EmployeeShift(); es.ShiftId = db.Shifts.Where(x => x.Name == _shiftid).Select(x => x.Id).FirstOrDefault(); es.EmployeeId = db.Employees.Where(x => x.CardNumber == _cardId).Select(x => x.Id).FirstOrDefault(); es.Finish = Convert.ToDateTime(_finish); es.Start = Convert.ToDateTime(_start); db.EmployeeShifts.Add(es); db.SaveChanges(); } } catch (Exception) { throw; } return(Json("a")); }
public ActionResult returnShift() { try { using (var db = new ProjeEntities()) { var emp = Session["emp"] as Employee; emp.Name = emp.Name.ToString(); emp.Surname = emp.Surname.ToString(); int _id = emp.Id; var lshift = db.EmployeeShifts.Include("Shift").Include("Shift.ShiftPrices").Where(x => x.EmployeeId == _id).ToList(); return(PartialView("_EmpShift", lshift)); } } catch (Exception) { throw; } }
public JsonResult fillemp(int id) { try { using (var db = new ProjeEntities()) { var dbo = DBO.GetInstance(); var _emp = dbo.getEmployee(id); Employee emp = new Employee(); emp.Name = _emp.Name; emp.Id = _emp.Id; emp.Surname = _emp.Surname; emp.UserName = _emp.UserName; emp.Password = _emp.Password; return(Json(emp)); } } catch (Exception) { throw; } }
public JsonResult AddCompany(string name, string surname, string username, string password, string cname) { try { using (var db = new ProjeEntities()) { var dbo = DBO.GetInstance(); var u = dbo.AddUser(name, surname, username, password); var c = dbo.AddCompamy(cname); UserCompany uc = new UserCompany(); uc.UserId = u.Id; uc.CompanyId = c.Id; db.UserCompanies.Add(uc); db.SaveChanges(); return(Json("")); } } catch (Exception) { throw; } }
public JsonResult DelAnn(int id) { try { using (var db = new ProjeEntities()) { var cus = Session["UserCompany"] as UserCompany; var dbo = ProjeDB.DBO.GetInstance(); var ua = dbo.delUserAnn(id); var c = dbo.delAnnCom(id); var a = db.Announcements.FirstOrDefault(x => x.Id == id); db.Announcements.Remove(a); db.SaveChanges(); return(Json("")); } } catch (Exception) { throw; } }
public JsonResult AddUsers(string name, string surname, string username, string password) { try { using (ProjeEntities db = new ProjeEntities()) { var dbo = DBO.GetInstance(); var cus = Session["UserCompany"] as UserCompany; var u = dbo.AddUser(name, surname, username, password); UserCompany uc = new UserCompany(); uc.UserId = u.Id; uc.CompanyId = (int)cus.CompanyId; db.UserCompanies.Add(uc); db.SaveChanges(); return(Json("")); } } catch (Exception exe) { throw; } }
// GET: UserClaim public ActionResult Index() { try { using (var db = new ProjeEntities()) { var emp = Session["User"] as Userr; var usercompany = Session["UserCompany"] as UserCompany; var clistother = db.Employees.Include("EmployeeClaims").Where(x => x.CompanyId == usercompany.CompanyId).ToList(); List <EmployeeClaimOtherList> ecl = new List <EmployeeClaimOtherList>(); List <EmployeeClaimHolidayList> echl = new List <EmployeeClaimHolidayList>(); var dbo = DBO.GetInstance(); //foreach (var item in clistholiday) //{ // var returnch = dbo.getCholidaybyId(item.Id); // Models.ClaimHoliday mch = new Models.ClaimHoliday(); // mch.Id = returnch.Id; // mch.Start = Convert.ToDateTime(returnch.StartDate); // mch.Finish = Convert.ToDateTime(returnch.FinishDate); // ch.Add(mch); //} foreach (var item in clistother) { foreach (var item2 in item.EmployeeClaims) { if (item2.ClaimTypeId == 1) { var returnch = dbo.getCOtherbyId(item2.Id); Models.EmployeeClaimOtherList ec = new Models.EmployeeClaimOtherList(); ec.Name = item.Name + "" + item.Surname; ec.Details = returnch.Details; ecl.Add(ec); } else { var returnch = dbo.getCholidaybyId(item2.Id); Models.EmployeeClaimHolidayList ec = new Models.EmployeeClaimHolidayList(); ec.Name = item.Name + "" + item.Surname; ec.Finish = Convert.ToDateTime(returnch.FinishDate); ec.Start = Convert.ToDateTime(returnch.StartDate); ec.Check = (Boolean)returnch.Accept; ec.Id = returnch.Id; echl.Add(ec); } } } MVCProje.Models.ClaimListUserModel Cmodel = new ClaimListUserModel(); Cmodel.HolidayClaim = echl; Cmodel.OtherClaim = ecl; return(View(Cmodel)); } } catch (Exception) { throw; } }
// GET: Announcement public ActionResult Index() { try { using (ProjeEntities db = new ProjeEntities()) { var usc = Session["UserCompany"] as UserCompany; var aaa = db.Companies.Include("UserCompanies").Include("UserCompanies.Userr").Where(z => z.Id == usc.Company.Id).ToList(); var bbb = db.Userrs.Include("UserAnnouncements").Include("UserAnnouncements.Announcement").ToList(); var LAnnouncementType = db.Companies.Include("CompanyAnnouncements").Include("CompanyAnnouncements.Announcement").Where(X => X.Id == usc.CompanyId).ToList(); ViewBag.La = LAnnouncementType; //foreach (var item in LAnnouncementType) //{ // foreach (var item2 in item.CompanyAnnouncements) // { // item2.Announcement.Name // } //} var modelList = new List <AnnouncementsModel>(); foreach (var item in bbb) { var lua = new List <DetailsAndTitle>(); foreach (var item2 in aaa) { foreach (var item3 in item2.UserCompanies) { if (item.Id == item3.Userr.Id) { foreach (var item4 in item.UserAnnouncements) { var dat = new DetailsAndTitle(); dat.Details = item4.Details; dat.Title = item4.Title; dat.Id = item4.Id; lua.Add(dat); } AnnouncementsModel a = new AnnouncementsModel() { UserName = new Userr() { Id = item.Id, Name = item.Name }, DetailsAndTitle = lua }; modelList.Add(a); } } } } ViewBag.comb = modelList; //foreach (var item in modelList) //{ // foreach (var item2 in item.DetailsAndTitle) // { // } //} return(View()); } } catch (Exception) { throw; } }