public MessageReport DeleteById(int id, ref tblSubCard obj)
{
var re = new MessageReport();
re.Message = "Error";
re.isSuccess = false;
try
{
obj = GetById(id);
if (obj != null)
{
obj.IsDelete = true;
_tblSubCardRepository.Update(obj);
Save();
re.Message = FunctionHelper.GetLocalizeDictionary("Home", "notification")["DeleteSuccess"];
re.isSuccess = true;
}
else
{
re.Message = FunctionHelper.GetLocalizeDictionary("Home", "notification")["record_does_not_exist"];
re.isSuccess = false;
}
}
catch (Exception ex)
{
re.Message = ex.Message;
re.isSuccess = false;
}
return(re);
}
public JsonResult Delete(string id)
{
var obj = new tblSubCard();
var result = _tblSubCardService.DeleteById(Convert.ToInt32(id), ref obj);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public MessageReport Create(tblSubCard obj)
{
var re = new MessageReport();
re.Message = "Error";
re.isSuccess = false;
try
{
_tblSubCardRepository.Add(obj);
Save();
re.Message = FunctionHelper.GetLocalizeDictionary("Home", "notification")["addSuccess"];;
re.isSuccess = true;
}
catch (Exception ex)
{
re.Message = ex.Message;
re.isSuccess = false;
}
return(re);
}
public JsonResult ImportFile()
{
//
var userCard = GetCurrentUser.GetUser();
var fileUpload = "";
try
{
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var txtError = "";
var name = Common.UploadFileWithDatetime(out txtError, Server.MapPath("~/upload/files/import/"), file);
var path = Path.Combine(Server.MapPath("~/upload/files/import/"), name);
fileUpload = name;
if (System.IO.File.Exists(path))
{
var dt = FunctionHelper.ReadFromExcelCardCustomer(path, ref txtError);
if (!string.IsNullOrWhiteSpace(txtError))
{
var result = new MessageReport();
result.Message = txtError;
result.isSuccess = false;
return(Json(result, JsonRequestBehavior.AllowGet));
}
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
//////Lấy dữ liệu từ file
var stt = item["STT"].ToString().Trim();
//Kiểm tra chỉ khi có STT thì mới thực hiện
if (!string.IsNullOrWhiteSpace(stt))
{
//Thẻ
var cardno = item["CardNo"].ToString().Trim();
var cardnumber = item["Mã thẻ"].ToString().Trim();
var maincard = item["Mã thẻ chính"].ToString().Trim();
if (!string.IsNullOrEmpty(cardnumber) && !string.IsNullOrEmpty(maincard))
{
var objSubCard = _tblSubCardService.GetByCard("", cardnumber);
if (objSubCard != null)
{
objSubCard.CardNo = cardno;
objSubCard.CardNumber = cardnumber;
objSubCard.MainCard = maincard;
_tblSubCardService.Update(objSubCard);
}
else
{
objSubCard = new tblSubCard()
{
CardNo = cardno,
CardNumber = cardnumber,
MainCard = maincard,
IsDelete = false
};
_tblSubCardService.Create(objSubCard);
}
}
}
}
}
}
}
}
var resultUp1 = new MessageReport();
resultUp1.isSuccess = true;
resultUp1.Message = "Upload excel thành công";
//////Lưu log sự kiện
WriteLog.Write(resultUp1, userCard, fileUpload, fileUpload, "tblSubCard", ConstField.ParkingCode, ActionConfigO.ImportExcel);
return(Json(resultUp1, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var resultUp3 = new MessageReport();
resultUp3.isSuccess = false;
resultUp3.Message = ex.Message;
return(Json(resultUp3, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Update(tblSubCard obj, string id)
{
var DictionaryAction = FunctionHelper.GetLocalizeDictionary("Home", "notification");
ViewBag.Url = url;
//Kiểm tra
var oldObj = _tblSubCardService.GetById(!string.IsNullOrEmpty(id) ? Convert.ToInt32(id) : 0);
if (oldObj == null)
{
ViewBag.Error = DictionaryAction["record_does_not_exist"];
return(View(obj));
}
if (!ModelState.IsValid)
{
return(View(oldObj));
}
if (string.IsNullOrEmpty(obj.MainCard))
{
ModelState.AddModelError("MainCard", DictionaryAction["enter_MainCard_name"]);
return(View(oldObj));
}
if (string.IsNullOrEmpty(obj.CardNumber))
{
ModelState.AddModelError("CardNumber", DictionaryAction["Please_enter_the_Card_Number"]);
return(View(oldObj));
}
var cgroup = _tblSubCardService.GetByCard("", obj.CardNumber);
if (cgroup != null && !cgroup.ID.ToString().Equals(id))
{
ModelState.AddModelError("CardNumber", DictionaryAction["Card_code_already_exists"]);
return(View(oldObj));
}
//Gán giá trị
oldObj.MainCard = !string.IsNullOrEmpty(obj.MainCard) ? obj.MainCard.Trim() : "";
oldObj.CardNumber = !string.IsNullOrEmpty(obj.CardNumber) ? obj.CardNumber.Trim() : "";
oldObj.CardNo = !string.IsNullOrEmpty(obj.CardNo) ? obj.CardNo.Trim() : "";
//Thực hiện cập nhật
var result = _tblSubCardService.Update(oldObj);
if (result.isSuccess)
{
objId = oldObj.ID.ToString();
if (!string.IsNullOrEmpty(url))
{
return(Redirect(url));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("", result.Message);
return(View(obj));
}
}
public ActionResult Create(tblSubCard obj, bool SaveAndCountinue = false)
{
var DictionaryAction = FunctionHelper.GetLocalizeDictionary("Home", "notification");
//Danh sách sử dụng
ViewBag.Url = url;
//Kiểm tra
if (!ModelState.IsValid)
{
return(View(obj));
}
if (string.IsNullOrEmpty(obj.MainCard))
{
ModelState.AddModelError("MainCard", DictionaryAction["enter_MainCard_name"]);
return(View(obj));
}
if (string.IsNullOrEmpty(obj.CardNumber))
{
ModelState.AddModelError("CardNumber", DictionaryAction["Please_enter_the_Card_Number"]);
return(View(obj));
}
var cgroup = _tblSubCardService.GetByCard("", obj.CardNumber);
if (cgroup != null)
{
ModelState.AddModelError("CardNumber", DictionaryAction["Card_code_already_exists"]);
return(View(obj));
}
//Gán giá trị
obj.IsDelete = false;
obj.MainCard = !string.IsNullOrEmpty(obj.MainCard) ? obj.MainCard.Trim() : "";
obj.CardNumber = !string.IsNullOrEmpty(obj.CardNumber) ? obj.CardNumber.Trim() : "";
obj.CardNo = !string.IsNullOrEmpty(obj.CardNo) ? obj.CardNo.Trim() : "";
//Thực hiện thêm mới
var result = _tblSubCardService.Create(obj);
if (result.isSuccess)
{
if (SaveAndCountinue)
{
TempData["Success"] = result.Message;
return(RedirectToAction("Create"));
}
if (!string.IsNullOrEmpty(url))
{
return(Redirect(url));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("", result.Message);
return(View(obj));
}
}
