// GET: welcomeGuestVisits/GuestCreate/5 public ActionResult GuestCreate(int?id) { var role = UserRole(); if (!role.WS_CreateVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WelcomeVisit welcomeVisit = db.WelcomeVisits.Find(id); if (welcomeVisit == null) { return(HttpNotFound()); } WelcomeGuestVisit guestVisit = new WelcomeGuestVisit { Visit = welcomeVisit }; guestVisit.Visit_ID = (int)id; FillAssignableGuests(guestVisit); return(View(guestVisit)); }
// GET: welcomeVisits/Details/5 public ActionResult Details(int?id) { var role = UserRole(); if (!role.WS_ViewVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WelcomeVisit welcomeVisit = db.WelcomeVisits.Find(id); if (welcomeVisit == null) { return(HttpNotFound()); } welcomeVisit.GuestVisits = welcomeVisit.GuestVisits .OrderBy(gv => gv.Guest.Deleted) .ThenByDescending(gv => gv.Guest.Rank.Importance) .ThenBy(gv => gv.Guest.Fullname) .ToList(); return(View(welcomeVisit)); }
// GET: welcomeVisits/Edit/5 public ActionResult Edit(int?id) { var role = UserRole(); if (!role.WS_CreateVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WelcomeVisit welcomeVisit = db.WelcomeVisits.Find(id); if (welcomeVisit == null) { return(HttpNotFound()); } FillAssignableCompanies(welcomeVisit); welcomeVisit.SetParts(); welcomeVisit.Sel_Comp_ID = welcomeVisit.Company.Comp_ID; return(View(welcomeVisit)); }
public ActionResult Create([Bind(Include = "Visit,Sel_Comp_ID,FromDate,FromTime,ToDate,ToTime")] WelcomeVisit welcomeVisit) { var role = UserRole(); if (!role.WS_CreateVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } welcomeVisit.Company = db.WelcomeCompanies.Find(welcomeVisit.Sel_Comp_ID); if (welcomeVisit.Company == null) { return(HttpNotFound()); } DateTime now; welcomeVisit.SetDT(); welcomeVisit.CreatingDT = now = DateTime.Now; ValidateVisitTime(welcomeVisit, now); if (ModelState.IsValid) { db.WelcomeVisits.Add(welcomeVisit); db.SaveChanges(); return(RedirectToAction("Index")); } FillAssignableCompanies(welcomeVisit); return(View(welcomeVisit)); }
public ActionResult DeleteConfirmed(int id) { var role = UserRole(); if (!role.WS_CreateVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } WelcomeVisit welcomeVisit = db.WelcomeVisits.Find(id); if (welcomeVisit == null) { return(HttpNotFound()); } DateTime dnow = DateTime.Now; double hours = (dnow - welcomeVisit.CreatingDT).TotalHours; if (hours > 24 || welcomeVisit.FromDT < dnow) //Ebben az esetben a histbe mentődnek az adatok. { WelcomeVisitHist vishist = new WelcomeVisitHist { Visit_ID = welcomeVisit.Visit_ID, Visit = welcomeVisit.Visit, FromDT = welcomeVisit.FromDT, ToDT = welcomeVisit.ToDT, Company = welcomeVisit.Company, CreatingDT = welcomeVisit.CreatingDT, Deleted = true }; db.WelcomeVisitHists.Add(vishist); WelcomeGuestVisitHist gvhist; foreach (WelcomeGuestVisit ogv in welcomeVisit.GuestVisits) { if (!ogv.Guest.Deleted) { gvhist = new WelcomeGuestVisitHist { Guest = ogv.Guest, VisitHist = vishist }; db.WelcomeGuestVisitHists.Add(gvhist); } } } db.WelcomeVisits.Remove(welcomeVisit); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// Betölti a partnercég lenyíló adattartalmát /// </summary> /// <param name="visit">az adatmodell, ahová a lenyíló adattartalmát be kell tölteni</param> private void FillAssignableCompanies(WelcomeVisit visit) { //Választható cégek foreach (var comp in db.WelcomeCompanies.Where(x => !x.Deleted).OrderBy(c => c.Company).ToList()) { visit.AssignableCompanies.Add(new SelectListItem() { Text = comp.Company, Value = comp.Comp_ID.ToString() }); } }
// GET: welcomeVisits/Create public ActionResult Create() { var role = UserRole(); if (!role.WS_CreateVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } WelcomeVisit visit = new WelcomeVisit(); FillAssignableCompanies(visit); visit.FromDate = DateTime.Today.AddDays(1); visit.FromTime = new TimeSpan(7, 29, 11); visit.ToDate = visit.FromDate; visit.ToTime = new TimeSpan(19, 31, 13); return(View(visit)); }
public ActionResult Edit([Bind(Include = "Visit_ID,Visit,Sel_Comp_ID,FromDate,FromTime,ToDate,ToTime")] WelcomeVisit welcomeVisit) { var role = UserRole(); if (!role.WS_CreateVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } var model = db.WelcomeVisits.Find(welcomeVisit.Visit_ID); if (model == null) { return(HttpNotFound()); } model.Company = db.WelcomeCompanies.Find(welcomeVisit.Sel_Comp_ID); if (model.Company == null) { return(HttpNotFound()); } model.Visit = welcomeVisit.Visit; model.FromDate = welcomeVisit.FromDate; model.FromTime = welcomeVisit.FromTime; model.ToDate = welcomeVisit.ToDate; model.ToTime = welcomeVisit.ToTime; model.SetDT(); ModelState.Clear(); ValidateVisitTime(model, DateTime.Now); TryValidateModel(model); if (ModelState.IsValid) { db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } FillAssignableCompanies(model); return(View(model)); }
// GET: welcomeVisits/Delete/5 public ActionResult Delete(int?id) { var role = UserRole(); if (!role.WS_CreateVisit) { return(RedirectToAction("Unauthorized", "Error", new { role.Role, role.UserName })); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WelcomeVisit welcomeVisit = db.WelcomeVisits.Find(id); if (welcomeVisit == null) { return(HttpNotFound()); } return(View(welcomeVisit)); }
/// <summary> /// Validálja az adatmodelt időadatai alapján, ahol a kezdetnek korábban kell lenni, mint a végnek. /// </summary> /// <param name="welcomeVisit"></param> az adatmodel mely időadatait validálni kell private void ValidateVisitTime(WelcomeVisit welcomeVisit, DateTime now) { if (welcomeVisit.ToDT < now) { if (welcomeVisit.ToDate < now.Date) { ModelState.AddModelError("ToDate", "Múltbeli látogatás nem rögzíthető!"); } else { ModelState.AddModelError("ToTime", "Elmúlt időpontra nem rögzíthető látogatás!"); } } else if (welcomeVisit.FromDate > welcomeVisit.ToDate) { ModelState.AddModelError("ToDate", "A vég dátum nem lehet korábban a kezdetnél!"); } else if (welcomeVisit.FromDate == welcomeVisit.ToDate && welcomeVisit.FromTime >= welcomeVisit.ToTime) { ModelState.AddModelError("ToTime", "A vég időpontnak később kell lennie a kezdetnél!"); } }
protected override void Seed(WelcomeScreen.Models.IntranetContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. #region Welcome táblák feltöltése var rank1 = new WelcomeRank() { Rank = "Beszállító képviseloje", Importance = 1 }; var rank3 = new WelcomeRank() { Rank = "Beszállító vezetoje", Importance = 3 }; var rank1011 = new WelcomeRank() { Rank = "AQ Group felsõ vezetõ", Importance = 1011 }; var rank1013 = new WelcomeRank() { Rank = "AQ Group CEO", Importance = 1013 }; var rank2001 = new WelcomeRank() { Rank = "Vevo képviseloje", Importance = 2001 }; var rank2003 = new WelcomeRank() { Rank = "Vevo vezetoje", Importance = 2003 }; var rank2101 = new WelcomeRank() { Rank = "Stratégiai vevo képviseloje", Importance = 2101 }; var rank2103 = new WelcomeRank() { Rank = "Stratégiai vevo vezetoje", Importance = 2103 }; var rank2105 = new WelcomeRank() { Rank = "Stratégiai vevõ felsõ vezetõje", Importance = 2105 }; var rank2107 = new WelcomeRank() { Rank = "Stratégiai vevõ CEO", Importance = 2107 }; context.WelcomeRanks.AddOrUpdate(x => x.Rank , rank1, rank3, rank1011, rank1013, rank2001, rank2003, rank2101, rank2103, rank2105, rank2107); var compAQ = new WelcomeCompany() { Company = "AQ Group", ShowComp = true }; context.WelcomeCompanies.AddOrUpdate(x => x.Company, compAQ); var guestAqCEO = new WelcomeGuest() { Fullname = "Anders Carlsson", Company = compAQ, Rank = rank1013 }; var guestAqCEF = new WelcomeGuest() { Fullname = "Mia Tomczak", Company = compAQ, Rank = rank1011 }; var guestAqBD = new WelcomeGuest() { Fullname = "Per Lindblad", Company = compAQ, Rank = rank1011 }; var guestAqMS = new WelcomeGuest() { Fullname = "James Ahrgren", Company = compAQ, Rank = rank1011 }; context.WelcomeGuests.AddOrUpdate(x => x.Fullname , guestAqCEO, guestAqCEF, guestAqBD, guestAqMS); var compBosch = new WelcomeCompany() { Company = "Bosch", ShowComp = true }; context.WelcomeCompanies.AddOrUpdate(x => x.Company, compBosch); var guestBoschDVD = new WelcomeGuest() { Fullname = "Dr.Volkmar Denner", Company = compBosch, Rank = rank2107 }; var guestBoschCK = new WelcomeGuest() { Fullname = "Christoph Kübel", Company = compBosch, Rank = rank2105 }; context.WelcomeGuests.AddOrUpdate(x => x.Fullname , guestBoschDVD , new WelcomeGuest() { Fullname = "Dr.Michael Bolle", Company = compBosch, Rank = rank2105 } , guestBoschCK , new WelcomeGuest() { Fullname = "Uwe RaschkeL", Company = compBosch, Rank = rank2105 } ); var comp = new WelcomeCompany() { Company = "Würth Szereléstechnika Kft.", ShowComp = true }; context.WelcomeCompanies.AddOrUpdate(x => x.Company, comp); context.WelcomeGuests.AddOrUpdate(x => x.Fullname , new WelcomeGuest() { Fullname = "Kránitz Elemér", Company = comp, Rank = rank1 } ); context.WelcomeCompanies.AddOrUpdate(x => x.Company , new WelcomeCompany() { Company = "Egyéni vállalkozók", ShowComp = false }); var event1 = new WelcomeVisit { Visit = "Éves AQ látogatás" , FromDT = new DateTime(2019, 5, 20, 7, 40, 0) , ToDT = new DateTime(2019, 5, 23, 20, 30, 0) , Company = compAQ , CreatingDT = new DateTime(2019, 4, 15, 13, 30, 0) }; var event2 = new WelcomeVisit { Visit = "Bosch vevõi látogatás" , FromDT = new DateTime(2019, 6, 18, 7, 40, 0) , ToDT = new DateTime(2019, 6, 20, 18, 10, 0) , Company = compBosch , CreatingDT = new DateTime(2019, 4, 16, 11, 28, 11) }; context.WelcomeVisits.AddOrUpdate(x => x.Visit, event1, event2); if (context.WelcomeGuestVisits.Count() == 0) { context.WelcomeGuestVisits.Add(new WelcomeGuestVisit() { Visit = event1, Guest = guestAqCEO }); context.WelcomeGuestVisits.Add(new WelcomeGuestVisit() { Visit = event1, Guest = guestAqCEF }); context.WelcomeGuestVisits.Add(new WelcomeGuestVisit() { Visit = event1, Guest = guestAqBD }); context.WelcomeGuestVisits.Add(new WelcomeGuestVisit() { Visit = event2, Guest = guestAqCEO }); context.WelcomeGuestVisits.Add(new WelcomeGuestVisit() { Visit = event2, Guest = guestAqMS }); context.WelcomeGuestVisits.Add(new WelcomeGuestVisit() { Visit = event2, Guest = guestBoschDVD }); context.WelcomeGuestVisits.Add(new WelcomeGuestVisit() { Visit = event2, Guest = guestBoschCK }); } #endregion #region On-line reports tábla feltöltése context.OLReports.AddOrUpdate(x => x.Name , new OnLineReport { Name = "Nyilvános riportok", Order = 1, Link = "http://riportok.lan.local/report_list.html?path=Anton-Public&header=Nyilv%C3%A1nos%20riportok", IsInformatic = false } , new OnLineReport { Name = "Értékesítés", Order = 2, Link = "http://riportok.lan.local/report_list.html?path=Sales-Public&header=%C3%89rt%C3%A9kes%C3%ADt%C3%A9si%20riportok", IsInformatic = false } , new OnLineReport { Name = "Logisztika", Order = 3, Link = "http://riportok.lan.local/report_list.html?path=Logistics-Public&header=Logisztikai%20riportok", IsInformatic = false } , new OnLineReport { Name = "Pénzügy", Order = 4, Link = "http://riportok.lan.local/report_list.html?path=Financial-Public&header=P%C3%A9nz%C3%BCgyes%20riportok", IsInformatic = false } , new OnLineReport { Name = "Karbantartás", Order = 5, Link = "http://riportok.lan.local/report_list.html?path=Maintenance-Public&header=Karbantart%C3%A1s%20riportok", IsInformatic = false } , new OnLineReport { Name = "Emberi erõforrás", Order = 6, Link = "http://riportok.lan.local/report_list.html?path=HR-Public&header=Emberi%20er%C5%91forr%C3%A1s%20riportok", IsInformatic = false } , new OnLineReport { Name = "Informatika", Order = 7, Link = "http://riportok.lan.local/report_list.html?path=IT-Public&header=Informatikai%20riportok", IsInformatic = false } , new OnLineReport { Name = "Történetiségi riportok", Order = 8, Link = "http://riportok.lan.local/report_list.html?path=Histories-Public&header=T%C3%B6rt%C3%A9netis%C3%A9gi%20riportok", IsInformatic = false } , new OnLineReport { Name = "Szerszámüzem", Order = 21, Link = "http://riportok.lan.local/report_list.html?path=T1-Public&header=Szersz%C3%A1m%C3%BCzemi%20riportok", IsInformatic = false } , new OnLineReport { Name = "Mûanyagüzem", Order = 22, Link = "http://riportok.lan.local/report_list.html?path=T2-Public&header=M%C5%B1anyag%C3%Bczem", IsInformatic = false } , new OnLineReport { Name = "SMD", Order = 23, Link = "http://riportok.lan.local/report_list.html?path=T3-Public&header=SMD", IsInformatic = false } , new OnLineReport { Name = "CIM stopped", Order = 41, Link = "http://rs/Reports/Pages/ReportViewer.aspx?%2fIT-Public%2fCIM%20stopped&rs:Command=Render", IsInformatic = true } , new OnLineReport { Name = "QAD adatbázis lockok", Order = 42, Link = "http://rs/Reports/Pages/ReportViewer.aspx?%2fIT-Public%2fQAD%20adatb%C3%A1zis%20lockok&rs:Command=Render", IsInformatic = true } ); #endregion #region Jogosultságok feltöltése context.IntraRoles.AddOrUpdate(x => x.Role , new IntraRole { Role = "Informatikai vezetõk" , Admin = true , HomePage = true , UsefullLimks = true , WS_ViewVisit = true , WS_CreateVisit = true , WS_DelCompany = true , WS_Settings = true , T2rT_RecordChecklist = true , T2rT_EditChecklist = false } ); #endregion }