public ActionResult Index(Step1Model step1) { if (ModelState.IsValid) { if (data == null) { data = new DataRepository(db); } Response.Cookies["Step1Cookies"]["HoTen"] = Server.UrlEncode(step1.HoTen); Response.Cookies["Step1Cookies"]["SoThe"] = Server.UrlEncode(step1.SoThe); Response.Cookies["Step1Cookies"]["Khoa"] = Server.UrlEncode(step1.Khoa); Response.Cookies["Step1Cookies"]["DienThoai"] = step1.DienThoai; Response.Cookies["Step1Cookies"]["CourseID"] = step1.CourseID; Response.Cookies["Step1Cookies"]["TenMon"] = Server.UrlEncode(step1.TenMon); Response.Cookies["Step1Cookies"]["Nganh"] = Server.UrlEncode(step1.Nganh); Response.Cookies["Step1Cookies"]["Nhom"] = Server.UrlEncode(step1.Nhom); Response.Cookies["Step1Cookies"]["HK"] = step1.HK; Response.Cookies["Step1Cookies"]["DuTruFrom"] = step1.DuTruFrom.ToString(); Response.Cookies["Step1Cookies"]["DuTruTo"] = step1.DuTruTo.ToString(); Response.Cookies["Step1Cookies"]["SoLuongSV"] = step1.SoLuongSV; //Response.Cookies["Step1Cookies"].Expires = DateTime.Now.AddDays(1); return(RedirectToAction("Step2")); } else { ViewBag.HK = db.HK.Select(m => new SelectListItem { Text = m.Hocky, Value = m.ID.ToString() }); TempData["data"] = null; return(View(step1)); } }
public ActionResult WizardStep1(Step1Model step1Model) { if (!ModelState.IsValid) { return(View(step1Model)); } //all good //set model for step1 and redirect to step2 var wizardModel = (WizardModel)Cache.Get(step1Model.WizardId); wizardModel.Step1 = step1Model; var oldCategoryId = wizardModel.Step2.CategoryId; //set category for next step wizardModel.Step2.CategoryId = step1Model.CategoryId.Value; //clear selected meals when we go gack from Step2 to Step1 and change the category if (oldCategoryId != 0 && wizardModel.Step2.CategoryId != oldCategoryId) { wizardModel.Step2.MealIds = null; } //go to next step return(RedirectToAction("WizardStep2", new { WizardId = wizardModel.Id })); }
public ActionResult Step1(RenderModel model, BookPO param) { var rto = new Step1Model(CurrentPage); rto.Branch = DatabaseContext.Database.Fetch <tb_branch>("select * from tb_branch;"); DateTime pudate = _functional.ConvertDate(param.pickupdate); DateTime dfdate = _functional.ConvertDate(param.dropoffdate); DateTime putime = _functional.ConvertTime(param.pickuptime); DateTime dftime = _functional.ConvertTime(param.dropofftime); pudate = _functional.MergeDatetime(pudate, putime); dfdate = _functional.MergeDatetime(dfdate, dftime); int ndate = (dfdate - pudate).Days; int nhour = (dfdate - pudate).Hours; int nmin = (dfdate - pudate).Minutes; if (nhour >= 4 && nmin > 1) { ndate += 1; } if (ndate <= 0) { dfdate = dfdate.AddDays(1); param.dropoffdate = dfdate.ToString("yyyy-MM-dd"); } var sql = string.Format(@"Select A_ID,[Branch_ID],[Car_ID],t2.*,t1.Quantity From tb_branch_car t1 Inner join tb_car t2 on t1.Car_ID = t2.id Where Branch_ID = {0} and t1.Status ='A';", param.pickuploc); rto.ListCar = DatabaseContext.Database.Fetch <dto_carprice>(sql); rto.ListCar.ForEach(x => { x.price = _carService.GetCarPrice(x.A_ID, pudate, dfdate, ndate); }); rto.ListCar.ForEach(x => { x.Aviable = x.Quantity - (_carService.GetAviable(x.A_ID, pudate)); }); rto.ListCar = rto.ListCar.Where(x => x.Aviable > 0).ToList(); return(CurrentTemplate(rto)); }
public Step1Model FirstData(Step1Model step1) { FirstModel.HoTen = step1.HoTen; FirstModel.SoThe = step1.SoThe; FirstModel.Khoa = step1.Khoa; FirstModel.DienThoai = step1.DienThoai; FirstModel.CourseID = step1.CourseID; FirstModel.TenMon = step1.TenMon; FirstModel.Nganh = step1.Nganh; FirstModel.Nhom = step1.Nhom; FirstModel.HK = step1.HK; FirstModel.DuTruFrom = step1.DuTruFrom; FirstModel.DuTruTo = step1.DuTruTo; FirstModel.SoLuongSV = step1.SoLuongSV; return(FirstModel); }
public void Step1_Submit_Returns_View() { AnalysisController analysis = GetAnalysisController(); var st1 = new State { FullName = "New Mexico", Id = 1, StateAbbrev = "NM", StateId = 1 }; var list = new System.Collections.Generic.List <State>() { st1 }; Step1Model model = new Step1Model { HasSchoolID = false, HasDistrictID = false, HasStateID = true, RadioStates = list.ConvertAll( i => new CheckboxItem { Label = "New Mexico", Value = "NM", Checked = false }), State = "New Mexico" }; // Act var action = (RedirectToRouteResult)analysis.Step1("Submit", model, analysis.ControllerContext.HttpContext.User, 1); // Assert Assert.IsInstanceOf(typeof(ActionResult), action); //Assert.AreEqual(action.RouteValues["action"], "Step1b"); //Assert.AreEqual(action.RouteValues["controller"], "Analysis"); var result = (RedirectToRouteResult)analysis.Step1("Back", model, analysis.ControllerContext.HttpContext.User, 1); // Assert //Assert.AreEqual(result.RouteValues["action"], "Index"); //Assert.AreEqual(result.RouteValues["controller"], "Home"); }
public ActionResult Step2(Step2Model step2, int sId, int tId, string done) { Step1Model step1 = new Step1Model(); if (ModelState.IsValid) { var from = DateTime.ParseExact(Server.HtmlEncode(Request.Cookies["Step1Cookies"]["DuTruFrom"]), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); var to = DateTime.ParseExact(Server.HtmlEncode(Request.Cookies["Step1Cookies"]["DuTruTo"]), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); step1.HoTen = Server.UrlDecode(Request.Cookies["Step1Cookies"]["HoTen"]); step1.SoThe = Server.UrlDecode(Request.Cookies["Step1Cookies"]["SoThe"]); step1.Khoa = Server.UrlDecode(Request.Cookies["Step1Cookies"]["Khoa"]); step1.DienThoai = Server.HtmlEncode(Request.Cookies["Step1Cookies"]["DienThoai"]); step1.CourseID = Server.HtmlEncode(Request.Cookies["Step1Cookies"]["CourseID"]); step1.TenMon = Server.UrlDecode(Request.Cookies["Step1Cookies"]["TenMon"]); step1.Nganh = Server.UrlDecode(Request.Cookies["Step1Cookies"]["Nganh"]); step1.Nhom = Server.UrlDecode(Request.Cookies["Step1Cookies"]["Nhom"]); step1.HK = Server.HtmlEncode(Request.Cookies["Step1Cookies"]["HK"]); step1.DuTruFrom = from; step1.DuTruTo = to; step1.SoLuongSV = Server.HtmlEncode(Request.Cookies["Step1Cookies"]["SoLuongSV"]); //////////////////////////////////////////////////////// string ReserveType; int hk = Int32.Parse(step1.HK); var tenHK = db.HK.FirstOrDefault(x => x.STT == hk); var MonHoc = new MonHoc() { CourseID = step1.CourseID, TenMon = step1.TenMon, Nganh = step1.Nganh, DuTruFrom = step1.DuTruFrom, DuTruTo = step1.DuTruTo, Nhom = step1.Nhom, SoLuongSV = step1.SoLuongSV, HK = tenHK.Hocky }; db.MonHoc.Add(MonHoc); db.SaveChanges(); switch (step2.MucDich) { case "0": { ReserveType = "Giáo Trình"; break; } case "1": { ReserveType = "Tham Khảo Chính"; break; } default: { ReserveType = "Tham Khảo Khác"; break; } } if (tId == 0) { switch (sId) { case 0: { var document = new TL_Sach() { Loai = "Sách", Nguon = "Thư Viện", TraCuu = step2.TL_Sach.TraCuu, ChiTiet = step2.TL_Sach.ChiTiet, MucDich = ReserveType, YKien = step2.TL_Sach.YKien, LanXuatBan = "Không", NhanDe = "Không", TacGia = "Không", NXB = "Không", }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_Sach.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, BookId = document.ID }; db.GiangVien.Add(gv); break; } case 1: { var document = new TL_Sach() { Loai = "Sách", Nguon = "Giảng Viên", TraCuu = "Không", NhanDe = step2.TL_Sach.NhanDe, TacGia = step2.TL_Sach.TacGia, NXB = step2.TL_Sach.NXB, LanXuatBan = step2.TL_Sach.LanXuatBan, MucDich = ReserveType, ChiTiet = step2.TL_Sach.ChiTiet, YKien = step2.TL_Sach.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_Sach.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, BookId = document.ID }; db.GiangVien.Add(gv); break; } default: { var document = new TL_Sach() { Loai = "Sách", Nguon = "Khác", NhanDe = step2.TL_Sach.NhanDe, TraCuu = "Không", TacGia = step2.TL_Sach.TacGia, NXB = step2.TL_Sach.NXB, LanXuatBan = step2.TL_Sach.LanXuatBan, ChiTiet = step2.TL_Sach.ChiTiet, MucDich = ReserveType, YKien = step2.TL_Sach.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_Sach.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, BookId = document.ID }; db.GiangVien.Add(gv); break; } } } else if (tId == 1) { switch (sId) { case 0: { var document = new TL_BaiBao() { Loai = "Bài Báo", Nguon = "Thư Viện", TraCuu = step2.TL_BaiBao.TraCuu, ChiTiet = step2.TL_BaiBao.ChiTiet, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien, TacGia = "Không", TenBai = "Không", TenTapChi = "Không", PhatHanh = "Không", }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_BaiBao.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, PaperId = document.ID }; db.GiangVien.Add(gv); break; } case 1: { var document = new TL_BaiBao() { Loai = "Bài Báo", Nguon = "Giảng Viên", TraCuu = "Không", TacGia = step2.TL_BaiBao.TacGia, TenBai = step2.TL_BaiBao.TenBai, TenTapChi = step2.TL_BaiBao.TenTapChi, PhatHanh = step2.TL_BaiBao.PhatHanh, ChiTiet = step2.TL_BaiBao.ChiTiet, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_BaiBao.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, PaperId = document.ID }; db.GiangVien.Add(gv); break; } default: { var document = new TL_BaiBao() { Loai = "Bài Báo", Nguon = "Khác", TacGia = step2.TL_BaiBao.TacGia, TenBai = step2.TL_BaiBao.TenBai, TenTapChi = step2.TL_BaiBao.TenTapChi, PhatHanh = step2.TL_BaiBao.PhatHanh, ChiTiet = step2.TL_BaiBao.ChiTiet, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien, TraCuu = "Không" }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_BaiBao.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, PaperId = document.ID }; db.GiangVien.Add(gv); break; } } } else { switch (sId) { case 0: { var document = new TL_Khac() { Loai = "Khác", Nguon = "Thư Viện", TraCuu = step2.TL_Khac.TraCuu, MucDich = ReserveType, YKien = step2.TL_Khac.YKien, NhanDe = "Không", TacGia = "Không" }; db.TL_Khac.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, OtherId = document.ID }; db.GiangVien.Add(gv); break; } case 1: { var document = new TL_Khac() { Loai = "Khác", Nguon = "Giảng Viên", TraCuu = "Không", NhanDe = step2.TL_Khac.NhanDe, TacGia = step2.TL_Khac.TacGia, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; db.TL_Khac.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, OtherId = document.ID }; db.GiangVien.Add(gv); break; } default: { var document = new TL_Khac() { Loai = "Khác", Nguon = "Giảng Viên", TraCuu = "Không", NhanDe = step2.TL_Khac.NhanDe, TacGia = step2.TL_Khac.TacGia, MucDich = ReserveType, YKien = step2.TL_Khac.YKien }; db.TL_Khac.Add(document); db.SaveChanges(); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, OtherId = document.ID }; db.GiangVien.Add(gv); break; } } } db.SaveChanges(); ////////////////////////////////// if (done == "0") { Response.Cookies["Step1Cookies"].Expires = DateTime.Now.AddDays(-1); return(RedirectToAction("Index")); } if (done == "1") { return(RedirectToAction("Step2")); } } ViewBag.sId = sId; ViewBag.tId = tId; var errors = ViewData.ModelState.Where(n => n.Value.Errors.Count > 0).ToList(); ViewBag.Error = errors; return(View(step2)); }
public void InsertData(int tId, int sId, Step1Model step1, Step2Model step2) { string ReserveType; var tenHK = db.HK.FirstOrDefault(x => x.STT == Int32.Parse(step1.HK)); var MonHoc = new MonHoc() { CourseID = step1.CourseID, TenMon = step1.TenMon, Nganh = step1.Nganh, DuTruFrom = step1.DuTruFrom, DuTruTo = step1.DuTruTo, Nhom = step1.Nhom, SoLuongSV = step1.SoLuongSV, HK = tenHK.Hocky }; db.MonHoc.Add(MonHoc); switch (step2.MucDich) { case "0": { ReserveType = "Giáo Trình"; break; } case "1": { ReserveType = "Tham Khảo Chính"; break; } default: { ReserveType = "Tham Khảo Khác"; break; } } if (tId == 0) { switch (sId) { case 0: { var document = new TL_Sach() { Loai = "Sách", Nguon = "Thư Viện", TraCuu = step2.TL_Sach.TraCuu, ChiTiet = step2.TL_Sach.ChiTiet, MucDich = ReserveType, YKien = step2.TL_Sach.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_Sach.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, BookId = document.ID }; db.GiangVien.Add(gv); break; } case 1: { var document = new TL_Sach() { Loai = "Sách", Nguon = "Giảng Viên", NhanDe = step2.TL_Sach.NhanDe, TacGia = step2.TL_Sach.TacGia, NXB = step2.TL_Sach.NXB, LanXuatBan = step2.TL_Sach.LanXuatBan, MucDich = ReserveType, ChiTiet = step2.TL_Sach.ChiTiet, YKien = step2.TL_Sach.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_Sach.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, BookId = document.ID }; db.GiangVien.Add(gv); break; } default: { var document = new TL_Sach() { Loai = "Sách", Nguon = "Khác", NhanDe = step2.TL_Sach.NhanDe, TacGia = step2.TL_Sach.TacGia, NXB = step2.TL_Sach.NXB, LanXuatBan = step2.TL_Sach.LanXuatBan, ChiTiet = step2.TL_Sach.ChiTiet, MucDich = ReserveType, YKien = step2.TL_Sach.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_Sach.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, BookId = document.ID }; db.GiangVien.Add(gv); break; } } } else if (tId == 1) { switch (sId) { case 0: { var document = new TL_BaiBao() { Loai = "Bài Báo", Nguon = "Thư Viện", TraCuu = step2.TL_BaiBao.TraCuu, ChiTiet = step2.TL_BaiBao.ChiTiet, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_BaiBao.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, PaperId = document.ID }; db.GiangVien.Add(gv); break; } case 1: { var document = new TL_BaiBao() { Loai = "Bài Báo", Nguon = "Giảng Viên", TacGia = step2.TL_BaiBao.TacGia, TenBai = step2.TL_BaiBao.TenBai, TenTapChi = step2.TL_BaiBao.TenTapChi, PhatHanh = step2.TL_BaiBao.PhatHanh, ChiTiet = step2.TL_BaiBao.ChiTiet, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_BaiBao.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, PaperId = document.ID }; db.GiangVien.Add(gv); break; } default: { var document = new TL_BaiBao() { Loai = "Bài Báo", Nguon = "Khác", TacGia = step2.TL_BaiBao.TacGia, TenBai = step2.TL_BaiBao.TenBai, TenTapChi = step2.TL_BaiBao.TenTapChi, PhatHanh = step2.TL_BaiBao.PhatHanh, ChiTiet = step2.TL_BaiBao.ChiTiet, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; if (step2.DangDuTru == "0") { document.DangDuTru = "Dự trữ dạng giấy"; document.SoLuong = step2.SoLuong; } else { document.DangDuTru = "Dự trữ dạng điện tử"; document.SoLuong = null; } db.TL_BaiBao.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, PaperId = document.ID }; db.GiangVien.Add(gv); break; } } } else { switch (sId) { case 0: { var document = new TL_Khac() { Loai = "Khác", Nguon = "Thư Viện", TraCuu = step2.TL_BaiBao.TraCuu, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; db.TL_Khac.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, OtherId = document.ID }; db.GiangVien.Add(gv); break; } case 1: { var document = new TL_Khac() { Loai = "Khác", Nguon = "Giảng Viên", NhanDe = step2.TL_Khac.NhanDe, TacGia = step2.TL_Khac.TacGia, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; db.TL_Khac.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, OtherId = document.ID }; db.GiangVien.Add(gv); break; } default: { var document = new TL_Khac() { Loai = "Khác", Nguon = "Giảng Viên", NhanDe = step2.TL_Khac.NhanDe, TacGia = step2.TL_Khac.TacGia, MucDich = ReserveType, YKien = step2.TL_BaiBao.YKien }; db.TL_Khac.Add(document); var gv = new GiangVien() { HoTen = step1.HoTen, DienThoai = step1.DienThoai, Khoa = step1.Khoa, SoThe = step1.SoThe, MonHocId = MonHoc.ID, OtherId = document.ID }; db.GiangVien.Add(gv); break; } } } db.SaveChanges(); }