//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));
}
}
