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