public ActionResult Config()
{
SmsMasterModel model = new SmsMasterModel();
var ctx = new SmsContext();
var companyName = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "COMPANY_NAME").FirstOrDefault();
var address = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADDRESS").FirstOrDefault();
var phoneNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "PHONE_NUMBER").FirstOrDefault();
var faxNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "FAX_NUMBER").FirstOrDefault();
var advertisementHeader = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_HEADER").FirstOrDefault();
var advertisementFooter = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_FOOTER").FirstOrDefault();
var email = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "EMAIL").FirstOrDefault();
var emailUser = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "EMAIL_USR").FirstOrDefault();
var emailPass = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "EMAIL_PASS").FirstOrDefault();
model.CompanyName = companyName == null ? "" : companyName.VALUE;
model.Address = address == null ? "" : address.VALUE;
model.AdvertisementHeader = advertisementHeader == null ? "" : advertisementHeader.VALUE;
model.AdvertisementFooter = advertisementFooter == null ? "" : advertisementFooter.VALUE;
model.PhoneNumber = phoneNumber == null ? "" : phoneNumber.VALUE;
model.FaxNumber = faxNumber == null ? "" : faxNumber.VALUE;
model.Email = email == null ? "" : email.VALUE;
model.EmailUserName = emailUser == null? "" : emailUser.VALUE;
model.EmailPassword = emailPass == null ? "" : emailPass.VALUE;
ctx.Dispose();
return(View(model));
}
public ActionResult Payment(int id)
{
var ctx = new SmsContext();
InvoicesModel model = new InvoicesModel();
var invoiceInfor = ctx.SP_GET_HOA_DON_INFO(id).FirstOrDefault();
List <V_HOA_DON> detailList = ctx.V_HOA_DON.Where(dh => dh.MA_HOA_DON == id).ToList();
model.Infor = invoiceInfor;
model.detailList = detailList;
SmsMasterModel master = new SmsMasterModel();
var companyName = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "COMPANY_NAME").FirstOrDefault();
var address = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADDRESS").FirstOrDefault();
var phoneNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "PHONE_NUMBER").FirstOrDefault();
var faxNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "FAX_NUMBER").FirstOrDefault();
var advertisementHeader = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_HEADER").FirstOrDefault();
var advertisementFooter = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_FOOTER").FirstOrDefault();
master.CompanyName = companyName == null ? "" : companyName.VALUE;
master.Address = address == null ? "" : address.VALUE;
master.AdvertisementHeader = advertisementHeader == null ? "" : advertisementHeader.VALUE;
master.AdvertisementFooter = advertisementFooter == null ? "" : advertisementFooter.VALUE;
master.PhoneNumber = phoneNumber == null ? "" : phoneNumber.VALUE;
master.FaxNumber = faxNumber == null ? "" : faxNumber.VALUE;
model.SmsMaster = master;
ctx.Dispose();
return(View(model));
}
public ActionResult Config(SmsMasterModel model)
{
if (ModelState.IsValid)
{
var db = new SmsContext();
var companyName = db.SMS_MASTER.Where(u => u.NAME == "COMPANY_NAME" && u.ACTIVE == "A").FirstOrDefault();
if (companyName == null)
{
companyName = db.SMS_MASTER.Create();
companyName.NAME = "COMPANY_NAME";
companyName.VALUE = model.CompanyName;
companyName.UPDATE_AT = DateTime.Now;
companyName.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
companyName.CREATE_AT = DateTime.Now;
companyName.CREATE_BY = Convert.ToInt32(Session["UserId"]);
companyName.ACTIVE = "A";
db.SMS_MASTER.Add(companyName);
db.SaveChanges();
}
else
{
companyName.VALUE = model.CompanyName;
companyName.UPDATE_AT = DateTime.Now;
companyName.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var address = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADDRESS").FirstOrDefault();
if (address == null)
{
address = db.SMS_MASTER.Create();
address.NAME = "ADDRESS";
address.VALUE = model.Address;
address.UPDATE_AT = DateTime.Now;
address.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
address.CREATE_AT = DateTime.Now;
address.CREATE_BY = Convert.ToInt32(Session["UserId"]);
address.ACTIVE = "A";
db.SMS_MASTER.Add(address);
db.SaveChanges();
}
else
{
address.VALUE = model.Address;
address.UPDATE_AT = DateTime.Now;
address.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var phoneNumber = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "PHONE_NUMBER").FirstOrDefault();
if (phoneNumber == null)
{
phoneNumber = db.SMS_MASTER.Create();
phoneNumber.NAME = "PHONE_NUMBER";
phoneNumber.VALUE = model.PhoneNumber;
phoneNumber.UPDATE_AT = DateTime.Now;
phoneNumber.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
phoneNumber.CREATE_AT = DateTime.Now;
phoneNumber.CREATE_BY = Convert.ToInt32(Session["UserId"]);
phoneNumber.ACTIVE = "A";
db.SMS_MASTER.Add(phoneNumber);
db.SaveChanges();
}
else
{
phoneNumber.VALUE = model.PhoneNumber;
phoneNumber.UPDATE_AT = DateTime.Now;
phoneNumber.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var faxNumber = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "FAX_NUMBER").FirstOrDefault();
if (faxNumber == null)
{
faxNumber = db.SMS_MASTER.Create();
faxNumber.NAME = "FAX_NUMBER";
faxNumber.VALUE = model.FaxNumber;
faxNumber.UPDATE_AT = DateTime.Now;
faxNumber.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
faxNumber.CREATE_AT = DateTime.Now;
faxNumber.CREATE_BY = Convert.ToInt32(Session["UserId"]);
faxNumber.ACTIVE = "A";
db.SMS_MASTER.Add(faxNumber);
db.SaveChanges();
}
else
{
faxNumber.VALUE = model.FaxNumber;
faxNumber.UPDATE_AT = DateTime.Now;
faxNumber.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var advertisementHeader = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_HEADER").FirstOrDefault();
if (advertisementHeader == null)
{
advertisementHeader = db.SMS_MASTER.Create();
advertisementHeader.NAME = "ADVERTISEMENT_HEADER";
advertisementHeader.VALUE = model.AdvertisementHeader;
advertisementHeader.CREATE_AT = DateTime.Now;
advertisementHeader.CREATE_BY = Convert.ToInt32(Session["UserId"]);
advertisementHeader.UPDATE_AT = DateTime.Now;
advertisementHeader.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
advertisementHeader.ACTIVE = "A";
db.SMS_MASTER.Add(advertisementHeader);
db.SaveChanges();
}
else
{
advertisementHeader.VALUE = model.AdvertisementHeader;
advertisementHeader.UPDATE_AT = DateTime.Now;
advertisementHeader.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var advertisementFooter = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_FOOTER").FirstOrDefault();
if (advertisementFooter == null)
{
advertisementFooter = db.SMS_MASTER.Create();
advertisementFooter.NAME = "ADVERTISEMENT_FOOTER";
advertisementFooter.VALUE = model.AdvertisementFooter;
advertisementFooter.CREATE_AT = DateTime.Now;
advertisementFooter.CREATE_BY = Convert.ToInt32(Session["UserId"]);
advertisementFooter.UPDATE_AT = DateTime.Now;
advertisementFooter.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
advertisementFooter.ACTIVE = "A";
db.SMS_MASTER.Add(advertisementFooter);
db.SaveChanges();
}
else
{
advertisementFooter.VALUE = model.AdvertisementFooter;
advertisementFooter.UPDATE_AT = DateTime.Now;
advertisementFooter.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var email = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "EMAIL").FirstOrDefault();
if (email == null)
{
email = db.SMS_MASTER.Create();
email.NAME = "EMAIL";
email.VALUE = model.Email;
email.CREATE_AT = DateTime.Now;
email.CREATE_BY = Convert.ToInt32(Session["UserId"]);
email.UPDATE_AT = DateTime.Now;
email.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
email.ACTIVE = "A";
db.SMS_MASTER.Add(email);
db.SaveChanges();
}
else
{
email.VALUE = model.Email;
email.UPDATE_AT = DateTime.Now;
email.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var emailUser = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "EMAIL_USR").FirstOrDefault();
if (emailUser == null)
{
emailUser = db.SMS_MASTER.Create();
emailUser.NAME = "EMAIL_USR";
emailUser.VALUE = model.EmailUserName;
emailUser.CREATE_AT = DateTime.Now;
emailUser.CREATE_BY = Convert.ToInt32(Session["UserId"]);
emailUser.UPDATE_AT = DateTime.Now;
emailUser.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
emailUser.ACTIVE = "A";
db.SMS_MASTER.Add(emailUser);
db.SaveChanges();
}
else
{
emailUser.VALUE = model.EmailUserName;
emailUser.UPDATE_AT = DateTime.Now;
emailUser.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
var emailPass = db.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "EMAIL_PASS").FirstOrDefault();
if (emailPass == null)
{
emailPass = db.SMS_MASTER.Create();
emailPass.NAME = "EMAIL_PASS";
emailPass.VALUE = EmailManager.Encrypt(model.EmailPassword, SystemConstant.SALT);
emailPass.CREATE_AT = DateTime.Now;
emailPass.CREATE_BY = Convert.ToInt32(Session["UserId"]);
emailPass.UPDATE_AT = DateTime.Now;
emailPass.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
emailPass.ACTIVE = "A";
db.SMS_MASTER.Add(emailPass);
db.SaveChanges();
}
else
{
emailPass.VALUE = EmailManager.Encrypt(model.EmailPassword, SystemConstant.SALT);
emailPass.UPDATE_AT = DateTime.Now;
emailPass.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
}
ViewBag.InforMessage = "Cập nhật thông tin thành công.";
return(View(model));
}
return(View(model));
}
public ActionResult Payment(InvoicesModel model)
{
var ctx = new SmsContext();
var invoice = ctx.HOA_DON.Find(model.Infor.MA_HOA_DON);
if (invoice != null && invoice.STATUS >= 2)
{
return(RedirectToAction("Collection", new { @messagae = "Hóa đơn đã được thu tiền." }));
}
if (invoice != null && invoice.ACTIVE == "A")
{
if (model.Infor.SO_TIEN_KHACH_TRA == null)
{
model.Infor.SO_TIEN_KHACH_TRA = 0;
}
if (model.Infor.SO_TIEN_KHACH_TRA <= (model.Infor.TONG_TIEN - model.Infor.CHIEC_KHAU))
{
model.Infor.SO_TIEN_NO_GOI_DAU = (model.Infor.TONG_TIEN - model.Infor.CHIEC_KHAU) - model.Infor.SO_TIEN_KHACH_TRA;
}
else
{
model.Infor.SO_TIEN_KHACH_TRA = (model.Infor.TONG_TIEN - model.Infor.CHIEC_KHAU);
model.Infor.SO_TIEN_NO_GOI_DAU = 0;
}
invoice.SO_TIEN_KHACH_TRA = model.Infor.SO_TIEN_KHACH_TRA;
invoice.SO_TIEN_NO_GOI_DAU = model.Infor.SO_TIEN_NO_GOI_DAU;
invoice.STATUS = 2;
invoice.UPDATE_AT = DateTime.Now;
invoice.UPDATE_BY = (int)Session["UserId"];
invoice.MA_NHAN_VIEN_THU_TIEN = (int)Session["UserId"];
if (Convert.ToInt32(model.Infor.MA_KHACH_HANG) > 0)
{
var customer = ctx.KHACH_HANG.Find(Convert.ToInt32(model.Infor.MA_KHACH_HANG));
if (customer != null && customer.ACTIVE == "A")
{
customer.DOANH_SO = customer.DOANH_SO + Convert.ToDecimal(model.Infor.TONG_TIEN) - Convert.ToDecimal(model.Infor.CHIEC_KHAU);
if (model.Infor.SO_TIEN_NO_GOI_DAU > 0)
{
if (customer.NGAY_PHAT_SINH_NO == null)
{
customer.NGAY_PHAT_SINH_NO = DateTime.Now;
}
var DebitHist = ctx.KHACH_HANG_DEBIT_HIST.Create();
DebitHist.NO_TRUOC = Convert.ToDouble(customer.NO_GOI_DAU);
DebitHist.NO_SAU = Convert.ToDouble(customer.NO_GOI_DAU) + model.Infor.SO_TIEN_NO_GOI_DAU;
DebitHist.NGAY_PHAT_SINH = DateTime.Now;
DebitHist.PHAT_SINH = -1 * Convert.ToDouble(model.Infor.SO_TIEN_NO_GOI_DAU);
DebitHist.MA_HOA_DON = model.Infor.MA_HOA_DON;
DebitHist.MA_KHACH_HANG = customer.MA_KHACH_HANG;
DebitHist.MA_NHAN_VIEN_TH = (int)Session["UserId"];
DebitHist.ACTIVE = "A";
DebitHist.UPDATE_AT = DateTime.Now;
DebitHist.UPDATE_BY = (int)Session["UserId"];
DebitHist.CREATE_AT = DateTime.Now;
DebitHist.CREATE_BY = (int)Session["UserId"];
ctx.KHACH_HANG_DEBIT_HIST.Add(DebitHist);
}
//customer.NO_GOI_DAU = customer.NO_GOI_DAU + Convert.ToDecimal(model.Infor.SO_TIEN_NO_GOI_DAU);
customer.NO_GOI_DAU = Convert.ToDecimal(model.Infor.SO_TIEN_NO_GOI_DAU);
customer.UPDATE_AT = DateTime.Now;
customer.UPDATE_BY = (int)Session["UserId"];
}
else
{
ViewBag.Message = "Không tìm thấy khách hàng tương ứng.";
return(View("../Home/Error"));
}
}
ctx.SaveChanges();
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy hóa đơn tương ứng.";
return(View("../Home/Error"));
}
var invoiceInfor = ctx.SP_GET_HOA_DON_INFO(model.Infor.MA_HOA_DON).FirstOrDefault();
List <V_HOA_DON> detailList = ctx.V_HOA_DON.Where(dh => dh.MA_HOA_DON == model.Infor.MA_HOA_DON).ToList();
model.Infor = invoiceInfor;
model.detailList = detailList;
SmsMasterModel master = new SmsMasterModel();
var companyName = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "COMPANY_NAME").FirstOrDefault();
var address = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADDRESS").FirstOrDefault();
var phoneNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "PHONE_NUMBER").FirstOrDefault();
var faxNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "FAX_NUMBER").FirstOrDefault();
var advertisementHeader = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_HEADER").FirstOrDefault();
var advertisementFooter = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_FOOTER").FirstOrDefault();
master.CompanyName = companyName == null ? "" : companyName.VALUE;
master.Address = address == null ? "" : address.VALUE;
master.AdvertisementHeader = advertisementHeader == null ? "" : advertisementHeader.VALUE;
master.AdvertisementFooter = advertisementFooter == null ? "" : advertisementFooter.VALUE;
master.PhoneNumber = phoneNumber == null ? "" : phoneNumber.VALUE;
master.FaxNumber = faxNumber == null ? "" : faxNumber.VALUE;
model.SmsMaster = master;
ctx.Dispose();
return(View(model));
}
public ActionResult PaymentAndExport(InvoicesModel model)
{
var ctx = new SmsContext();
var InvoiceId = new SqlParameter
{
ParameterName = "MA_HOA_DON",
Value = Convert.ToInt32(model.Infor.MA_HOA_DON)
};
var UserId = new SqlParameter
{
ParameterName = "MA_NHAN_VIEN_THUC_HIEN",
Value = Convert.ToInt32(Session["UserId"])
};
if (model.Infor.SO_TIEN_KHACH_TRA >= (model.Infor.TONG_TIEN - model.Infor.CHIEC_KHAU))
{
model.Infor.SO_TIEN_KHACH_TRA = model.Infor.TONG_TIEN - model.Infor.CHIEC_KHAU;
}
var TotalPay = new SqlParameter
{
ParameterName = "SO_TIEN_KHACH_TRA",
Value = Convert.ToDouble(model.Infor.SO_TIEN_KHACH_TRA)
};
var returnValue = new SqlParameter
{
ParameterName = "RETURN_VALUE",
Value = Convert.ToInt32(0),
Direction = ParameterDirection.Output
};
ctx.Database.CommandTimeout = 300;
var tonkho = ctx.Database.ExecuteSqlCommand("exec SP_THU_TIEN_XUAT_KHO @MA_HOA_DON, @MA_NHAN_VIEN_THUC_HIEN, @SO_TIEN_KHACH_TRA , @RETURN_VALUE OUT",
InvoiceId,
UserId,
TotalPay,
returnValue
);
int returnVal = Convert.ToInt32(returnValue.Value);
int flg = Convert.ToInt32(Request.Form["flg"]);
if (returnVal == 0)
{
ViewBag.Message = "Không đủ số lượng để xuất kho. Vui lòng kiểm tra lại hóa đơn.";
ViewBag.Status = 0;
ctx.Dispose();
return(RedirectToAction("ShowDetail", new { @id = model.Infor.MA_HOA_DON, @flg = flg, @status = 0 }));
}
else if (returnVal == -1)
{
ViewBag.Message = "Hóa đơn đã được thu tiền. Không thể thu tiền hóa đơn này";
ViewBag.Status = -1;
ctx.Dispose();
return(RedirectToAction("ShowDetail", new { @id = model.Infor.MA_HOA_DON, @flg = flg, @status = -1 }));
}
var invoiceInfor = ctx.SP_GET_HOA_DON_INFO(model.Infor.MA_HOA_DON).FirstOrDefault();
List <V_HOA_DON> detailList = ctx.V_HOA_DON.Where(dh => dh.MA_HOA_DON == model.Infor.MA_HOA_DON).ToList();
model.Infor = invoiceInfor;
model.detailList = detailList;
SmsMasterModel master = new SmsMasterModel();
var companyName = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "COMPANY_NAME").FirstOrDefault();
var address = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADDRESS").FirstOrDefault();
var phoneNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "PHONE_NUMBER").FirstOrDefault();
var faxNumber = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "FAX_NUMBER").FirstOrDefault();
var advertisementHeader = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_HEADER").FirstOrDefault();
var advertisementFooter = ctx.SMS_MASTER.Where(u => u.ACTIVE == "A" && u.NAME == "ADVERTISEMENT_FOOTER").FirstOrDefault();
master.CompanyName = companyName == null ? "" : companyName.VALUE;
master.Address = address == null ? "" : address.VALUE;
master.AdvertisementHeader = advertisementHeader == null ? "" : advertisementHeader.VALUE;
master.AdvertisementFooter = advertisementFooter == null ? "" : advertisementFooter.VALUE;
master.PhoneNumber = phoneNumber == null ? "" : phoneNumber.VALUE;
master.FaxNumber = faxNumber == null ? "" : faxNumber.VALUE;
model.SmsMaster = master;
ctx.Dispose();
return(View(model));
}
