//
// GET: /Admin/Main/
public ActionResult Index()
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CateloryViewModel model = new CateloryViewModel();
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Catelory = db.Catelories.OrderBy(m => m.ID).ToList();
model.ProjectAll = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var project in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = project.Ten_Thiet_Bi,
Text = project.Ten_Thiet_Bi,
});
}
model.ProjectAll = items;
model.SelectedCatelory = null;
model.DisplayMode = null;
return(View(model));
}
}
public ActionResult Save(int id, CateloryViewModel collection)
{
try
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
Catelory exsiting = db.Catelories.Find(id);
exsiting.Prj_Name = collection.SelectedCatelory.Prj_Name;
exsiting.Unit_Name = collection.SelectedCatelory.Unit_Name;
exsiting.Owner_Name = collection.SelectedCatelory.Owner_Name;
exsiting.Phone_Number = collection.SelectedCatelory.Phone_Number;
exsiting.Person_Number = collection.SelectedCatelory.Person_Number;
//exsiting.Create_Date = DateTime.Now;
exsiting.Status = collection.SelectedCatelory.Status;
exsiting.Area = collection.SelectedCatelory.Area;
exsiting.Email = collection.SelectedCatelory.Email;
exsiting.Job = collection.SelectedCatelory.Job;
exsiting.Rate = collection.SelectedCatelory.Rate;
db.SaveChanges();
CateloryViewModel model = new CateloryViewModel();
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Catelory = db.Catelories.OrderBy(m => m.ID).ToList();
model.LLTC = db.LLTCs.OrderBy(m => m.ID).Take(1000).ToList();
model.ProjectAll = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var project in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = project.Ten_Thiet_Bi,
Text = project.Ten_Thiet_Bi,
});
}
model.ProjectAll = items;
model.SelectedCatelory = db.Catelories.Find(id);
model.DisplayMode = null;
return(RedirectToAction("Index", model));
}
}
catch
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
ProjectViewModel model1 = new ProjectViewModel();
model1.Thiet_Bi = db.Thiet_Bis.OrderBy(
m => m.ID).ToList();
model1.SelectedProject = null;
return(View("Index", model1));
}
}
}
public ActionResult Edit(int id, string number, CateloryViewModel collection)
{
try
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CateloryViewModel model = new CateloryViewModel();
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Catelory = db.Catelories.OrderBy(m => m.ID).ToList();
model.LLTC = db.LLTCs.OrderBy(m => m.ID).Take(1000).ToList();
if (number == "123")
{
model.Catelory_Project = null;
}
else
{
model.Catelory_Project = db.Catelories.Where(i => i.Phone_Number == number).ToList();
}
model.ProjectAll = new List <SelectListItem>();
var items = new List <SelectListItem>();
var items_2 = new List <SelectListItem>();
foreach (var project in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = project.Ten_Thiet_Bi,
Text = project.Ten_Thiet_Bi,
});
}
model.ProjectAll = items;
foreach (var Work_Force in model.LLTC)
{
items_2.Add(new SelectListItem()
{
Value = Work_Force.Main_Name_LLTC,
Text = Work_Force.Main_Name_LLTC,
});
}
model.MainNameAll = items_2;
model.SelectedCatelory = db.Catelories.Find(id);
model.DisplayMode = "Edit";
return(View("Index", model));
}
}
catch
{
return(View());
}
}
public ActionResult Delete(int id, CateloryViewModel collection)
{
try
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
Catelory exsiting = db.Catelories.Find(id);
db.Catelories.Remove(exsiting);
db.SaveChanges();
CateloryViewModel model = new CateloryViewModel();
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Catelory = db.Catelories.OrderBy(m => m.ID).ToList();
model.LLTC = db.LLTCs.OrderBy(m => m.ID).Take(1000).ToList();
model.ProjectAll = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var project in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = project.Ten_Thiet_Bi,
Text = project.Ten_Thiet_Bi,
});
}
model.ProjectAll = items;
model.SelectedCatelory = db.Catelories.Find(id);
model.DisplayMode = null;
return(RedirectToAction("Index", model));
}
}
catch
{
return(View());
}
}
public ActionResult Create(CateloryViewModel collection)
{
try
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
Catelory obj = new Catelory();
obj.Prj_Name = collection.SelectedCatelory.Prj_Name;
obj.Unit_Name = collection.SelectedCatelory.Unit_Name;
obj.Owner_Name = collection.SelectedCatelory.Owner_Name;
obj.Phone_Number = collection.SelectedCatelory.Phone_Number;
obj.Person_Number = collection.SelectedCatelory.Person_Number;
obj.Create_Date = DateTime.Now;
obj.Status = collection.SelectedCatelory.Status;
obj.Rate = collection.SelectedCatelory.Rate;
obj.Job = collection.SelectedCatelory.Job;
obj.Area = collection.SelectedCatelory.Area;
obj.Email = collection.SelectedCatelory.Email;
db.Catelories.Add(obj);
db.SaveChanges();
CateloryViewModel model = new CateloryViewModel();
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Catelory = db.Catelories.OrderBy(m => m.ID).ToList();
model.ProjectAll = new List <SelectListItem>();
var items = new List <SelectListItem>();
foreach (var project in model.Thiet_Bi)
{
items.Add(new SelectListItem()
{
Value = project.Ten_Thiet_Bi,
Text = project.Ten_Thiet_Bi,
});
}
model.ProjectAll = items;
model.SelectedCatelory = null;
model.DisplayMode = null;
return(RedirectToAction("Index", model));
}
}
catch
{
using (OnlineShopDbContext db = new OnlineShopDbContext())
{
CateloryViewModel model = new CateloryViewModel();
model.Thiet_Bi = db.Thiet_Bis.OrderBy(m => m.ID).ToList();
model.Catelory = db.Catelories.OrderBy(m => m.ID).ToList();
model.SelectedCatelory = null;
model.DisplayMode = null;
return(View("Index", model));
}
}
}
