//CHỨC NĂNG BUTTOM private void btDaGiaoHang_Click(object sender, EventArgs e) { if (ChonShipper.SelectedItem == null) { XtraMessageBox.Show("Vui lòng chọn Shipper!", "Lỗi!"); } else { try { DONHANG dh = (from a in db.DONHANGs where a.MADH == madh select a).Single(); SHIPPER sp = (from a in db.SHIPPERs where a.MAPT == dh.PHIGH.MAPT && a.TEN == ChonShipper.Text select a).Single(); XtraMessageBox.Show("Chuyển đơn hàng cho " + sp.TEN + " thành công!", "Thông báo"); dh.TTHD = "Đang giao hàng"; dh.PHIGH.MASHIPPER = sp.MASHIPPER; db.SubmitChanges(); fmXemChiTietDonHang_Load(sender, e); } catch (Exception) { throw; } } }
public JsonResult InsertShipper(int id) { var kq = false; var check = (long)-1; var user = (UserLogin)Session[CommonStants.USER_SESSION]; if (user != null) { check = new OrderDAO().checkOrder(user.userName); if (check == -1) { var model = new SHIPPER(); model.USERNAME = user.userName; model.ORDERID = id; kq = new OrderDAO().InsertShipper(model); new OrderDAO().UpdateOrder(id, 5); } } return(Json(new { status = kq, id = check }, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "SHIPPERID,COMPANYNAME,PHONE")] SHIPPER sHIPPER) { if (ModelState.IsValid) { this.db.Entry(sHIPPER).State = EntityState.Modified; this.db.SaveChanges(); return(this.RedirectToAction("Index")); } return(this.View(sHIPPER)); }
public ActionResult Create([Bind(Include = "SHIPPERID,COMPANYNAME,PHONE")] SHIPPER sHIPPER) { if (ModelState.IsValid) { this.db.SHIPPERS.Add(sHIPPER); this.db.SaveChanges(); return(this.RedirectToAction("Index")); } return(this.View(sHIPPER)); }
public bool InsertShipper(SHIPPER s) { if (s != null) { var sp = new SHIPPER(); sp.USERNAME = s.USERNAME; sp.ORDERID = s.ORDERID; db.SHIPPERs.Add(sp); db.SaveChanges(); return(true); } return(false); }
private void fmXemChiTietDonHang_Load(object sender, EventArgs e) { DONHANG dh = (from a in db.DONHANGs where a.MADH == madh select a).Single(); ChonShipper.DataSource = (from a in db.SHIPPERs where a.MAPT == dh.PHIGH.MAPT select a.TEN); ChonShipper.Text = "Chọn Shipper"; labelMaDonHang.Text = dh.MADH; ng.Text = dh.NGUOIGUI.HOTEN; nn.Text = dh.NGUOINHAN.HOTEN; dcnn.Text = dh.NGUOINHAN.DIACHI; dcng.Text = dh.NGUOIGUI.DIACHI; if (dh.TTHD == "Chờ vận chuyển") { LoadChoGiaoHang(); } if (dh.TTHD == "Đang trì hoãn") { LoadTriHoan(); } else { SHIPPER sp = (from a in db.SHIPPERs where dh.PHIGH.MASHIPPER == a.MASHIPPER select a).SingleOrDefault(); if (dh.TTHD == "Đang giao hàng") { LoadDangGiaoHang(sp.TEN); } if (dh.TTHD == "Chờ nhận hàng") { LoadChoNhanHang(sp.TEN); } if (dh.TTHD == "Đang hoàn trả") { LoadDangHoanTra(sp.TEN); } if (dh.TTHD == "Đã hủy") { LoadDaHuy(sp.TEN); } if (dh.TTHD == "Giao hàng thành công") { LoadGiaoHangThanhCong(sp.TEN); } } }
public ActionResult Insert(SHIPPER entity, string PassW, string rePassW) { if (Session["Account"] == null) { return(RedirectToAction("Index", "Login", new { area = "" })); } else { if (Session["URL"] == null) { Session["URL"] = HttpContext.Request.UrlReferrer.AbsoluteUri.ToString(); ViewBag.URL = Session["URL"]; } else { ViewBag.URL = Session["URL"]; } if (!new AccountModel().CheckExist(entity.SDT)) { if (PassW == rePassW) { ShipperModel shipper = new ShipperModel(); if (shipper.insertShipper(entity, PassW)) { TempData["Alert-Message"] = "Thêm Shipper thành công"; TempData["AlertType"] = "alert-success"; } else { TempData["Alert-Message"] = "Thêm Shipper thất bại"; TempData["AlertType"] = "alert-danger"; } } else { TempData["Alert-Message"] = "Xác thực mật khẩu không đúng"; TempData["AlertType"] = "alert-danger"; } } else { TempData["Alert-Message"] = "Số điện thoại đã tồn tại"; TempData["AlertType"] = "alert-danger"; } return(View(entity)); } }
private void btLuu_Click(object sender, EventArgs e) { if (CheckNull() == false) { DONHANG dh = (from a in db.DONHANGs where a.MADH == madon select a).Single(); //update dh.NGUOIGUI.HOTEN = NGTen.Text; dh.NGUOIGUI.DIACHI = NGDiaChi.Text; dh.NGUOIGUI.SDT = NGSDT.Text; dh.NGUOINHAN.DIACHI = NNDC.Text; dh.NGUOINHAN.SDT = NNSDT.Text; dh.NGUOINHAN.HOTEN = NNTEN.Text; dh.PHIGH.MAPT = (from a in db.PHUONGTIENs where a.TENPT == cbLoaihinhvantai.Text select a.MAPT).Single(); try { SHIPPER sp = (from a in db.SHIPPERs where a.MAPT == dh.PHIGH.MAPT && a.TEN == cbShipper.SelectedItem select a).SingleOrDefault(); MessageBox.Show("Tên: " + sp.TEN + "\nMã: " + sp.MASHIPPER); dh.PHIGH.MASHIPPER = sp.MASHIPPER; } catch (Exception er) { MessageBox.Show("sai"); } dh.PHIGH.PHUPHI = int.Parse(phuphi.Text); dh.NGAYGUI = T2NgayGuiHang.DateTime; dh.TTHD = cbTinhtrangdh.Text; dh.PHIGH.TTPHI = cbtinhtrangphi.Text; dh.PHIGH.TONGPHI = TinhPhi(); dh.HANG.NOIDUNG = T2Noidung.Text; dh.HANG.CAO = Convert.ToDouble(T2Cao.Text); dh.HANG.DAI = Convert.ToDouble(T2Dai.Text); dh.HANG.RONG = Convert.ToDouble(T2Rong.Text); dh.HANG.TRONGLUONG = Convert.ToDouble(T2TrongLuong.Text); dh.HANG.GHICHU = T2Ghichu.Text; db.SubmitChanges(); XtraMessageBox.Show("Sửa đơn hàng " + dh.MADH + " thành công!", "Sửa thành công!"); } }
public bool insertShipper(SHIPPER sp, string PassW) { object[] sqlparams = { new SqlParameter("@SDT", sp.SDT), new SqlParameter("@TenShipper", sp.TenKH), new SqlParameter("@DiaChi", sp.DiaChi), new SqlParameter("@Email", sp.Email), new SqlParameter("@CMND", sp.CMND), new SqlParameter("@PassW", PassW) }; try { db.Database.ExecuteSqlCommand("insertShipper @SDT, @TenShipper, @DiaChi, @Email, @CMND, @PassW", sqlparams); return(true); } catch { } return(false); }
public bool updateShipepr(SHIPPER sp) { object[] sqlparams = { new SqlParameter("@SDT", sp.SDT), new SqlParameter("@TenShipper", sp.TenKH), new SqlParameter("@DiaChi", sp.DiaChi), new SqlParameter("@Email", sp.Email), new SqlParameter("@CMND", sp.CMND) }; try { db.Database.ExecuteSqlCommand("updateShipper @SDT, @TenShipper, @DiaChi, @Email, @CMND", sqlparams); return(true); } catch { } return(false); }
public ActionResult Info(SHIPPER entity) { if (Session["Account"] == null) { return(RedirectToAction("Index", "Login", new { area = "" })); } else { ShipperModel shipper = new ShipperModel(); if (shipper.updateShipepr(entity)) { TempData["Alert-Message"] = "Chỉnh sửa thông tin Shipper thành công"; TempData["AlertType"] = "alert-success"; return(RedirectToAction("Info", new { SDT = entity.SDT })); } else { TempData["Alert-Message"] = "Chỉnh sửa thông tin Shipper thất bại"; TempData["AlertType"] = "alert-danger"; } return(View(entity)); } }