コード例 #1
0
        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));
            }
        }
コード例 #2
0
        public ActionResult Delete(int id)
        {
            DoublePunchMaster doublePunchMaster = db.DoublePunchMasters.Find(id);

            db.DoublePunchMasters.Remove(doublePunchMaster);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }