public ActionResult Update(Merchant_Info item, HttpPostedFileBase file)
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["update"]))
{
string rs = new Merchant_Info_DAO().Update(item, currentUser.name, AppConfigs.MCCConnectionString);
if (rs == "true")
{
using (var dbConn = MCC.Helpers.OrmliteConnection.openConn())
{
if (file != null)
{
item.logo_gian_hang = new Helpers.ProcessImage().UploadImageToFolder(string.Empty, file, item.ma_gian_hang, currentUser.name);
dbConn.UpdateOnly(item,
onlyFields: p =>
new
{
p.logo_gian_hang,
},
where : p => p.id == item.id);
}
var data = dbConn.FirstOrDefault <Merchant_Info>("ma_gian_hang={0}".Params(item.ma_gian_hang));
return(Json(new { success = true, data = data }));
}
}
return(Json(new { success = false, message = rs, JsonRequestBehavior.AllowGet }));
}
return(RedirectToAction("NoAccess", "Error"));
}
public string GetAll(string key)
{
try
{
if (AllConstant.KeyAPI == key)
{
DataTable dt = new Merchant_Info_DAO().ReadAll(AllConstant.ERPConnectionString);
string st = JsonConvert.SerializeObject(dt);
return(st);
}
return("");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public ActionResult Create(Merchant_Info item, HttpPostedFileBase file)
{
if (asset.Create || asset.Update)
{
string result = "";
try
{
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var refix = "Merchant_Info_" + currentUser.UserName + "_" + DateTime.Now.ToString("yyyyMMddHHmmss");
Helpers.UploadFile.CreateFolder(Server.MapPath("~/Images/Merchant_Info/"));
var path = Path.Combine(Server.MapPath("~/Images/Merchant_Info/"), refix + Path.GetExtension(fileName));
file.SaveAs(path);
item.logo_gian_hang = refix + Path.GetExtension(fileName);
}
List <Merchant_Info> lstMerchantInfo = new List <Merchant_Info>();
lstMerchantInfo.Add(item);
result = new Merchant_Info_DAO().UpSert(lstMerchantInfo, currentUser.UserName, "Insert");
if (result == "true")
{
if (item.id == 0)// 0 insert, 1 update
{
return(Json(new { success = true, type = 0 }));
}
else
{
return(Json(new { success = true, type = 1 }));
}
}
else
{
return(Json(new { success = false, message = result }));
}
}
catch (Exception e)
{
return(Json(new { success = false, message = "Có lỗi file upload" + e.Message }));
}
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền." }));
}
}
public ActionResult Register(Merchant_Info model)
{
ModelState.Clear();
if (currentUser != null)
{
if (!String.IsNullOrEmpty(currentUser.ma_gian_hang))
{
return(Json(new { success = true, JsonRequestBehavior.AllowGet }));
}
}
using (var dbConn = Helpers.OrmliteConnection.openConn(AppConfigs.MCCConnectionString))
{
//dbConn.ChangeDatabase(AllConstant.ERPDBName);
var data = dbConn.SingleOrDefault <Merchant_Info>("email={0}", model.email);
if (data == null)
{
List <Merchant_Info> listMerchant = new List <Merchant_Info>();
listMerchant.Add(model);
var result = new Merchant_Info_DAO().UpSert(listMerchant, currentUser.name, AppConfigs.MCCConnectionString);
if (result == "true")
{
data = dbConn.SingleOrDefault <Merchant_Info>("email={0}", model.email);
currentUser.ma_gian_hang = data.ma_gian_hang;
//dbConn.ChangeDatabase(AllConstant.MCCDBName);
dbConn.UpdateOnly(currentUser,
onlyFields: p =>
new
{
p.ma_gian_hang
},
where : p => p.id == currentUser.id);
return(Json(new { success = true, JsonRequestBehavior.AllowGet }));
}
else
{
return(Json(new { success = false, message = "Tạo gian hàng thất bại", data, JsonRequestBehavior.AllowGet }));
}
}
else
{
return(Json(new { success = false, email = Resources.Global._email_exist, data, JsonRequestBehavior.AllowGet }));
}
}
}
public ActionResult ApprovalMerchant(string data)
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["update"]))
{
string[] separators = { "," };
string[] ids = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
if (ids.Length == 0)
{
return(Json(new { success = false, message = "Chọn gian hàng cần xét duyệt!" }));
}
string st = new Merchant_Info_DAO().ChangeStatusApproval(ids, AppConfigs.MCCConnectionString, currentUser.name);
if (st == "true")
{
return(Json(new { success = true, message = "Thành công!" }));
}
else
{
ModelState.AddModelError("", st);
}
}
return(Json(new { success = false, message = "Xét duyệt không thành công! " }));
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
int count = 0;
var existEmail = dbConn.SingleOrDefault <tw_User>("email={0}", model.Email);
var existShopName = dbConn.SingleOrDefault <Merchant_Info>("ten_gian_hang={0}", model.ten_gian_hang);
var existUrl = dbConn.SingleOrDefault <Merchant_Info>("website={0}", model.website);
if (existEmail != null)
{
ModelState.AddModelError("", Resources.Global._email_exited);
count++;
}
if (existShopName != null)
{
ModelState.AddModelError("", Resources.Global._shop_name_exsited);
count++;
}
if (existUrl != null)
{
ModelState.AddModelError("", Resources.Global._url_is_exsited);
count++;
}
if (count == 0)
{
var user = new ApplicationUser()
{
UserName = model.UserName, PhoneNumber = model.PhoneNumber, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
// ADD USER
var newUser = new tw_User();
newUser.name = model.UserName;
newUser.email = model.Email;
newUser.phone = model.PhoneNumber;
newUser.fullName = model.FullName;
newUser.registerAt = DateTime.Now;
newUser.homePage = "Home";
newUser.active = false;
newUser.vendorAuth = "";
newUser.userKey = user.Id;
//newUser.ma_gian_hang= dbConn.QueryScalar<string>("select MAX(ma_gian_hang) from Merchant_Info");
newUser.createdAt = DateTime.Now;
newUser.createdBy = "system";
dbConn.Insert(newUser);
// ADD MERCHANT_INFO
Merchant_Info merchantinfo = new Merchant_Info();
merchantinfo.ten_gian_hang = model.ten_gian_hang;
merchantinfo.website = model.website;
//List<Merchant_Info> lstMerchant = new List<Merchant_Info>();
//lstMerchant.Add(merchantinfo);
Merchant_Info_DAO merchantDao = new Merchant_Info_DAO();
merchantDao.CreateMerchant(merchantinfo, model.UserName, AppConfigs.MCCConnectionString);
// ADD USERGROUP
Int64 userId = (Int64)dbConn.GetLastInsertId();
var groupId = dbConn.Scalar <Int64>("select id from tw_UserGroup where name = 'MerchantAdmin'");
if (groupId > 0)
{
var userInGroup = new tw_UserInGroup();
userInGroup.userId = userId;
userInGroup.groupId = groupId;
userInGroup.createdAt = DateTime.Now;
userInGroup.createdBy = "system";
dbConn.Insert(userInGroup);
}
// ADD USERACTIVATION
string code = Guid.NewGuid().ToString();;
UserActivation userActiv = new UserActivation();
userActiv.UserName = model.UserName;
userActiv.Email = model.Email;
userActiv.MerchantName = model.ten_gian_hang;
userActiv.FullName = model.FullName;
userActiv.Phone = model.PhoneNumber;
userActiv.ActivationCode = code;
userActiv.Date = DateTime.Now;
userActiv.DeadTime = DateTime.Now.AddDays(3);// sau 3 ngay link active vo hieu luc
userActiv.ngay_tao = DateTime.Now;
userActiv.nguoi_tao = "system";
userActiv.ngay_cap_nhat = DateTime.Now;
userActiv.nguoi_cap_nhat = "system";
dbConn.Insert(userActiv);
//SEND MAIL
string body = string.Empty;
using (StreamReader reader = new StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/EmailTemplate/newUserTemplate.html")))
{
body = reader.ReadToEnd();
}
body = body.Replace("{username}", model.UserName);
body = body.Replace("{fullname}", model.FullName);
body = body.Replace("{phone}", model.PhoneNumber);
body = body.Replace("{email}", model.Email);
//xác thực bằng web
body = body.Replace("{activation}", AppConfigs.Url + "/Account/Activation?key=" + code + "&email=" + model.Email + "&username="******"&ten_gian_hang=" + model.ten_gian_hang);
//xác thực thông qua API
//body = body.Replace("{activation}", AllConstant.UrlAPI + "api/ActivationAccount/Activation?key=" + code + "&email=" + model.Email + "&username="******"&ten_gian_hang=" + model.ten_gian_hang);
BackgroundJob.Enqueue(() => new Helpers.SendMail().Send(model.Email, "", "Xin hoàn thành thủ tục đăng ký trên Thietbinhanh.com!", body, ""));
// new Helpers.SendMail().Send(model.Email, "", "Xin hoàn thành thủ tục đăng ký trên Thietbinhanh.com!", body, "");
//await SignInAsync(user, isPersistent: false);
return(View("~/Views/Account/Success.cshtml"));
}
else
{
AddErrors(result);
}
}
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
