public ActionResult EditExpense(EXPENS model)
{
if (ModelState.IsValid)
{
var ctx = new SmsContext();
var Ex = ctx.EXPENSES.Find(model.ID);
if (Ex != null && Ex.ACTIVE == "A")
{
Ex.LOAI_CHI = model.LOAI_CHI;
Ex.NGAY_CHI = model.NGAY_CHI;
Ex.GHI_CHU = model.GHI_CHU;
Ex.TEN_NGUOI_NHAN = model.TEN_NGUOI_NHAN;
Ex.TONG_CHI = model.TONG_CHI;
Ex.UPDATE_AT = DateTime.Now;
Ex.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index", new { @inforMessage = "Lưu thành công." }));
}
else
{
ctx.Dispose();
return(RedirectToAction("Index", new { @message = "Không tồn tại phiếu chi này. Phiếu chi này đã bị xóa." }));
}
}
return(View(model));
}
public PartialViewResult ReturnPurchaseListPartialView(string customerName, DateTime?fromDate,
DateTime?toDate, int?userId, string userName, int?currentPageIndex)
{
if (string.IsNullOrEmpty(userName))
{
userName = string.Empty;
userId = 0;
}
if (fromDate == null)
{
fromDate = SystemConstant.MIN_DATE;
}
if (toDate == null)
{
toDate = SystemConstant.MAX_DATE;
}
var ctx = new SmsContext();
var resultList = ctx.SP_GET_RETURN_LIST(customerName, fromDate, toDate, userId, userName).Take(SystemConstant.MAX_ROWS).ToList <SP_GET_RETURN_LIST_Result>();
int pageSize = SystemConstant.ROWS;
int pageIndex = currentPageIndex == null ? 1 : (int)currentPageIndex;
CustomerReturn model = new CustomerReturn();
model.detailReturnList = resultList.ToPagedList(pageIndex, pageSize);
model.Count = resultList.Count;
ViewBag.CustomerName = customerName;
ViewBag.UserId = userId;
ViewBag.UserName = userName;
ViewBag.FromDate = ((DateTime)fromDate).ToString("dd/MM/yyyy");
ViewBag.Todate = ((DateTime)toDate).ToString("dd/MM/yyyy");
ctx.Dispose();
return(PartialView("ReturnPurchaseListPartialView", model));
}
public PartialViewResult PagingContent(string SearchString, int?currentPageIndex)
{
IPagedList <SP_GET_TON_KHO_ALERT> tk = null;
ViewBag.SearchString = SearchString;
int pageSize = SystemConstant.ROWS;
int pageIndex = currentPageIndex == null ? 1 : (int)currentPageIndex;
var ctx = new SmsContext();
ctx.Database.CommandTimeout = 300;
// var watch = Stopwatch.StartNew();
var ListKho = ctx.KHOes.Where(u => u.ACTIVE.Equals("A")).ToList();
string s = ctx.Database.Connection.ToString();
var tonkho = ctx.Database.SqlQuery <SP_GET_TON_KHO_ALERT>("exec SP_GET_TON_KHO_ALERT @NAME ", new SqlParameter("NAME", string.IsNullOrEmpty(SearchString) ? "" : SearchString.Trim())).ToList <SP_GET_TON_KHO_ALERT>().Take(SystemConstant.MAX_ROWS);;
ViewBag.CurrentPageIndex = pageIndex;
ViewBag.Count = tonkho.Count();
tk = tonkho.ToList().ToPagedList(pageIndex, pageSize);
ViewBag.KhoList = ListKho;
ViewBag.tonKho = tk;
GetTonKhoAlertModel model = new GetTonKhoAlertModel();
model.WarningList = tk;
ViewBag.SearchString = SearchString;
ctx.Dispose();
return(PartialView("IndexPartialView", model));
}
public JsonResult CancelPermission(int userId, int storeId)
{
object yourOjbect;
string data = "";
var ctx = new SmsContext();
var usrStore = ctx.USER_STORE.Where(u => u.ACTIVE == "A" && u.MA_KHO == storeId && u.USR_ID == userId).FirstOrDefault();
if (usrStore != null)
{
usrStore.ACTIVE = "I";
usrStore.IS_DEFAULT = false;
ctx.SaveChanges();
data = "{ \"Message \" : \"Hủy quyền thành công.\"}";
yourOjbect = new JavaScriptSerializer().DeserializeObject(data);
ctx.Dispose();
return(Json(yourOjbect));
}
else
{
ViewBag.Message = "Không tìm thấy người dùng với quyền tương ứng.";
data = "{ \"Message \" : \"Không tìm thấy người dùng với quyền tương ứng.\"}";
yourOjbect = new JavaScriptSerializer().DeserializeObject(data);
ctx.Dispose();
return(Json(yourOjbect));
}
}
public PartialViewResult MthReportPartialView(DateTime?fromDate, DateTime?toDate)
{
var ctx = new SmsContext();
if (fromDate == null)
{
fromDate = SystemConstant.MIN_DATE;
}
if (toDate == null)
{
toDate = SystemConstant.MAX_DATE;
}
var FromDateParam = new SqlParameter
{
ParameterName = "START_TIME",
Value = Convert.ToDateTime(fromDate)
};
var ToDateParam = new SqlParameter
{
ParameterName = "END_TIME",
Value = Convert.ToDateTime(toDate)
};
var tonkho = ctx.Database.SqlQuery <Report>("exec SP_REPORT_BY_MONTH @START_TIME, @END_TIME",
FromDateParam, ToDateParam).Take(SystemConstant.MAX_ROWS).ToList <Report>();
ReportModel model = new ReportModel();
model.TheList = tonkho;
ctx.Dispose();
return(PartialView("MthReportPartialView", model));
}
public ActionResult Delete(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
KHO khuVuc = ctx.KHOes.Find(id);
if (khuVuc.ACTIVE.Equals("A"))
{
khuVuc.ACTIVE = "I";
khuVuc.UPDATE_AT = DateTime.Now;
khuVuc.UPDATE_BY = (int)Session["UserId"];
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index").Success("Xóa thành công."));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult Delete(int id)
{
if (id == (int)Session["UserId"])
{
ViewBag.Message = "Bạn không thể xóa chính mình ra khỏi hệ thống.";
return(View("../Home/Error"));;
}
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy người dùng tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
var nguoidung = ctx.NGUOI_DUNG.Find(id);
if (nguoidung.ACTIVE.Equals("A"))
{
nguoidung.ACTIVE = "I";
nguoidung.UPDATE_AT = DateTime.Now;
nguoidung.CREATE_BY = (int)Session["UserId"];
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index").Success("Xóa thành công"));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy người dùng tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult Edit(int id)
{
if (id < 0)
{
return(RedirectToAction("Index", "HoaDon", new { @message = "Không tìm thấy hóa đơn này." }));
}
var ctx = new SmsContext();
var Infor = ctx.SP_GET_BILL_INFOR(id).FirstOrDefault();
if (Infor == null)
{
return(RedirectToAction("Index", "HoaDon", new { @message = "Không tìm thấy hóa đơn này." }));
}
var details = ctx.SP_GET_BILL_DETAIL_BY_ID(id).ToList <SP_GET_BILL_DETAIL_BY_ID_Result>();
var stores = ctx.KHOes.Where(u => u.ACTIVE == "A").ToList();
var units = ctx.DON_VI_TINH.Where(u => u.ACTIVE == "A").ToList();
EditHoaDonBanHang model = new EditHoaDonBanHang();
model.Store = stores;
model.Units = units;
model.Infor = Infor;
model.Details = details;
ctx.Dispose();
return(View(model));
}
private List <ChiTiet_HoaDon> getDetailsByBillNo(int MaHoaDon)
{
var ctx = new SmsContext();
//ctx.Configuration.LazyLoadingEnabled = true;
var lstChiTietHD = (from x in ctx.HOA_DON
join u in ctx.CHI_TIET_HOA_DON.Include("KHO") on x.MA_HOA_DON equals u.MA_HOA_DON
join sp in ctx.SAN_PHAM.Include("DON_VI_TINH") on u.MA_SAN_PHAM equals sp.MA_SAN_PHAM
where (x.MA_HOA_DON == MaHoaDon && u.ACTIVE == "A")
select new ChiTiet_HoaDon
{
Code_SP = sp.CODE,
Ma_SP = u.MA_SAN_PHAM,
Ten_SP = sp.TEN_SAN_PHAM,
Gia_Ban = u.GIA_BAN_TRUOC_CK,
Phan_Tram_CK = u.PHAN_TRAM_CHIEC_KHAU,
Gia_Thuc = u.DON_GIA,
So_Luong = u.SO_LUONG,
Ma_Kho_Xuat = u.MA_KHO_XUAT,
Ten_Kho_Xuat = u.KHO.TEN_KHO,
Ma_Don_Vi = sp.DON_VI_TINH.MA_DON_VI,
Ten_Don_Vi = sp.DON_VI_TINH.TEN_DON_VI
}).ToList();
ctx.Dispose();
return(lstChiTietHD);
}
public PartialViewResult ExportCancelListPartialView(int?storeId, string storeName, int?exporterId,
string exporterName, DateTime?fromDate, DateTime?toDate, int?currentPageIndex)
{
storeId = string.IsNullOrEmpty(storeName) || storeId == null ? 0 : storeId;
exporterId = string.IsNullOrEmpty(exporterName) || exporterId == null ? 0 : exporterId;
if (!(bool)Session["IsAdmin"])
{
exporterId = Convert.ToInt32(Session["UserId"]);
}
if (fromDate == null)
{
fromDate = SystemConstant.MIN_DATE;
}
if (toDate == null)
{
toDate = SystemConstant.MAX_DATE;
}
var ctx = new SmsContext();
var theList = ctx.SP_GET_EXPORT_4_CANCEL(storeId, storeName, exporterId, exporterName, fromDate, toDate).Take(SystemConstant.MAX_ROWS).ToList <SP_GET_EXPORT_4_CANCEL_Result>();
int pageSize = SystemConstant.ROWS;
int pageIndex = currentPageIndex == null ? 1 : (int)currentPageIndex;
CancelExportModel model = new CancelExportModel();
model.TheList = theList.ToPagedList(pageIndex, pageSize);
model.Count = theList.Count;
ViewBag.StoreId = storeId;
ViewBag.StoreName = storeName;
ViewBag.ExporterId = exporterId;
ViewBag.ExporterName = exporterName;
ViewBag.FromDate = fromDate;
ViewBag.ToDate = toDate;
ctx.Dispose();
return(PartialView("ExportCancelListPartialView", model));
}
private bool IsValid(string username, string password)
{
var crypto = new SimpleCrypto.PBKDF2();
bool IsValid = false;
using (var ctx = new SmsContext())
{
var user = ctx.NGUOI_DUNG.Where(u => u.USER_NAME.ToLower() == username.ToLower() && u.ACTIVE == "A").FirstOrDefault();
if (user != null)
{
if (user.MAT_KHAU == crypto.Compute(password, user.SALT))
{
IsValid = true;
var usRole = ctx.SP_GET_ROLE_OF_USER(Convert.ToInt32(user.MA_NGUOI_DUNG)).FirstOrDefault <SP_GET_ROLE_OF_USER_Result>();
if (usRole != null)
{
Session["UserId"] = (int)user.MA_NGUOI_DUNG;
Session["GroupUserId"] = (int)user.MA_NHOM_NGUOI_DUNG;
Session["UserName"] = user.TEN_NGUOI_DUNG;
Session["IsAdmin"] = usRole.IS_ADMIN != null ? (bool)usRole.IS_ADMIN : false;
Session["IsAccounting"] = usRole.IS_ACCOUNTING != null ? (bool)usRole.IS_ACCOUNTING : false;
Session["IsSaler"] = usRole.IS_SALER != null ? (bool)usRole.IS_SALER : false;
Session["IsMetadataManager"] = usRole.IS_METADATA_MANAGER != null ? (bool)usRole.IS_METADATA_MANAGER : false;
Session["IsStoreManager"] = usRole.IS_STORE_MANAGER != null ? (bool)usRole.IS_STORE_MANAGER : false;
Session["MyStore"] = user.MA_KHO;
}
}
}
}
return(IsValid);
}
public ActionResult Export2Provider(int id, int?storeId)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy phiếu xuất kho tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
var Infor = ctx.TRA_HANG_NCC.Include("NHA_CUNG_CAP").Where(u => u.ACTIVE == "A" && u.ID == id).FirstOrDefault();
if (Infor == null)
{
ViewBag.Message = "Không tìm thấy phiếu xuất kho tương ứng.";
ctx.Dispose();
return(View("../Home/Error"));
}
var details = ctx.SP_GET_DE_OF_RE_2_PR_BY_ST_AND_INV_ID(Convert.ToInt32(storeId), id).Take(SystemConstant.MAX_ROWS).ToList <SP_GET_DE_OF_RE_2_PR_BY_ST_AND_INV_ID_Result>();
Export2ProviderModel model = new Export2ProviderModel();
model.TheList = details;
model.Infor = Infor;
model.StoreId = Convert.ToInt32(storeId);
ctx.Dispose();
return(View(model));
}
public ActionResult Delete(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy đơn vị tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
var donvi = ctx.DON_VI_TINH.Find(id);
if (donvi.ACTIVE.Equals("A"))
{
donvi.ACTIVE = "I";
donvi.UPDATE_AT = DateTime.Now;
donvi.CREATE_BY = (int)Session["UserId"];
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index").Success("Xóa thành công."));
}
else
{
ViewBag.Message = "Không tìm thấy đơn vị tương ứng.";
ctx.Dispose();
return(View("../Home/Error"));;
}
}
public ActionResult deleteGetReturn(int id)
{
if (id < 0)
{
return(RedirectToAction("ReturnPurchaseList", new { @message = "Không tồn tại phiếu nhận hàng trả này." }));
}
var ctx = new SmsContext();
var infor = ctx.TRA_HANG.Find(id);
if (infor == null || infor.ACTIVE != "A")
{
return(RedirectToAction("ReturnPurchaseList", new { @message = "Không tồn tại phiếu nhận hàng trả này." }));
}
using (var transaction = new System.Transactions.TransactionScope())
{
try
{
if (infor.MA_KHACH_HANG != null)
{
var debitHist = ctx.KHACH_HANG_DEBIT_HIST.Where(u => u.ACTIVE == "A" && u.MA_PHIEU_TRA == id).FirstOrDefault();
var customer = ctx.KHACH_HANG.Find(infor.MA_KHACH_HANG);
if (debitHist != null)
{
if (customer.NO_GOI_DAU == 0)
{
customer.NGAY_PHAT_SINH_NO = DateTime.Now;
}
customer.NO_GOI_DAU = customer.NO_GOI_DAU + (decimal)debitHist.PHAT_SINH;
customer.UPDATE_AT = DateTime.Now;
customer.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
debitHist.ACTIVE = "I";
debitHist.UPDATE_AT = DateTime.Now;
debitHist.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
}
}
infor.ACTIVE = "I";
infor.UPDATE_AT = DateTime.Now;
infor.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
var details = ctx.CHI_TIET_TRA_HANG.Where(u => u.ACTIVE == "A" && u.MA_TRA_HANG == id).ToList <CHI_TIET_TRA_HANG>();
foreach (var detail in details)
{
detail.ACTIVE = "I";
detail.UPDATE_AT = DateTime.Now;
detail.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
}
ctx.SaveChanges();
transaction.Complete();
ctx.Dispose();
return(RedirectToAction("ReturnPurchaseList", new { @inforMessage = "Xóa phiếu trả hàng thành công." }));
}
catch (Exception ex)
{
Transaction.Current.Rollback();
Console.Write(ex.ToString());
ctx.Dispose();
return(RedirectToAction("ReturnPurchaseList", new { @message = "Xóa phiếu trả hàng thất bại." }));
}
}
}
public ActionResult Edit(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
KHO khuVuc = ctx.KHOes.Find(id);
var nguoiDungList = (from s in ctx.NGUOI_DUNG
where s.ACTIVE == "A"
select s).ToList <NGUOI_DUNG>();
ViewBag.nguoiDungList = nguoiDungList;
if (khuVuc.ACTIVE.Equals("A"))
{
ctx.Dispose();
return(View(khuVuc));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy khu vực tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult Edit(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy đơn vị tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
SMS_MESSAGES donvi = ctx.SMS_MESSAGES.Find(id);
if (donvi.ACTIVE.Equals("A"))
{
ViewBag.donVi = donvi;
var nhomNguoiDung = ctx.NHOM_NGUOI_DUNG.Where(uh => uh.ACTIVE == "A").ToList <NHOM_NGUOI_DUNG>();
ViewBag.GroupUserList = nhomNguoiDung;
ctx.Dispose();
return(View(donvi));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy đơn vị tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult Edit(SMS.Models.KHO kho)
{
if (ModelState.IsValid)
{
var db = new SmsContext();
var khuVucNew = db.KHOes.Find(kho.MA_KHO);
khuVucNew.TEN_KHO = kho.TEN_KHO;
khuVucNew.GHI_CHU = kho.GHI_CHU;
khuVucNew.DIA_CHI = kho.DIA_CHI;
khuVucNew.SO_DIEN_THOAI = kho.SO_DIEN_THOAI;
khuVucNew.MA_NGUOI_DUNG_DAU = kho.MA_NGUOI_DUNG_DAU;
khuVucNew.ACTIVE = "A";
khuVucNew.UPDATE_AT = DateTime.Now;
khuVucNew.UPDATE_BY = (int)Session["UserId"];
db.SaveChanges();
return(RedirectToAction("Index").Success("Lưu thành công"));;
}
var ctx = new SmsContext();
var nguoiDungList = (from s in ctx.NGUOI_DUNG
where s.ACTIVE == "A"
select s).ToList <NGUOI_DUNG>();
ViewBag.nguoiDungList = nguoiDungList;
ctx.Dispose();
return(View());
}
public PartialViewResult IndexPartialView(int?groupUserId, string groupUserName, string searchString, DateTime?fromDate, DateTime?toDate, int?currentPageIndex)
{
if (string.IsNullOrEmpty(groupUserName))
{
groupUserId = 0;
}
if (fromDate == null)
{
fromDate = SystemConstant.MIN_DATE;
}
if (toDate == null)
{
toDate = SystemConstant.MAX_DATE;
}
var ctx = new SmsContext();
var messageList = ctx.SP_GET_SMS_MESSAGES(Convert.ToInt32(groupUserId), groupUserName, searchString,
Convert.ToDateTime(fromDate), Convert.ToDateTime(toDate)).ToList <SP_GET_SMS_MESSAGES_Result>();
int pageSize = SystemConstant.ROWS;
int pageIndex = currentPageIndex == null ? 1 : (int)currentPageIndex;
SmsMessageModel model = new SmsMessageModel();
model.Count = messageList.Count;
model.MessageList = messageList.ToPagedList(pageIndex, pageSize);
ViewBag.GroupUserId = groupUserId;
ViewBag.GroupUserName = groupUserName;
ViewBag.SearchString = searchString;
ctx.Dispose();
return(PartialView("IndexPartialView", model));
}
public ActionResult Edit(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy người dùng tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
NGUOI_DUNG nguoidung = ctx.NGUOI_DUNG.Find(id);
if (nguoidung.ACTIVE.Equals("A"))
{
//Ma Kho
BindKho();
//Ma Nhom
BindNhomNguoiDung();
ViewBag.nguoiDung = nguoidung;
ctx.Dispose();
return(View(nguoidung));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy người dùng tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult AddNew(SMS_MESSAGES model)
{
if (ModelState.IsValid)
{
var ctx = new SmsContext();
var smsMessage = ctx.SMS_MESSAGES.Create();
smsMessage.ID_NHOM_NGUOI_NHAN = model.ID_NHOM_NGUOI_NHAN;
smsMessage.NOI_DUNG = model.NOI_DUNG;
smsMessage.NGAY_GUI = DateTime.Now;
smsMessage.ID_NGUOI_GUI = Convert.ToInt32(Session["UserId"]);
smsMessage.ACTIVE = "A";
smsMessage.CREATE_AT = DateTime.Now;
smsMessage.UPDATE_AT = DateTime.Now;
smsMessage.CREATE_BY = Convert.ToInt32(Session["UserId"]);
smsMessage.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
ctx.SMS_MESSAGES.Add(smsMessage);
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index", new { @inforMessage = "Lưu thành công." }));
}
else
{
var ctx = new SmsContext();
var nhomNguoiDung = ctx.NHOM_NGUOI_DUNG.Where(uh => uh.ACTIVE == "A").ToList <NHOM_NGUOI_DUNG>();
ViewBag.GroupUserList = nhomNguoiDung;
ctx.Dispose();
return(View());
}
}
public ActionResult SetQuestions()
{
SecurityQuestion model = new SecurityQuestion();
var ctx = new SmsContext();
var questions = ctx.SECURITY_QUESTIONS.Where(u => u.ACTIVE == "A").ToList <SECURITY_QUESTIONS>();
int userId = 0;
int.TryParse(Session["UserId"].ToString(), out userId);
var persionalQuestions = ctx.PERSONAL_QUESTIONS.Where(u => u.ACTIVE == "A" && u.USR_ID == userId).Take(3).ToList <PERSONAL_QUESTIONS>();
if (persionalQuestions != null && persionalQuestions.Count == 3)
{
model.QuestionId1 = (int)persionalQuestions[0].QUESTION_ID;
model.QuestionId2 = (int)persionalQuestions[1].QUESTION_ID;
model.QuestionId3 = (int)persionalQuestions[2].QUESTION_ID;
}
else
{
model.QuestionId1 = 0;
model.QuestionId2 = 0;
model.QuestionId3 = 0;
}
model.Questions = questions;
ctx.Dispose();
return(View(model));
}
public ActionResult Delete(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy tin nhắn tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
var donvi = ctx.SMS_MESSAGES.Find(id);
if (donvi.ACTIVE.Equals("A"))
{
if (donvi.ID_NGUOI_GUI != (int)Session["UserId"])
{
return(RedirectToAction("Index", new { @message = "Bạn không phải là người tạo ra tin nhắn này, bạn không có quyền xóa nó." }));
}
donvi.ACTIVE = "I";
donvi.UPDATE_AT = DateTime.Now;
donvi.CREATE_BY = (int)Session["UserId"];
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index", new { @inforMessage = "Xóa thành công." }));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy tin nhắn tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult Delete(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy nhóm sản phẩm tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
var nhomSP = ctx.NHOM_SAN_PHAM.Find(id);
if (nhomSP.ACTIVE.Equals("A"))
{
nhomSP.ACTIVE = "I";
nhomSP.UPDATE_AT = DateTime.Now;
nhomSP.CREATE_BY = (int)Session["UserId"];
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index").Success("Xóa thành công."));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy nhóm sản phẩm tương ứng.";
return(View("../Home/Error"));;
}
}
public ActionResult Edit(SMS_MESSAGES model)
{
var ctx = new SmsContext();
var nhomNguoiDung = ctx.NHOM_NGUOI_DUNG.Where(uh => uh.ACTIVE == "A").ToList <NHOM_NGUOI_DUNG>();
if (ModelState.IsValid)
{
if (model.ID_NGUOI_GUI != (int)Session["UserId"])
{
ctx.Dispose();
ViewBag.Message = "Bạn không phải là người tạo ra tin nhắn này, bạn không có quyền thay đổi nó.";
ViewBag.GroupUserList = nhomNguoiDung;
return(View(model));
}
else
{
var sms = ctx.SMS_MESSAGES.Find(model.ID);
sms.ID_NHOM_NGUOI_NHAN = model.ID_NHOM_NGUOI_NHAN;
sms.NOI_DUNG = model.NOI_DUNG;
sms.UPDATE_AT = DateTime.Now;
sms.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index", new { @inforMessage = "Lưu thành công." }));
}
}
ViewBag.GroupUserList = nhomNguoiDung;
return(View(model));
}
public ActionResult ImportRefund(int id)
{
var ctx = new SmsContext();
var refund = ctx.TRA_HANG.Find(id);
if (refund.ACTIVE != "A")
{
return(RedirectToAction("ReturnPurchaseList", new { @inforMessage = "Không tìm thấy phiếu trả hàng nào tương ứng." }));
}
var refundDetail = ctx.SP_GET_REFUND_DETAIL(id).ToList <SP_GET_REFUND_DETAIL_Result>();
RefundModel model = new RefundModel();
model.Infor = refund;
model.Detail = refundDetail;
if (!(bool)Session["IsAdmin"])
{
model.MaKho = Convert.ToInt32(Session["MyStore"]);
}
var stores = ctx.KHOes.Where(u => u.ACTIVE == "A").ToList <KHO>();
ViewBag.Kho = stores;
var storeList = ctx.SP_GET_STORES_BY_USR_ID(Convert.ToInt32(Session["UserId"])).ToList <SP_GET_STORES_BY_USR_ID_Result>();
model.StoreList = storeList;
ctx.Dispose();
return(View(model));
}
public ActionResult Edit(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy phân quyền tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
PHAN_QUYEN phanquyen = ctx.PHAN_QUYEN.Find(id);
if (phanquyen.ACTIVE.Equals("A"))
{
//Nguoi Dung
BindNguoiDung();
//Ma Nhom
BindNhomNguoiDung();
ViewBag.phanQuyen = phanquyen;
ctx.Dispose();
return(View(phanquyen));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy phân quyền tương ứng.";
return(View("../Home/Error"));;
}
}
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 Delete(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy phân quyền tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
var phanquyen = ctx.PHAN_QUYEN.Find(id);
if (phanquyen.ACTIVE.Equals("A"))
{
phanquyen.ACTIVE = "I";
phanquyen.UPDATE_AT = DateTime.Now;
phanquyen.CREATE_BY = (int)Session["UserId"];
ctx.SaveChanges();
ctx.Dispose();
return(RedirectToAction("Index").Success("Xóa thành công."));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy phân quyền tương ứng.";
return(View("../Home/Error"));;
}
}
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 PartialViewResult IndexPtv(int?kind, string reciever, int?userId, string userName, float?totalFrom, float?totalTo, DateTime?fromDate, DateTime?toDate, int?currentPageIndex)
{
if (string.IsNullOrEmpty(userName))
{
userName = string.Empty;
userId = 0;
}
var ctx = new SmsContext();
var expenses = ctx.SP_GET_EXPENSES(Convert.ToInt32(kind), reciever, userId, userName, totalFrom, totalTo, fromDate, toDate).Take(SystemConstant.MAX_ROWS).ToList <SP_GET_EXPENSES_Result>();
ExpenesModel model = new ExpenesModel();
model.Count = expenses.Count;
int pageSize = SystemConstant.ROWS;
int pageIndex = currentPageIndex == null ? 1 : (int)currentPageIndex;
model.ResultList = expenses.ToPagedList(pageIndex, pageSize);
ViewBag.Kind = kind;
ViewBag.Reciever = reciever;
ViewBag.UserId = userId;
ViewBag.UserName = userName;
ViewBag.TotalFrom = totalFrom;
ViewBag.ToTalTo = totalTo;
ViewBag.FromDate = fromDate;
ViewBag.ToDate = toDate;
ctx.Dispose();
return(PartialView("IndexPtv", model));
}
