public ActionResult Edit(Models.KHACH_HANG khachHang)
{
var ctx = new SmsContext();
if (ModelState.IsValid)
{
try
{
var db = new SmsContext();
var khuVucNew = db.KHACH_HANG.Find(khachHang.MA_KHACH_HANG);
khuVucNew.TEN_KHACH_HANG = khachHang.TEN_KHACH_HANG;
khuVucNew.MA_THE_KHACH_HANG = khachHang.MA_THE_KHACH_HANG;
khuVucNew.DIA_CHI = khachHang.DIA_CHI;
khuVucNew.SO_DIEN_THOAI = khachHang.SO_DIEN_THOAI;
khuVucNew.EMAIL = khachHang.EMAIL;
khuVucNew.MA_KHU_VUC = khachHang.MA_KHU_VUC;
if ((bool)Session["IsAdmin"] || (bool)Session["IsAccounting"])
{
khuVucNew.DOANH_SO = (khachHang.DOANH_SO == null ? 0 : khachHang.DOANH_SO);
khuVucNew.NO_GOI_DAU = (khachHang.NO_GOI_DAU == null ? 0 : khachHang.NO_GOI_DAU);
khuVucNew.NGAY_PHAT_SINH_NO = khachHang.NGAY_PHAT_SINH_NO;
}
khuVucNew.KIND = khachHang.KIND;
khuVucNew.ACTIVE = "A";
khuVucNew.UPDATE_AT = DateTime.Now;
khuVucNew.UPDATE_BY = (int)Session["UserId"];
db.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index").Success("Lưu thành công"));
}
catch (Exception ex)
{
var khuVucList = (from s in ctx.KHU_VUC
where s.ACTIVE == "A"
select s).ToList <KHU_VUC>();
ViewBag.khuVucList = khuVucList;
return(View(khachHang).Error("Không thể lưu thông tin khách hàng. Vui lòng kiểm tra lại CODE."));
}
}
else
{
var khuVucList = (from s in ctx.KHU_VUC
where s.ACTIVE == "A"
select s).ToList <KHU_VUC>();
ViewBag.khuVucList = khuVucList;
ctx.Dispose();
return(View());
}
}
public ActionResult UpdateDebit(Models.KHACH_HANG khachHang)
{
//string a = Request.Form["amount"];
decimal amount = (decimal)khachHang.SoTienKhachTra;
//Decimal.TryParse(a, out amount);
// a = Request.Form["returnDate"];
DateTime returnDate = khachHang.NgayTraNo;
if (khachHang.NgayTraNo != null)
{
//returnDate = DateTime.ParseExact(a, "dd/MM/yyyy", CultureInfo.InvariantCulture);
//ViewBag.returnDate = returnDate.ToString("dd/MM/yyyy");
}
else
{
ViewBag.Message = "Vui lòng nhập đầy đủ thông tin.";
ViewBag.returnDate = "";
}
decimal oldDebit = khachHang.NO_GOI_DAU;
decimal newDebit = khachHang.NO_GOI_DAU - amount;
if (amount == 0)
{
ViewBag.Message = "Vui lòng nhập đầy đủ thông tin.";
ViewBag.amount = "";
ViewBag.newDebit = "";
}
else
{
ViewBag.amount = amount;
ViewBag.newDebit = newDebit;
}
int flg = Convert.ToInt32(Request.Form["flg"]);
string note = khachHang.NTextNotes;
ViewBag.note = note;
if (amount != 0 && returnDate != DateTime.MinValue)
{
var db = new SmsContext();
var donVitinh = db.KHACH_HANG.Find((int)khachHang.MA_KHACH_HANG);
donVitinh.NO_GOI_DAU = newDebit;
if (newDebit <= 0)
{
donVitinh.NGAY_PHAT_SINH_NO = null;
}
donVitinh.ACTIVE = "A";
donVitinh.UPDATE_AT = DateTime.Now;
donVitinh.UPDATE_BY = (int)Session["UserId"];
var debitHist = db.KHACH_HANG_DEBIT_HIST.Create();
debitHist.MA_KHACH_HANG = khachHang.MA_KHACH_HANG;
debitHist.MA_NHAN_VIEN_TH = (int)Session["UserId"];
debitHist.NGAY_PHAT_SINH = returnDate;
debitHist.NO_TRUOC = (double)oldDebit;
debitHist.NO_SAU = (double)newDebit;
debitHist.PHAT_SINH = (double)amount;
debitHist.GHI_CHU = string.IsNullOrWhiteSpace(note)? "": note.Trim();
debitHist.ACTIVE = "A";
debitHist.UPDATE_AT = DateTime.Now;
debitHist.CREATE_AT = DateTime.Now;
debitHist.UPDATE_BY = (int)Session["UserId"];
debitHist.CREATE_BY = (int)Session["UserId"];
db.KHACH_HANG_DEBIT_HIST.Add(debitHist);
db.SaveChanges();
db.Dispose();
if (flg == 1)
{
return(RedirectToAction("Index").Success("Lưu thành công"));
}
else
{
return(RedirectToAction("Warning").Success("Lưu thành công"));
}
}
return(View(khachHang));
}
