Ejemplo n.º 1
0
        public ActionResult DeleteConfirmed(int id)
        {
            TbTime tbTime = db.tbTimes.Find(id);

            db.tbTimes.Remove(tbTime);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Ejemplo n.º 2
0
 public ActionResult Edit([Bind(Include = "Id,Time")] TbTime tbTime)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tbTime).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(tbTime));
 }
Ejemplo n.º 3
0
        public ActionResult Create([Bind(Include = "Id,Time")] TbTime tbTime)
        {
            if (ModelState.IsValid)
            {
                db.tbTimes.Add(tbTime);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(tbTime));
        }
 //Clears all text boxes after a spell is added
 public void ClearTB()
 {
     TbSearch.Clear();
     TbName.Clear();
     TbLevel.Clear();
     TbSchool.Clear();
     TbTime.Clear();
     TbRange.Clear();
     TbComponents.Clear();
     TbDuration.Clear();
     TbAvailableClass.Clear();
     TbDescription.Clear();
 }
Ejemplo n.º 5
0
        // GET: Times/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TbTime tbTime = db.tbTimes.Find(id);

            if (tbTime == null)
            {
                return(HttpNotFound());
            }
            return(View(tbTime));
        }
Ejemplo n.º 6
0
        public bool InitiateData()
        {
            using (var db = new EntityContext())
            {
                using (var dbtransaction = db.Database.BeginTransaction())
                {
                    try
                    {
                        db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('TbRole', RESEED)");
                        db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('TbItemStatus', RESEED)");
                        db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('TbStatus', RESEED)");
                        db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('TbUser', RESEED)");
                        db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('TbRoute', RESEED)");
                        db.Database.ExecuteSqlCommand("DBCC CHECKIDENT('TbTime', RESEED)");
                        List <TbStatus> status = new List <TbStatus>
                        {
                            new TbStatus {
                                Id = 1, Status = "ພ້ອມນຳໃຊ້"
                            },
                            new TbStatus {
                                Id = 2, Status = "ບລ໋ອກ"
                            }
                        };
                        db.tbStatuses.AddRange(status);
                        db.SaveChanges();
                        List <TbRole> role = new List <TbRole>
                        {
                            new TbRole {
                                Id = 1, Role = "ແອດມີນ"
                            },
                            new TbRole {
                                Id = 2, Role = "Call Center"
                            },
                            new TbRole {
                                Id = 3, Role = "ພະນັກງານຮັບສົ່ງ"
                            },
                            new TbRole {
                                Id = 4, Role = "ຄົນຈັດຄົນ"
                            },
                            new TbRole {
                                Id = 5, Role = "ນາຍສາງ"
                            },
                            new TbRole {
                                Id = 6, Role = "ພະນັກງານບັນຊີ"
                            }
                        };
                        db.tbRoles.AddRange(role);
                        db.SaveChanges();
                        List <TbItemStatus> itemstatus = new List <TbItemStatus>
                        {
                            new TbItemStatus {
                                Id = 1, Status = "ຢູ່ຮ້ານ"
                            },
                            new TbItemStatus {
                                Id = 2, Status = "ຢືນຢັນ"
                            },
                            new TbItemStatus {
                                Id = 3, Status = "ພະນັກງານຮັບເຄື່ອງແລ້ວ"
                            },
                            new TbItemStatus {
                                Id = 4, Status = "ກຳລັງດຳເນີນການ"
                            },
                            new TbItemStatus {
                                Id = 5, Status = "ເຄື່ອງກຳລັງສົ່ງ"
                            },
                            new TbItemStatus {
                                Id = 6, Status = "ສີນຄ້າຖືກສົ່ງໃຫ້ປາຍທາງແລ້ວ"
                            },
                            new TbItemStatus {
                                Id = 7, Status = "ບໍ່ສາມາດຕິຕໍ່ກັບປາຍທາງໄດ້"
                            },
                            new TbItemStatus {
                                Id = 8, Status = "ສົ່ງກັບຄືນແລ້ວ"
                            },
                            new TbItemStatus {
                                Id = 9, Status = "ເຄື່ອງກຳລັງສົ່ງກັບຄືນ"
                            },
                            new TbItemStatus {
                                Id = 10, Status = "ລຸກຄ້າບໍ່ຮັບເຄື່ອງ"
                            }
                        };
                        db.tbItemStatuses.AddRange(itemstatus);
                        db.SaveChanges();
                        List <TbUser> user = new List <TbUser>
                        {
                            new TbUser {
                                Id            = 1
                                , Username    = "******"
                                , Password    = "******"
                                , Phonenumber = ""
                                , Role        = db.tbRoles.FirstOrDefault(r => r.Id == 1)
                                , Status      = db.tbStatuses.FirstOrDefault(s => s.Id == 1)
                            }
                        };

                        db.tbUsers.AddRange(user);
                        db.SaveChanges();
                        TbRoute route = new TbRoute
                        {
                            Id    = 1,
                            Route = "A1"
                        };
                        db.tbRoutes.Add(route);
                        db.SaveChanges();
                        TbTime time = new TbTime
                        {
                            Id   = 1,
                            Time = "8-10 ໂມງ"
                        };
                        db.tbTimes.Add(time);
                        db.SaveChanges();
                        dbtransaction.Commit();
                        return(true);
                    }
                    catch
                    {
                        dbtransaction.Rollback();
                        return(false);
                    }
                }
            }
        }