public ActionResult ChangePass(Admin_Account md, string OldPassWord)
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
Admin_Account CheckUser = Admin_Account.SingleOrDefault("Where Id=@0 AND UserName=@1 AND PasswordHash=@2 AND Status=1",
md.Id, md.UserName, WebsiteExtension.EncryptPassword(OldPassWord));
if (CheckUser != null)
{
try
{
CheckUser.PasswordHash = convertPass;
CheckUser.UpdatedDate = DateTime.Now;
CheckUser.UpdatedStaffId = Convert.ToInt32(Session["UserID"]);
CheckUser.Save();
return(Redirect("/Login/Login"));
}
catch
{
return(View());
}
}
return(View());
}
public JsonResult Create_Account(Admin_Account obj)
{
Admin_Account Acc = new Admin_Account();
try
{
if (!string.IsNullOrEmpty(obj.PasswordHash))
{
Acc.PasswordHash = WebsiteExtension.EncryptPassword(obj.PasswordHash);
}
Acc.BranchId = Constants.Branch;
Acc.UserName = obj.UserName;
Acc.FullName = obj.FullName;
Acc.TypeId = obj.TypeId;
Acc.Mobile = obj.Mobile;
Acc.Email = obj.Email;
Acc.Address = obj.Address;
Acc.CreatedDate = DateTime.Now;
Acc.Status = 1;
Acc.Active = 1;
Acc.Save();
}
catch (Exception ex)
{
return(Json(0));
}
return(Json(new { Result = 1, Records = Acc }));
}
public JsonResult Update_Account(Admin_Account obj)
{
List <Admin_Account> Acc = Admin_Account.Query("Where Id=@0", obj.Id).ToList();
try
{
if (Acc.Any())
{
if (!string.IsNullOrEmpty(obj.PasswordHash))
{
Acc.FirstOrDefault().PasswordHash = WebsiteExtension.EncryptPassword(obj.PasswordHash);
}
Acc.FirstOrDefault().UserName = obj.UserName;
Acc.FirstOrDefault().FullName = obj.FullName;
Acc.FirstOrDefault().TypeId = obj.TypeId;
Acc.FirstOrDefault().Mobile = obj.Mobile;
Acc.FirstOrDefault().Email = obj.Email;
Acc.FirstOrDefault().Address = obj.Address;
Acc.SingleOrDefault().UpdatedDate = DateTime.Now;
Acc.FirstOrDefault().Save();
}
}
catch (Exception ex)
{
return(Json(0));
}
return(Json(new { Result = 1, Records = Acc }));
}
public ActionResult Login(tbl_Admin_UserAuth md)
{
var error = String.Empty;
if (md.UserName != null || md.UserName != "")
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
try
{
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var objCheckExist = new GCRequest
{
_a = "fGettbl_Admin_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserName", md.UserName },
{ "PasswordHash", convertPass },
{ "Status", 1 }
},
_f = "Id,TypeId,UserName,GroupTypeId"
};
var robjCheckExist = service.P(objCheckExist);
if (robjCheckExist.TotalRecordCount > 0)
{
Session["UserID"] = robjCheckExist.Records[0][0].ToString();
Session["RoleId"] = robjCheckExist.Records[0][1].ToString();
Session["UserName"] = robjCheckExist.Records[0][2].ToString();
Session["GroupId"] = robjCheckExist.Records[0][3].ToString();
Session.Timeout = 120;
return(Redirect("/"));
}
else
{
return(Redirect("/Login/Login"));
}
}
catch (Exception ex)
{
return(Redirect("/Login/Login"));
}
}
else
{
return(Redirect("/Login/Login"));
}
}
public async Task <bool> Put(AccountDto model)
{
var result = false;
if (ModelState.IsValid)
{
var dateTimeUtcNow = DateTime.Now;
if (!string.IsNullOrEmpty(model.PasswordHash))
{
model.PasswordHash = WebsiteExtension.EncryptPassword(model.PasswordHash);
}
model.UpdatedStaffId = _authenticationDto.UserId;
model.UpdatedDate = dateTimeUtcNow;
result = await _adminAccountBusiness.Update(model);
}
return(result);
}
public ActionResult ChangePass(tbl_Admin_UserAuth md, string OldPassWord)
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var objCheckPass = new GCRequest
{
_a = "fGettbl_Admin_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "UserName", md.UserName },
{ "PasswordHash", WebsiteExtension.EncryptPassword(OldPassWord) },
{ "Status", 1 }
},
_f = "Id"
};
var robjCheckPass = service.P(objCheckPass);
if (robjCheckPass.TotalRecordCount > 0)
{
var obj = new GCRequest
{
_a = "Updatetbl_Admin_UserAuth", //Action prefix f,p for get data; gc_App is table name
_c = new Dictionary <string, object>
{
{ "Id", md.Id }
},
_d = new Dictionary <string, object>
{
{ "PasswordHash", convertPass },
{ "ModifiedDate", DateTime.Now }
}
};
var robj = service.P(obj);
if (robj.Result == 1)
{
return(Redirect("/Login/Login"));
}
}
return(View());
}
public ActionResult CreateAccount(tbl_UserAuth md)
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
//var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); //isDebug = true -> show error message in response object, uid is logged user id
var obj = new GCRequest
{
_a = "Inserttbl_UserAuth", //Action prefix f,p for get data; gc_App is table name
_d = new Dictionary <string, object>
{
{ "TypeId", md.TypeId },
{ "UserName", md.UserName.ToLower() },
{ "PasswordHash", convertPass },
{ "StaffId", md.StaffId },
{ "Status", 1 },
{ "CreatedDate", DateTime.Now }
}
};
var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content }
ViewBag.result = robj.Result;
ViewBag.type = md.TypeId;
return(View(robj.Records[0][0]));
}
public async Task <int> Post(AdminAccount model)
{
string user = _appSetting.GetValue <string>("AppSettings:EmailAuthentication:UserName");
string password = _appSetting.GetValue <string>("AppSettings:EmailAuthentication:Password");
string activeUrl = _appSetting.GetValue <string>("AppSettings:ActiveUrl");
//restaurant owner create account
if (_authenticationDto.RestaurantId > 0)
{
model.RestaurantId = _authenticationDto.RestaurantId;
}
var result = 0;
if (ModelState.IsValid)
{
var dateTimeUtcNow = DateTime.Now;
model.PasswordHash = WebsiteExtension.EncryptPassword(model.PasswordHash);
model.CreatedStaffId = _authenticationDto.UserId;
model.CreatedDate = dateTimeUtcNow;
model.Status = 1;
model.Active = 0;
//recheck eamil and username is existed
if (!await _adminAccountBusiness.CheckEmailExist(model.Email) ||
!await _adminAccountBusiness.CheckUserNameExist(model.UserName))
{
return(result);
}
var modelInsert = await _adminAccountBusiness.Add(model);
result = modelInsert.Id;
if (result > 0)
{
await _emailBusiness.SendEmailToActiveAccount(modelInsert, user, password, activeUrl);
}
}
return(result);
}
public async Task <int> Post(Entities.Models.Restaurant model)
{
string user = _appSetting.GetValue <string>("AppSettings:EmailAuthentication:UserName");
string password = _appSetting.GetValue <string>("AppSettings:EmailAuthentication:Password");
string activeUrl = _appSetting.GetValue <string>("AppSettings:ActiveUrl");
var result = 0;
if (ModelState.IsValid)
{
model.Status = 1;
var modelInsert = await _restaurantBusiness.Add(model);
result = modelInsert.Id;
if (result > 0)
{
var dateTimeUtcNow = DateTime.Now;
var accountModel = new AdminAccount
{
UserName = WebsiteExtension.Slug(modelInsert.Name),
RestaurantId = modelInsert.Id,
Email = modelInsert.Email,
PasswordHash = WebsiteExtension.EncryptPassword(WebsiteExtension.Slug(modelInsert.Name) + "123"),
CreatedStaffId = _authenticationDto.UserId,
CreatedDate = dateTimeUtcNow,
Status = 1,
Active = 0
};
var accountInsert = await _adminAccountBusiness.Add(accountModel);
if (accountInsert.Id > 0)
{
await _emailBusiness.SendEmailToRestaurantAdmin(accountInsert, user, password, activeUrl);
}
}
}
return(result);
}
public ActionResult Login(Admin_Account md)
{
var error = String.Empty;
if (md.UserName != null || md.UserName != "")
{
var convertPass = WebsiteExtension.EncryptPassword(md.PasswordHash);
try
{
List <Admin_Account> CheckUser = Admin_Account.Query("Where UserName=@0 AND PasswordHash=@1 AND BranchId=@2 AND Status=1",
md.UserName, convertPass, 1).ToList();
if (CheckUser.Count > 0 && CheckUser.Count < 2)
{
Session["UserID"] = CheckUser.FirstOrDefault().Id.ToString();
Session["TypeId"] = CheckUser.FirstOrDefault().TypeId.ToString();
Session["UserName"] = CheckUser.FirstOrDefault().UserName.ToString();
Session["BranchId"] = CheckUser.FirstOrDefault().BranchId.ToString();
Session.Timeout = 120;
return(Redirect("/"));
}
else
{
return(Redirect("/Login/Login"));
}
}
catch (Exception ex)
{
return(Redirect("/Login/Login"));
}
}
else
{
return(Redirect("/Login/Login"));
}
}
public async Task <LoginResponse> Login(LoginDto model)
{
model.Password = WebsiteExtension.EncryptPassword(model.Password);
return(await _adminAccountBusiness.Login(model));
}
