public static BLL.ViewModels.CreatePreVisitors getHosts(string companyId) { List <DLL.Model.Hosts> hosts = new List <DLL.Model.Hosts>(); try { using (var db = new DLL.Model.Context()) { hosts = db.Hosts.Where(m => m.Company_ID.Equals(companyId)).ToList(); } } catch { hosts = null; } int totalHosts = hosts.Count(); BLL.ViewModels.CreatePreVisitors toReturn = new ViewModels.CreatePreVisitors(); for (int i = 0; i < totalHosts; i++) { toReturn.hosts.Add(new BLL.ViewModels.Hosts { Company_ID = hosts[i].Company_ID, EmpCode = hosts[i].EmpCode, hFirst = hosts[i].hFirst, hLast = hosts[i].hLast, EmpID = hosts[i].EmpID }); } return(toReturn); }
// for to and from date values public static List <BLL.ViewModels.PreVisitors> getPreVisitors(string from_date, string to_date) { List <BLL.ViewModels.PreVisitors> toreturn = new List <ViewModels.PreVisitors>(); List <DLL.Model.PreVisitors> entity = new List <DLL.Model.PreVisitors>(); try { DateTime from = from_date != null || from_date != ""? DateTime.Parse(from_date):DateTime.Parse("1999-01-01"); DateTime to = to_date != null || to_date != "" ? DateTime.Parse(to_date) : DateTime.Parse("1999-01-01"); if ((from_date == null || from_date == "") || (to_date == null || to_date == "")) { return(getPreVisitors()); } using (var db = new DLL.Model.Context()) { entity = db.previsitors.Where(m => m.status == true && m.Date >= from && m.Date <= to).ToList(); int entityCount = entity.Count(); for (int i = 0; i < entityCount; i++) { int userId = int.Parse(entity[i].CreatedBy); toreturn.Add(new ViewModels.PreVisitors { ID = entity[i].ID, VNIC = entity[i].VNIC, Vaddress = entity[i].Vaddress, Vcompany = entity[i].Vcompany, VfirstName = entity[i].VfirstName, VlastName = entity[i].VlastName, VphoneNo = entity[i].VphoneNo, Date = entity[i].Date, Time = entity[i].Time, host_email = entity[i].hemail, CreatedBy = db.Users.Where(m => m.UsersId.Equals(userId)).FirstOrDefault().name, host_name = entity[i].hFirstName + " " + entity[i].hLastName, // hfloor = db.Company.Where(m=>m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().FloorID, host_company = entity[i].hcompany, status = true, }); } } } catch (Exception ex) { return(null); } return(toreturn); }
public static int deleteVisitor(int id) { using (var db = new DLL.Model.Context()) { var visitor = db.previsitors.Find(id); if (visitor != null) { visitor.status = false; db.SaveChanges(); return(id); } else { return(-1); } } }
// for to and from date time View public static List <BLL.ViewModels.PreVisitors> getPreVisitors(string name, string from_date, string to_date) { List <BLL.ViewModels.PreVisitors> toreturn = new List <ViewModels.PreVisitors>(); List <DLL.Model.PreVisitors> entity = new List <DLL.Model.PreVisitors>(); try { DateTime from = DateTime.Parse(from_date); DateTime to = DateTime.Parse(to_date); using (var db = new DLL.Model.Context()) { var user = db.Users.Where(m => m.name.Equals(name)).FirstOrDefault(); string id = user.UsersId.ToString(); entity = db.previsitors.Where(m => m.CreatedBy.Equals(id) && m.Date >= from && m.Date <= to && m.status == true).ToList(); } int entityCount = entity.Count(); for (int i = 0; i < entityCount; i++) { toreturn.Add(new ViewModels.PreVisitors { ID = entity[i].ID, VNIC = entity[i].VNIC, Vaddress = entity[i].Vaddress, Vcompany = entity[i].Vcompany, VfirstName = entity[i].VfirstName, VlastName = entity[i].VlastName, VphoneNo = entity[i].VphoneNo, Date = entity[i].Date, Time = entity[i].Time, host_email = entity[i].hemail, CreatedBy = entity[i].CreatedBy, host_name = entity[i].hFirstName + " " + entity[i].hLastName, // hfloor = db.Company.Where(m=>m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().FloorID, host_company = entity[i].hcompany, status = true }); } } catch (Exception ex) { return(null); } return(toreturn); }
public static bool addMultipleVisitor(List <BLL.ViewModels.AddMultipleVisitor> previsitors) { try { using (var db = new DLL.Model.Context()) { foreach (var visitor in previsitors) { var hostdetail = db.Hosts.Find(visitor.host_id); DateTime from = DateTime.ParseExact(visitor.from_Date, "d-M-yyyy", CultureInfo.InvariantCulture); DateTime to = DateTime.ParseExact(visitor.to_date, "d-M-yyyy", CultureInfo.InvariantCulture); int totaldays = to.Subtract(from).Days; for (int i = 0; i <= totaldays; i++) { DateTime check = from.AddDays(i); db.previsitors.Add(new DLL.Model.PreVisitors { VNIC = visitor.VNIC, Vaddress = visitor.Vaddress, Vcompany = visitor.Vcompany, VfirstName = visitor.VfirstName, VlastName = visitor.VlastName, VphoneNo = visitor.VphoneNo, Date = from.AddDays(i), Time = visitor.Time, hemail = visitor.host_email, CreatedBy = visitor.CreatedBy, hFirstName = hostdetail.hFirst, hLastName = hostdetail.hLast, // hfloor = db.Company.Where(m=>m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().FloorID, hcompany = db.Company.Where(m => m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().CompanyName, status = true }); } } db.SaveChanges(); } } catch (Exception ex) { return(false); } return(true); }
public static BLL.ViewModels.Users getUser(string name) { BLL.ViewModels.Users toreturn = new ViewModels.Users(); try { using (var db = new DLL.Model.Context()) { var entity = db.Users.Where(m => m.name.Equals(name) && m.active == true).FirstOrDefault(); toreturn.acessgroup_id = entity.accessGroup.AccessGroupId; toreturn.active = entity.active; toreturn.company_id = entity.company.company_id; toreturn.name = entity.name; toreturn.password = entity.password; toreturn.userId = entity.UsersId; } } catch (Exception ex) { toreturn = null; } return(toreturn); }
public static int editVisitor(BLL.ViewModels.PreVisitors visitor) { try { using (var db = new DLL.Model.Context()) { var entity = db.previsitors.Find(visitor.ID); var hostdetail = db.Hosts.Find(visitor.host_id); if (entity != null) { entity.VNIC = visitor.VNIC; entity.Vaddress = visitor.Vaddress; entity.Vcompany = visitor.Vcompany; entity.VfirstName = visitor.VfirstName; entity.VlastName = visitor.VlastName; entity.VphoneNo = visitor.VphoneNo; entity.hemail = visitor.host_email; entity.Time = visitor.Time; entity.hFirstName = hostdetail.hFirst; entity.hLastName = hostdetail.hLast; entity.Date = DateTime.ParseExact(visitor.from_Date, "d-M-yyyy", CultureInfo.InvariantCulture); // hfloor = db.Company.Where(m=>m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().FloorID, entity.hcompany = db.Company.Where(m => m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().CompanyName; entity.status = true; db.SaveChanges(); return(entity.ID); } else { return(-1); } } } catch (Exception ex) { return(-1); } }
public static BLL.ViewModels.EditViewModel getPreVisitorsById(int id) { BLL.ViewModels.EditViewModel toreturn = null; DLL.Model.PreVisitors entity = new DLL.Model.PreVisitors(); string company_id = null; try { using (var db = new DLL.Model.Context()) { entity = db.previsitors.Where(m => m.ID.Equals(id) && m.status == true).FirstOrDefault(); string name = entity.hcompany; var company = db.Company.Where(m => m.CompanyName.Equals(name)).FirstOrDefault(); company_id = company.company_id; } toreturn = new BLL.ViewModels.EditViewModel { ID = entity.ID, VNIC = entity.VNIC, Vaddress = entity.Vaddress, Vcompany = entity.Vcompany, VfirstName = entity.VfirstName, VlastName = entity.VlastName, VphoneNo = entity.VphoneNo, host_name = entity.hFirstName + " " + entity.hLastName, host_email = entity.hemail, date = entity.Date.ToString(), time = entity.Time, // hfloor = db.Company.Where(m=>m.company_id.Equals(hostdetail.Company_ID)).FirstOrDefault().FloorID, hosts = BLL.PreVisitors.getHosts(company_id).hosts, }; } catch (Exception ex) { return(null); } return(toreturn); }
//get dashboard elements public static ViewModels.DashboardElements getDashboard() { ViewModels.DashboardElements toReturn = new ViewModels.DashboardElements(); using (var db = new DLL.Model.Context()) { string date = DateTime.Now.Date.ToString(); DateTime date0 = DateTime.Parse(date); DateTime date1 = date0.AddDays(1).Date; DateTime date2 = date0.AddDays(2).Date; DateTime date3 = date0.AddDays(3).Date; DateTime date4 = date0.AddDays(4).Date; DateTime date5 = date0.AddDays(5).Date; DateTime date6 = date0.AddDays(6).Date; toReturn.visitorDay1 = db.previsitors.Where(m => m.Date.Equals(date0) && m.status == true).Count(); toReturn.visitorDay2 = db.previsitors.Where(m => m.Date.Equals(date1) && m.status == true).Count(); toReturn.visitorDay3 = db.previsitors.Where(m => m.Date.Equals(date2) && m.status == true).Count(); toReturn.visitorDay4 = db.previsitors.Where(m => m.Date.Equals(date3) && m.status == true).Count(); toReturn.visitorDay5 = db.previsitors.Where(m => m.Date.Equals(date4) && m.status == true).Count(); toReturn.visitorDay6 = db.previsitors.Where(m => m.Date.Equals(date5) && m.status == true).Count(); toReturn.visitorDay7 = db.previsitors.Where(m => m.Date.Equals(date6) && m.status == true).Count(); } return(toReturn); }