public dtoUserAccount Get(dtoUserAccount t)
{
string hash = "";
using (MD5 md5Hash = MD5.Create())
{
hash = GetMd5Hash(md5Hash, t.passWord);
}
var sqlString = String.Format("select top 1 * from tbl_users where username = '******' and password = '******'", t.userName, hash);
t = DBContext.Database.SqlQuery<dtoUserAccount>(sqlString).FirstOrDefault();
if (t !=null)
{
sqlString = string.Format("update tbl_users set dateLastLogin = '******' where userId = {1}",DateTime.Now,t.userId );
var q = DBContext.Database.ExecuteSqlCommand(sqlString);
}
return t;
}
public JsonResult GetAllUsers()
{
var currentUser = (dtoUserAccount) Session["CurrentUser"];
var page = int.Parse(Request["page"]);
var recordPerPage = int.Parse(Request["recordPerPage"]);
var isExport = false;
var filter = new dtoUserAccount
{
userName = Request["searchUserName"],
firstName = Request["searchFirstName"],
lastName = Request["searchLastName"],
emailAddress = Request["searchEmailAddress"],
branchId = (Request["searchBranchId"] == "null" || Request["searchBranchId"] == "") ? 0 : Convert.ToInt32(Request["searchBranchId"])
};
var list = serviceUserAccount.GetAllUsers2(page, recordPerPage, filter, isExport);
//totalRecords = serviceUserAccount.GetRecordCount(filter);
//int count = list.Count();
return Json(list);
}
public dtoResult Delete(dtoUserAccount t)
{
throw new NotImplementedException();
}
public dtoResult Update(dtoUserAccount t)
{
string hash = "";
var result = new dtoResult();
try
{
using (MD5 md5Hash = MD5.Create())
{
hash = GetMd5Hash(md5Hash, t.passWord);
}
var user = DBContext.tbl_users.FirstOrDefault(d => d.userId == t.userId);
if (user != null)
{
user.userName = t.userName;
user.firstName = t.firstName;
user.middleName = t.userName;
user.lastName = t.lastName;
user.passWord = hash;
user.branchId = t.branchId;
}
DBContext.SaveChanges();
//t.userName = obj.userName;
result.isSuccessful = true;
result.returnObj = t;
}
catch (Exception ex)
{
result.isSuccessful = false;
result.errorMsg = ex.ToString();
}
return result;
}
public dtoResult Insert(dtoUserAccount t)
{
string hash = "";
using (MD5 md5Hash = MD5.Create())
{
hash= GetMd5Hash(md5Hash, t.passWord);
}
var result = new dtoResult();
try
{
var obj = new tbl_users
{
userName = t.userName,
passWord = hash,
firstName = t.firstName,
lastName = t.lastName,
middleName = t.middleName,
branchId = t.branchId,
emailAddress = t.emailAddress,
status = 1,
dateCreated = DateTime.Now
};
DBContext.tbl_users.Add(obj);
DBContext.SaveChanges();
t.userName = obj.userName;
result.isSuccessful = true;
result.returnObj = t;
}
catch (Exception ex)
{
result.isSuccessful = false;
result.errorMsg = ex.ToString();
}
return result;
}
public ActionResult GetAllUsers_old(jQueryDataTableParamModel param)
{
var filter = new dtoUserAccount
{
userId = Request["userId"] == "" ? 0 : Convert.ToInt32( Request["userId"]),
firstName = Request["firstname"],
lastName = Request["lastname"],
emailAddress = Request["emailAddress"],
userName = Request["userName"],
branchId = Request["branchId"] == "" ? 0 : Convert.ToInt32(Request["branchId"])
};
var list = serviceUserAccount.GetAllUsers(param.sSearch ?? "", filter);
int count = list.Count();
return Json(new
{
param.sEcho,
iTotalRecords = count,
iTotalDisplayRecords = 10,
aaData = list
}
, JsonRequestBehavior.AllowGet);
}
public JsonResult AddEditUser(dtoUserAccount user)
{
var result = user.userId == 0 ? serviceUserAccount.Register(user) : serviceUserAccount.Update(user);
return Json(result);
}
public JsonResult LoginUser(dtoUserAccount user)
{
var result = serviceUserAccount.ValidateCredentials(user);
var resultObject = (dtoUserAccount) result.returnObj;
if (result.isSuccessful)
{
FormsAuthentication.SetAuthCookie(resultObject.userName, false);
Session["CurrentUser"] = resultObject;
}
return Json(result);
}
