public long UpdateUser(UserAccountModel model)
{
long res = 0;
// Declare new DataAccess object
ManageUserDa dataAccess = new ManageUserDa();
using (var transaction = new TransactionScope())
{
TblUserAccount entity = new TblUserAccount();
entity.USER_ID = model.USER_ID = model.USER_ID_HIDDEN;
entity.USER_NAME = model.USER_NAME;
entity.SHOP_NAME = model.SHOP_NAME;
entity.AREA = model.AREA;
entity.USER_AUTHORITY = model.USER_AUTHORITY;
entity.USER_CITY = model.USER_CITY;
entity.USER_DISTRICT = model.USER_DISTRICT;
entity.USER_TOWN = model.USER_TOWN;
entity.USER_ADDRESS = model.USER_ADDRESS;
entity.USER_PHONE = model.USER_PHONE;
entity.LOGIN_LOCK_FLG = model.LOGIN_LOCK_FLG;
entity.DEL_FLG = DeleteFlag.NON_DELETE;
entity.STATUS = model.STATUS;
entity.INS_DATE = Utility.GetCurrentDateTime();
entity.PASSWORD_LAST_UPDATE_DATE = Utility.GetCurrentDateTime();
entity.UPD_DATE = Utility.GetCurrentDateTime();
res = dataAccess.UpdateUser(entity);
if (res <= 0)
{
transaction.Dispose();
}
transaction.Complete();
}
return(res);
}
public ActionResult ResetPassword(UserAccountModel model)
{
if (ModelState.IsValid)
{
using (UserAccountService service = new UserAccountService())
{
ManageUserDa dataAccess = new ManageUserDa();
var UserId = dataAccess.selectUserId(model.USER_EMAIL);
if (UserId > 0)
{
var suscess = dataAccess.ReSetPassword(UserId);
sendMailResetPassword(model.USER_EMAIL);
if (suscess > 0)
{
ViewBag.sendMailSuccess = "Yêu cầu reset mật khẩu của bạn đã được gửi tới email:" + model.USER_EMAIL;
}
return(this.View());
}
}
}
{
var errors = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(View());
}
public IEnumerable <TblUserAccountEx> SearchUserList(DataTableModel dt, UserAccountModel model, out int total_row)
{
ManageUserDa dataAccess = new ManageUserDa();
IEnumerable <TblUserAccountEx> results = dataAccess.SearchUserList(dt, model, out total_row);
return(results);
}
public bool DeleteUser(long USER_ID = 0)
{
ManageUserDa dataAccess = new ManageUserDa();
int result = 0;
using (var transaction = new TransactionScope())
{
try
{
result = dataAccess.DeleteUser(USER_ID);
if (result > 0)
{
transaction.Complete();
}
}
catch (Exception ex)
{
transaction.Dispose();
result = -1;
throw new Exception(ex.Message, ex);
}
finally
{
transaction.Dispose();
}
}
return(result > 0);
}
// check exist user
public ActionResult CheckExistUserAccount(string userAccount)
{
// Declare new DataAccess object
ManageUserDa dataAccess = new ManageUserDa();
var exist = dataAccess.CheckExistUserAccount(userAccount);
return(new EmptyResult());
}
public ActionResult UserEdit(long UserId = 0)
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
var authorityList = currentUser != null ? currentUser.USER_AUTHORITY : 0;
if (currentUser == null || authorityList != 2)
{
return(RedirectToAction("Login", "UserAccount"));
}
UserAccountModel model = new UserAccountModel();
CommonService comService = new CommonService();
ManageUserDa dataAccess = new ManageUserDa();
if (UserId > 0)
{
UserAccountModel infor = new UserAccountModel();
infor = dataAccess.getInfoUser(UserId);
model = infor != null ? infor : model;
model.DISTRICT_CD_KEY = model.USER_CITY.ToString() + "_" + model.USER_DISTRICT.ToString();
model.TOWN_CD_KEY = model.USER_CITY.ToString() + "_" + model.USER_DISTRICT.ToString() + "_" + model.USER_TOWN.ToString();
}
model.CITY_LIST = comService.GetCityList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString(),
Text = f.CITY_NAME
}).ToList();
model.CITY_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = ""
});
model.DISTRICT_LIST = comService.GetDistrictList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString() + "_" + f.DISTRICT_CD.ToString(),
Text = f.DISTRICT_NAME
}).ToList();
model.TOWN_LIST = comService.GetTownList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString() + "_" + f.DISTRICT_CD.ToString() + "_" + f.TOWN_CD.ToString(),
Text = f.TOWN_NAME
}).ToList();
ViewBag.UserAuthority = new SelectList(UtilityServices.UtilityServices.GetAuthorityUser(), "Value", "Text");
return(View(model));
}
public ActionResult UserList()
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
var authorityList = currentUser != null ? currentUser.USER_AUTHORITY : 0;
if (currentUser == null || authorityList != 2)
{
return(RedirectToAction("Login", "UserAccount"));
}
UserAccountModel model = new UserAccountModel();
CommonService comService = new CommonService();
ManageUserDa dataAccess = new ManageUserDa();
var tmpCondition = GetRestoreData() as UserAccountModel;
if (tmpCondition != null)
{
model = tmpCondition;
}
model.CITY_LIST = comService.GetCityList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString(),
Text = f.CITY_NAME
}).ToList();
model.CITY_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = ""
});
model.DISTRICT_LIST = comService.GetDistrictList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString() + "_" + f.DISTRICT_CD.ToString(),
Text = f.DISTRICT_NAME
}).ToList();
model.TOWN_LIST = comService.GetTownList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString() + "_" + f.DISTRICT_CD.ToString() + "_" + f.TOWN_CD.ToString(),
Text = f.TOWN_NAME
}).ToList();
ViewBag.UserAuthority = new SelectList(UtilityServices.UtilityServices.GetAuthorityUser(), "Value", "Text");
return(View(model));
}
public ActionResult Register(long UserId = 0)
{
UserAccountModel model = new UserAccountModel();
CommonService comService = new CommonService();
ManageUserDa dataAccess = new ManageUserDa();
if (UserId > 0)
{
UserAccountModel infor = new UserAccountModel();
infor = dataAccess.getInfoUser(UserId);
model = infor != null ? infor : model;
model.DISTRICT_CD_KEY = model.USER_CITY.ToString() + "_" + model.USER_DISTRICT.ToString();
model.TOWN_CD_KEY = model.USER_CITY.ToString() + "_" + model.USER_DISTRICT.ToString() + "_" + model.USER_TOWN.ToString();
}
model.CITY_LIST = comService.GetCityList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString(),
Text = f.CITY_NAME
}).ToList();
model.CITY_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = "Tỉnh/thành phố"
});
model.DISTRICT_LIST = comService.GetDistrictList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString() + "_" + f.DISTRICT_CD.ToString(),
Text = f.DISTRICT_NAME
}).ToList();
model.DISTRICT_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = "Quận/huyện"
});
model.TOWN_LIST = comService.GetTownList().ToList().Select(
f => new SelectListItem
{
Value = f.CITY_CD.ToString() + "_" + f.DISTRICT_CD.ToString() + "_" + f.TOWN_CD.ToString(),
Text = f.TOWN_NAME
}).ToList();
model.TOWN_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = "Xã/phường"
});
return(View(model));
}
// check exist user
public ActionResult CheckExistUserAccount(string userEmail)
{
if (Request.IsAjaxRequest())
{
// Declare new DataAccess object
ManageUserDa dataAccess = new ManageUserDa();
var exist = dataAccess.CheckExistUserAccount(userEmail);
JsonResult result = Json(new
{
exist
}, JsonRequestBehavior.AllowGet);
return(result);
}
return(new EmptyResult());
}
public ActionResult ChangePassword(long UserId = 0)
{
UserAccountModel model = new UserAccountModel();
CommonService comService = new CommonService();
ManageUserDa dataAccess = new ManageUserDa();
if (UserId > 0)
{
UserAccountModel infor = new UserAccountModel();
infor = dataAccess.getInfoUser(UserId);
model = infor != null ? infor : model;
}
return(View(model));
}
// check exist user
public ActionResult ConfirmResetPassword(string UserEmail)
{
// Declare new DataAccess object
ManageUserDa dataAccess = new ManageUserDa();
var UserId = dataAccess.selectUserId(UserEmail);
if (UserId > 0)
{
var suscess = dataAccess.ConfirmEmail(UserId);
if (suscess)
{
return(this.RedirectToAction("Login", "UserAccount"));
}
}
return(new EmptyResult());
}
public long InsertUser(UserAccountModel model)
{
long res = 0;
// Declare new DataAccess object
ManageUserDa dataAccess = new ManageUserDa();
using (var transaction = new TransactionScope())
{
TblUserAccount entity = new TblUserAccount();
entity.USER_EMAIL = model.USER_EMAIL;
entity.EMAIL_CONFIRMED = EmailConfirmed.None;
entity.USER_NAME = model.USER_NAME;
entity.SHOP_NAME = model.SHOP_NAME;
entity.USER_PASSWORD = SafePassword.GetSaltedPassword(model.USER_PASSWORD);
entity.PASSWORD_LAST_UPDATE_DATE = Utility.GetCurrentDateTime();
entity.USER_AUTHORITY = model.USER_AUTHORITY;
entity.AREA = model.AREA;
entity.USER_CITY = model.USER_CITY;
entity.USER_DISTRICT = model.USER_DISTRICT;
entity.USER_TOWN = model.USER_TOWN;
entity.USER_ADDRESS = model.USER_ADDRESS;
entity.USER_PHONE = model.USER_PHONE;
entity.USER_FAMILY = 0;
entity.LOGIN_LOCK_FLG = LockFlag.NON_LOCK;
entity.GENDER = true;
entity.DEL_FLG = DeleteFlag.NON_DELETE;
entity.STATUS = model.STATUS;
entity.INS_DATE = Utility.GetCurrentDateTime();
entity.UPD_DATE = Utility.GetCurrentDateTime();
res = dataAccess.InsertUser(entity);
if (res <= 0)
{
transaction.Dispose();
}
transaction.Complete();
}
return(res);
}
