public static ResponseModel UpdateUser(UserIfo model)
{
ResponseModel response = new ResponseModel();
try
{
List <string> lgp_fields = new List <string>()
{
"Code", "Description1", "Description2"
};
List <string> skp_fields = new List <string>()
{
"Number"
};
PrepSQL.ErpUpdateData("Units", model, model.UserNr, "UserNr", lgp_fields, skp_fields);
response.status = 1;
response.msg = "Success";
}
catch (Exception ex)
{
response.status = 0;
response.msg = ex.Message;
}
return(response);
}
public static void SetCookie(bool isPersistent, UserIfo usrdata)
{
DateTime dateExpire = isPersistent == true?DateTime.Now.AddDays(10) : DateTime.Now.AddMinutes(30);
JavaScriptSerializer serializer = new JavaScriptSerializer();
string userData = serializer.Serialize(usrdata);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1,
usrdata.UserName,
DateTime.Now,
dateExpire,
isPersistent,
userData, FormsAuthentication.FormsCookiePath);
string encTicket = FormsAuthentication.Encrypt(authTicket);
HttpCookie userCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket);
userCookie.Path = FormsAuthentication.FormsCookiePath;
FormsAuthentication.SetAuthCookie(usrdata.UserName, isPersistent);
userCookie.Expires = dateExpire;
HttpContext.Current.Response.Cookies.Add(userCookie);
}
public static ResponseModel SaveUser(UserIfo model)
{
int id = 0;
model.DateEntered = DateTime.Now;
model.DateModified = DateTime.Now;
ResponseModel response = new ResponseModel();
try
{
List <string> lgp_fields = new List <string>()
{
"UserName", "UserPaswr", "EmployeeNumber", "FName", "MIName", "LName", "UserAccount", "UserInactive", "EnteredBy", "DateEntered", "ModifiedBy", "DateModified", "AccessRights", "Branch", "loginStatus", "IsAllow"
};
List <string> skp_fields = new List <string>()
{
"UserNr"
};
id = PrepSQL.ErpInsertData("User", model, lgp_fields, skp_fields);
response.status = 1;
response.msg = "Success";
}
catch (Exception ex)
{
response.status = 0;
response.msg = ex.Message;
}
return(response);
}
public JsonResult Create(UserIfo usr)
{
if (usr.UserNr == 0)
{
ResponseModel model = InvUserData.SaveUser(usr);
if (model.status == 1)
{
return(Json(new { status = true, msg = "Successfuly saved." }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, msg = "Someething went wrong." }, JsonRequestBehavior.AllowGet));
}
}
else
{
ResponseModel model = InvUserData.UpdateUser(usr);
if (model.status == 1)
{
return(Json(new { status = true, msg = "Successfuly updated." }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, msg = "Someething went wrong." }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Index()
{
UserIfo model = new UserIfo();
//branch
//model.listOfBranch = InvBranchData.branchList(0);
return(View(model));
}
public JsonResult GetUserInfo(int id)
{
UserIfo model = InvUserData.UserData(id);
if (model != null)
{
return(Json(new { status = true, data = model }, JsonRequestBehavior.AllowGet));
}
return(Json(new { status = false, msg = "No data found!" }, JsonRequestBehavior.AllowGet));
}
public JsonResult Login(UserIfo model)
{
UserResponse usrdata = AccountData.AccountAuth(model.UserName.Trim(), model.UserPaswr.Trim());
if (usrdata.status == 1)
{
AccountData.SetCookie(true, usrdata.Userdata);
return(Json(new { status = true, msg = "Success.", url = Url.Action("Index", "Dashboard") }, JsonRequestBehavior.AllowGet));
}
else if (usrdata.status == 2)
{
return(Json(new { status = false, msg = usrdata.msg }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, msg = usrdata.msg }, JsonRequestBehavior.AllowGet));
}
}
public static UserIfo UserData(int id)
{
string query = string.Empty;
List <UserIfo> user = new List <UserIfo>();
if (id != 0)
{
query = "SELECT * FROM [User] WHERE UserNr = " + id + "";
}
else
{
query = "SELECT * FROM [User]";
}
DataSet ds = Connection.connectSQLServerQuery(query);
user = BaseReflection.DatasetBDToObjectList <UserIfo>(ds);
UserIfo model = (user != null && user.Count > 0) ? user[0] : null;
return(model);
}
