protected void Page_Load(object sender, EventArgs e)
{
Session["userId"] = 1;
int userId = (int)Session["userId"];
GoatDataContext lqdb = new GoatDataContext(ConfigurationManager.ConnectionStrings["GoatConnectionString"].ConnectionString.ToString());
var result = from r in lqdb.USER_PROFILE
where r.userId == userId
select r;
USER_PROFILE user = result.FirstOrDefault();
Image1.ImageUrl = user.headImage;
Label1.Text = user.userName;
Label2.Text = user.userName;
Label3.Text = user.phone;
Label4.Text = user.description;
if (user.gender == 1)
{
Label5.Text = "男";
}
else if (user.gender == 0)
{
Label5.Text = "女";
}
Label6.Text = user.email;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["houseId"] = 3;
int houseId = (int)Session["houseId"];
int customerId = (int)Session["customerId"];
GoatDataContext lqdb = new GoatDataContext(ConfigurationManager.ConnectionStrings["GoatConnectionString"].ConnectionString.ToString());
var result = from r in lqdb.HOUSE_INFO
where r.houseId == houseId
select r;
HOUSE_INFO house = result.FirstOrDefault();
houseName.Text = house.houseName;
price.Text = house.price;
province.Text = house.province;
city.Text = house.city;
startDate.Text = house.startDate;
endDate.Text = house.endDate;
string url = house.photo;
string[] s = url.Split(new char[] { ';' });
Image1.ImageUrl = s[0];
string date = DateTime.Now.ToString("yyyy-MM-dd");
datenow.Text = date;
var result1 = from r in lqdb.USER_PROFILE
where r.userId == customerId
select r;
USER_PROFILE user = result1.FirstOrDefault();
name.Text = user.userName;
Image2.ImageUrl = user.headImage;
}
}
private void addUserProfile(int id)
{
GoatDataContext lqdb = new GoatDataContext(ConfigurationManager.ConnectionStrings["GoatConnectionString"].ConnectionString.ToString());
USER_PROFILE userProfile = new USER_PROFILE();
userProfile.userId = id;
lqdb.USER_PROFILE.InsertOnSubmit(userProfile);
lqdb.SubmitChanges();
}
private string getHeadPicById(int customerId)
{
GoatDataContext lqdb = new GoatDataContext(ConfigurationManager.ConnectionStrings["GoatConnectionString"].ConnectionString.ToString());
var result = from r in lqdb.USER_PROFILE
where r.userId == customerId
select r;
USER_PROFILE user = result.FirstOrDefault();
string pic = user.headImage;
return(pic);
}
protected void Session_Start()
{
app_logwriter.ToLog(string.Format("New SessionID Started {0},", Session.SessionID));
USER_PROFILE UserProfile = new USER_PROFILE()
{
SESSION_CREATED = DateTime.Now,
SESSION_ID = Session.SessionID
};
if (UserProfile.UserId == 0)
{
//Redirect to Welcome Page if Session is null
HttpContext.Current.Response.Redirect("~/Account/Login?ReturnUrl=%2f", false);
}
Session["USER_PROFILE"] = UserProfile;
}
public string DELETE(ROLE RoleDelet, USER_PROFILE USER_PROFILE_DELETE, User userDelete)
{
var RoleDeletQwery = db.ROLES.Where(_ => _.Id == RoleDelet.Id).AsEnumerable().ToList();
db.ROLES.RemoveRange(RoleDeletQwery);
var USER_PROFILE_DELETEQwery = db.USER_PROFILES.Where(_ => _.PROFILE == USER_PROFILE_DELETE.PROFILE).AsEnumerable().ToList();
// сохраняем в бд все изменения
db.USER_PROFILES.RemoveRange(USER_PROFILE_DELETEQwery);
var userDeleteQwery = db.Users.Where(_ => _.login == userDelete.login).AsEnumerable().ToList();
db.Users.RemoveRange(userDeleteQwery);
db.SaveChanges();
return("Спасибо,");
}
public string CREATE(ROLE RoleAdd, USER_PROFILE USER_PROFILE_ADD, User userAdd)
{
if (RoleAdd.NAME != null)
{
db.ROLES.Add(RoleAdd);
}
// добавляем информацию о покупке в базу данных
if (USER_PROFILE_ADD.PROFILE != null)
{
db.USER_PROFILES.Add(USER_PROFILE_ADD);
}
// сохраняем в бд все изменения
if (userAdd.login != null)
{
db.Users.Add(userAdd);
db.SaveChanges();
var userAddQweryGetLogin = db.Users.FirstOrDefault(_ => _.login == userAdd.login);
var userAddQweryGetProfel = db.USER_PROFILES.FirstOrDefault(_ => _.Id == userAddQweryGetLogin.IdPROFILE);
userAddQweryGetLogin.IdPROFILECODE = userAddQweryGetProfel.PROFILE;
db.SaveChanges();
}
db.SaveChanges();
return("Спасибо");
}
public ActionResult Login(string ReturnUrl = "", string token = "")
{
if (User.Identity.IsAuthenticated)
{
return(LogOut());
}
#region "Process Token from Email Notification"
if (token.Trim() != string.Empty)
{
try
{
token = token.Replace("plus", "+").Replace("equal", "=");
token = App_Helpers.CryptorHelper.Decrypt(token, "MD5", true);
string[] arrToken = token.Split('|');
if (arrToken.Count() > 0)
{
string controller = arrToken[0];
string actionname = arrToken[1];
string username = arrToken[2];
int companyid = Convert.ToInt32(arrToken[3]);
int locationregid = Convert.ToInt32(arrToken[4]);
//isi login form
var user = (CustomMembershipUser)Membership.GetUser(username, false);
if (user != null)
{
ASM_UI.Models.CustomSerializeViewModel userModel = new ASM_UI.Models.CustomSerializeViewModel()
{
user_id = user.user_id,
user_name = user.user_name,
user_password = user.user_password,
user_type_id = user.user_type_id,
employee_id = user.employee_id,
employee_nik = user.employee_nik,
employee_name = user.employee_name,
employee_email = user.employee_email,
fl_active = user.fl_active,
RoleCode = user.Roles.Select(r => r.RoleCode).ToList()
};
#region setelah login isi user profile
USER_PROFILE UserProfile = Session["USER_PROFILE"] as USER_PROFILE;
UserProfile.UserId = userModel.user_id;
UserProfile.UserName = userModel.user_name;
UserProfile.user_type_id = userModel.user_type_id;
UserProfile.ms_user_type = _db.ms_user_type.Find(userModel.user_type_id);
UserProfile.company_id = companyid;
UserProfile.asset_reg_location_id = locationregid;
UserProfile.register_location = _db.ms_asset_register_location.Find(UserProfile.asset_reg_location_id);
UserProfile.employee_id = userModel.employee_id;
UserProfile.UserFullName = userModel.employee_name;
UserProfile.ms_employee = _db.ms_employee.Find(userModel.employee_id);
ms_employee_detail employee_detail = _db.ms_employee_detail.Where(w => w.employee_id == userModel.employee_id && w.company_id == companyid).FirstOrDefault <ms_employee_detail>();
if (employee_detail != null)
{
UserProfile.CompanyName = employee_detail.ms_asmin_company.company_name;
UserProfile.ms_department = employee_detail.ms_department;
UserProfile.department_id = UserProfile.ms_department.department_id;
UserProfile.ms_job_level = employee_detail.ms_job_level;
UserProfile.job_level_id = UserProfile.ms_job_level.job_level_id;
//UserProfile.ms_user_type = employee_detail.ms_user_type;
//UserProfile.user_type_id = UserProfile.ms_user_type.user_type_id;
if (employee_detail.ms_approval_range != null)
{
UserProfile.ms_approval_range = employee_detail.ms_approval_range;
UserProfile.range_id = UserProfile.ms_approval_range.range_id;
UserProfile.fl_approver = (UserProfile.range_id > 0);
}
}
else //null tidak dapaat menu/role
{
UserProfile.CompanyName = "";
UserProfile.ms_department = new ms_department()
{
department_id = 0
};
UserProfile.department_id = UserProfile.ms_department.department_id;
UserProfile.ms_job_level = new ms_job_level()
{
job_level_id = 0
};
UserProfile.job_level_id = UserProfile.ms_job_level.job_level_id;
UserProfile.ms_user_type = new ms_user_type()
{
user_type_id = 0
};
UserProfile.user_type_id = UserProfile.ms_user_type.user_type_id;
UserProfile.ms_approval_range = new ms_approval_range()
{
range_id = 0
};
UserProfile.range_id = UserProfile.ms_approval_range.range_id;
UserProfile.fl_approver = false;
}
app_logwriter.ToLog(UserProfile.UserName + " logged-in with SessionID=" + Session.SessionID);
app_logwriter.ToLog(string.Format("UserName:{0}, Employee:{1}, UserType={2}, JobLevel={3}, Department={4}, Company={5}, Location={6}, Register={7}"
, UserProfile.UserName
, UserProfile.ms_employee.employee_name
, UserProfile.ms_user_type.user_type_name
, UserProfile.ms_job_level.job_level_name
, UserProfile.ms_department.department_name
, UserProfile.CompanyName
, UserProfile.location_name
, UserProfile.register_location.asset_reg_location_name));
#endregion
string userData = JsonConvert.SerializeObject(userModel);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket
(
1, username.ToString(), DateTime.Now, DateTime.Now.AddHours(5), false, userData
);
string enTicket = FormsAuthentication.Encrypt(authTicket);
string cookie_name = app_setting.COOKIE_NAME + UserProfile.UserName;
//HttpCookie faCookie = new HttpCookie(cookie_name, enTicket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, enTicket);
Response.Cookies.Add(faCookie);
}
return(RedirectToAction(actionname, controller));
}
}
catch (Exception ex)
{
app_logwriter.ToLog("Token Invalid:" + ex.Message);
ModelState.AddModelError("", "Token Invalid.");
}
}
#endregion
string controllerName = RouteData.Values["controller"].ToString().ToLower();
string actionName = RouteData.Values["action"].ToString().ToLower();
ReturnUrl = (controllerName.Equals("account") && actionName.Equals("login")) ? "/" : ReturnUrl;
var loginView = new AccountLoginViewModel()
{
company_id = 0,
company_list = _db.ms_asmin_company.Where(r => r.fl_active == true && r.deleted_date == null).ToList(),
asset_reg_location_id = 0,
asset_register_location_list = _db.ms_asset_register_location.Where(r => r.fl_active == true && r.deleted_date == null).ToList(),
user_type_id = 0,
user_type_list = _db.ms_user_type.Where(r => r.fl_active == true && r.deleted_date == null).ToList(),
remember_me = true,
return_url = ReturnUrl,
};
ViewBag.ReturnUrl = loginView.return_url;
return(View(loginView));
}
public ActionResult Login(AccountLoginViewModel loginView, string ReturnUrl = "")
{
try
{
if (ModelState.IsValid)
{
if (Membership.ValidateUser(loginView.UserName, App_Helpers.CryptorHelper.Encrypt(loginView.Password, "MD5", true)))
{
var m_user = (CustomMembershipUser)Membership.GetUser(loginView, false);
if (m_user != null)
{
ASM_UI.Models.CustomSerializeViewModel userModel = new ASM_UI.Models.CustomSerializeViewModel()
{
user_id = m_user.user_id,
user_name = m_user.user_name,
user_password = m_user.user_password,
user_type_id = loginView.user_type_id,
employee_id = m_user.employee_id,
employee_nik = m_user.employee_nik,
employee_name = m_user.employee_name,
employee_email = m_user.employee_email,
fl_active = m_user.fl_active,
RoleCode = m_user.Roles.Select(r => r.RoleCode).ToList()
};
#region setelah login isi user profile
USER_PROFILE UserProfile = Session["USER_PROFILE"] as USER_PROFILE;
UserProfile.UserId = userModel.user_id;
UserProfile.UserName = userModel.user_name;
UserProfile.user_type_id = userModel.user_type_id;
UserProfile.ms_user_type = _db.ms_user_type.Find(userModel.user_type_id);
UserProfile.company_id = loginView.company_id;
UserProfile.asset_reg_location_id = loginView.asset_reg_location_id;
UserProfile.register_location = _db.ms_asset_register_location.Find(UserProfile.asset_reg_location_id);
UserProfile.employee_id = userModel.employee_id;
UserProfile.UserFullName = userModel.employee_name;
UserProfile.ms_employee = _db.ms_employee.Find(userModel.employee_id);
ms_employee_detail employee_detail = _db.ms_employee_detail.Where(w => w.employee_id == userModel.employee_id &&
w.company_id == UserProfile.company_id &&
w.asset_reg_location_id == UserProfile.asset_reg_location_id
).FirstOrDefault <ms_employee_detail>();
if (employee_detail != null)
{
UserProfile.CompanyName = employee_detail.ms_asmin_company.company_name;
UserProfile.ms_department = employee_detail.ms_department;
UserProfile.department_id = UserProfile.ms_department.department_id;
UserProfile.ms_job_level = employee_detail.ms_job_level;
UserProfile.job_level_id = UserProfile.ms_job_level.job_level_id;
//UserProfile.ms_user_type = employee_detail.ms_user_type;
//UserProfile.user_type_id = UserProfile.ms_user_type.user_type_id;
UserProfile.location_id = employee_detail.location_id;
ms_asset_location asset_location = _db.ms_asset_location.Where(w => w.location_id == UserProfile.location_id).FirstOrDefault <ms_asset_location>();
UserProfile.location_name = asset_location.location_name;
if (employee_detail.ms_approval_range != null)
{
UserProfile.ms_approval_range = employee_detail.ms_approval_range;
UserProfile.range_id = UserProfile.ms_approval_range.range_id;
UserProfile.fl_approver = (UserProfile.range_id > 0);
}
}
else //null tidak dapaat menu/role
{
UserProfile.CompanyName = "";
UserProfile.ms_department = new ms_department()
{
department_id = 0
};
UserProfile.department_id = UserProfile.ms_department.department_id;
UserProfile.ms_job_level = new ms_job_level()
{
job_level_id = 0
};
UserProfile.job_level_id = UserProfile.ms_job_level.job_level_id;
UserProfile.ms_user_type = new ms_user_type()
{
user_type_id = 0
};
UserProfile.user_type_id = UserProfile.ms_user_type.user_type_id;
UserProfile.ms_approval_range = new ms_approval_range()
{
range_id = 0
};
UserProfile.range_id = UserProfile.ms_approval_range.range_id;
UserProfile.fl_approver = false;
}
app_logwriter.ToLog(UserProfile.UserName + " logged-in with SessionID=" + Session.SessionID);
app_logwriter.ToLog(string.Format("UserName:{0}, Employee:{1}, UserType={2}, JobLevel={3}, Department={4}, Company={5}, Location={6}, Register={7}"
, UserProfile.UserName
, UserProfile.ms_employee.employee_name
, UserProfile.ms_user_type.user_type_name
, UserProfile.ms_job_level.job_level_name
, UserProfile.ms_department.department_name
, UserProfile.CompanyName
, UserProfile.location_name
, UserProfile.register_location.asset_reg_location_name));
#endregion
string userData = JsonConvert.SerializeObject(userModel);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
1, loginView.UserName, DateTime.Now, DateTime.Now.AddHours(5), false, userData
);
string enTicket = FormsAuthentication.Encrypt(authTicket);
string cookie_name = app_setting.COOKIE_NAME + UserProfile.UserName;
//HttpCookie faCookie = new HttpCookie(cookie_name, enTicket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, enTicket);
Response.Cookies.Add(faCookie);
}
else
{
ModelState.AddModelError("", "Something Wrong : User not Found or user login not matched.");
//throw new Exception("Something Wrong : User not Found or user login not matched.");
}
string controllerName = RouteData.Values["controller"].ToString().ToLower();
string actionName = RouteData.Values["action"].ToString().ToLower();
ReturnUrl = (controllerName.Equals("account") && actionName.Equals("login")) ? "/" : ReturnUrl;
//if (Url.IsLocalUrl(ReturnUrl))
if (!string.IsNullOrWhiteSpace(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("", "Something Wrong : Username/nik or Password invalid.");
}
}
else
{
ModelState.AddModelError("", "Something Wrong : Username/nik or Password invalid.");
}
}
catch (Exception _ex)
{
//ModelState.AddModelError("", "Invalid Login." + ex.Message);
App_Helpers.app_logwriter.ToLog("Invalid Login." + _ex.Message);
ModelState.AddModelError("", "Invalid Login.");
}
if (loginView.company_list == null || loginView.company_list.Count == 0)
{
loginView.company_list = _db.ms_asmin_company.Where(r => r.fl_active == true && r.deleted_date == null).ToList();
}
if (loginView.asset_register_location_list == null || loginView.asset_register_location_list.Count == 0)
{
loginView.asset_register_location_list = _db.ms_asset_register_location.Where(r => r.fl_active == true && r.deleted_date == null).ToList();
}
if (loginView.user_type_list == null || loginView.user_type_list.Count == 0)
{
loginView.user_type_list = _db.ms_user_type.Where(r => r.fl_active == true && r.deleted_date == null).ToList();
}
return(View(loginView));
}
public string UPDATE(ROLE RoleUpdate,
USER_PROFILE USER_PROFILE_UPDATE,
User userUpdate,
string NewNamePROFILES,
string NewNameUserLogin,
string NewNameUserFIO
)
{
if (RoleUpdate.NAME != null)
{
var USER_ROLE_UPDATE_QWERY = db.ROLES.FirstOrDefault(a => a.Id == RoleUpdate.Id);
if (USER_ROLE_UPDATE_QWERY != null)
{
USER_ROLE_UPDATE_QWERY.NAME = RoleUpdate.NAME;
}
}
if (RoleUpdate.DISCRIPTION != null)
{
var USER_ROLE_UPDATE_QWERY = db.ROLES.FirstOrDefault(a => a.Id == RoleUpdate.Id);
if (USER_ROLE_UPDATE_QWERY != null)
{
USER_ROLE_UPDATE_QWERY.DISCRIPTION = RoleUpdate.DISCRIPTION;
}
}
if (NewNamePROFILES != "" || NewNamePROFILES != null)
{
var USER_PROFILES_UPDATE_QWERY = db.USER_PROFILES.FirstOrDefault(a => a.PROFILE == USER_PROFILE_UPDATE.PROFILE);
if (USER_PROFILES_UPDATE_QWERY != null)
{
USER_PROFILES_UPDATE_QWERY.PROFILE = NewNamePROFILES;
}
var USER_UPDATE_QWERY = db.Users.FirstOrDefault(a => a.IdPROFILECODE == USER_PROFILE_UPDATE.PROFILE);
if (USER_UPDATE_QWERY != null)
{
USER_UPDATE_QWERY.IdPROFILECODE = NewNamePROFILES;
}
}
// добавляем информацию о покупке в базу данных
// сохраняем в бд все изменения
if (NewNameUserLogin != "" || NewNameUserLogin != null)
{
var userUpdateQwery = db.Users.FirstOrDefault(_ => _.login == userUpdate.login);
if (userUpdateQwery != null)
{
userUpdateQwery.login = NewNameUserLogin;
}
}
if (NewNameUserFIO != "" || NewNameUserFIO != null)
{
var userUpdateQwery = db.Users.FirstOrDefault(_ => _.login == userUpdate.login);
if (userUpdateQwery != null)
{
userUpdateQwery.FIO = NewNameUserFIO;
}
}
db.SaveChanges();
return("Спасибо,");
}
