public ActionResult Index(string branch) { ViewBag.BranchList = ToSelectList((from A in db.SiteMasters select new DropDownModel { Id = A.BUCode, Value = A.BUCode + " - " + A.BUDescription }).ToList()); List <DoubleSite> list = (from A in db.DoublePunchMasters join B in db.SiteMasters on A.BUCode equals B.BUCode select new DoubleSite { Id = A.Id, BUCode = A.BUCode, BUDescription = B.BUDescription }).ToList(); DoublePunchMaster site = db.DoublePunchMasters.Where(x => x.BUCode == branch).FirstOrDefault(); if (site == null) { DoublePunchMaster site1 = new DoublePunchMaster(); site1.BUCode = branch; site1.DoublePunchMechanism = "Double"; db.DoublePunchMasters.Add(site1); db.SaveChanges(); ViewBag.Error = ""; return(RedirectToAction("Index")); } else { ViewBag.Error = "You Have Already Added this Site"; return(View(list)); } }
public ActionResult Delete(int id) { DoublePunchMaster doublePunchMaster = db.DoublePunchMasters.Find(id); db.DoublePunchMasters.Remove(doublePunchMaster); db.SaveChanges(); return(RedirectToAction("Index")); }