public object[] queryDataManageUserLoginByUserId(USER_LOGIN param) { log.Info("Start log INFO... queryDataManageUserLoginByUserId"); MsgForm msgError = new MsgForm(); USER_LOGIN form = new USER_LOGIN(); try { using (var db = new PaknampoScaleDBEntities()) { form = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault(); db.Dispose(); msgError.statusFlag = MsgForm.STATUS_SUCCESS; } } catch (Exception ex) { log.Error(ex.ToString(), ex); msgError.statusFlag = MsgForm.STATUS_ERROR; msgError.messageDescription = ex.ToString(); } finally { log.Info("End log INFO... queryDataManageUserLoginByUserId"); } return(new object[] { msgError, form }); }
public ActionResult Login(USER_LOGIN model, string returnUrl) { int LoginCase = 0; if (!ModelState.IsValid) { return(View(model)); } if (LoginBase(model, 1)) { LoginCase = 1; } switch (LoginCase) { case 1: // Complete Redirect Session["User"] = model.WHCODE; TempData["User"] = model.WHCODE; SetCookie(model.WHCODE, "1"); return(RedirectToLocal(returnUrl, "1")); case 2: //Lock out //return RedirectToAction("updatedid", model); default: ModelState.AddModelError("", "Invalid login attempt."); return(View(model)); } }
public object[] deleteDataManageUserLogin(USER_LOGIN param) { log.Info("Start log INFO... deleteDataManageUserLogin"); MsgForm msgError = new MsgForm(); USER_LOGIN form = new USER_LOGIN(); try { using (var db = new PaknampoScaleDBEntities()) { form = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault(); if (Util.isNotEmpty(form)) { db.USER_LOGIN.Remove(form); } db.SaveChanges(); msgError.statusFlag = MsgForm.STATUS_SUCCESS; } } catch (Exception ex) { log.Error(ex.ToString(), ex); msgError.statusFlag = MsgForm.STATUS_ERROR; msgError.messageDescription = ex.ToString(); } finally { log.Info("End log INFO... deleteDataManageUserLogin"); } return(new object[] { msgError }); }
public bool LoginBase(USER_LOGIN model, int Position) { bool OK = false; Data_OPDataContext Context = new Data_OPDataContext(); Data_UserDataContext Context_user = new Data_UserDataContext(); if (Position == 1) { var queryX = Context.MAS_WHs.Where(x => x.WHCODE == model.WHCODE && x.WHCODE == model.PASSWORD).Count(); if (queryX > 0) { OK = true; } } else { var queryX = Context_user.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).Count(); if (queryX > 0) { OK = true; } } return(OK); }
private void lnklblogout_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { this.Close(); USER_LOGIN ul = new USER_LOGIN(); ul.Show(); }
public void queryDataManageUserLoginByUserId() { MST007Controller mst007Ctrl = new MST007Controller(); try { object[] result = mst007Ctrl.queryDataManageUserLoginByUserId(formUserLogin); MsgForm msgForm = (MsgForm)result[0]; USER_LOGIN data = (USER_LOGIN)result[1]; if (msgForm.statusFlag.Equals(1)) { if (Util.isNotEmpty(data)) { txtUserId.Text = data.USER_ID; txtUserPassword.Text = data.USER_PASSWORD; txtUserFirstname.Text = data.USER_FIRSTNAME; txtUserLastname.Text = data.USER_LASTNAME; //cboStatusFlag.SelectedValue = data.STATUS_FLAG; formUserLogin = data; } } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public object[] checkLogin(USER_LOGIN param) { log.Info("Start log INFO... checkLogin"); MsgForm msgError = new MsgForm(); USER_LOGIN result = new USER_LOGIN(); try { using (var db = new PaknampoScaleDBEntities()) { result = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID && row.USER_PASSWORD == param.USER_PASSWORD select row).FirstOrDefault(); msgError.statusFlag = MsgForm.STATUS_SUCCESS; } } catch (Exception ex) { log.Error(ex.ToString(), ex); msgError.statusFlag = MsgForm.STATUS_ERROR; msgError.messageDescription = ex.ToString(); } finally { log.Info("End log INFO... checkLogin"); } return(new object[] { msgError, result }); }
private void btncancel_Click(object sender, EventArgs e) { this.Close(); USER_LOGIN ul = new USER_LOGIN(); ul.Show(); }
private void btndeactivate_Click(object sender, EventArgs e) { string s = "delete from customer_info where email='" + uname + "'"; dataaccess_layer.ProcessQuery(s); USER_LOGIN ul = new USER_LOGIN(); ul.Show(); }
//private void txtUsername_KeyDown(object sender, KeyEventArgs e) //{ // if (e.KeyCode == Keys.Enter) // { // txtPassword.Focus(); // } //} //private void txtPassword_KeyDown(object sender, KeyEventArgs e) //{ // if (e.KeyCode == Keys.Enter) // { // txtUsername.Focus(); // } //} public void checkLogin() { Cursor.Current = Cursors.WaitCursor; LoginController loginCtrl = new LoginController(); USER_LOGIN form = new USER_LOGIN(); try { if (Util.isEmpty(txtUsername.Text)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE_USER_LOGIN); return; } if (Util.isEmpty(txtPassword.Text)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE_PASSWORD_LOGIN); return; } form.USER_ID = txtUsername.Text; form.USER_PASSWORD = txtPassword.Text; if (Util.isEmpty(form)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE); return; } object[] result = loginCtrl.checkLogin(form); MsgForm msgForm = (MsgForm)result[0]; PaknampoScale.src.model.entities.USER_LOGIN data = (src.model.entities.USER_LOGIN)result[1]; if (msgForm.statusFlag.Equals(1)) { if (Util.isEmpty(data)) { MessageBox.Show(CommonUtil.DATA_NOTFOUND_AGAIN_LOGIN); } else { MenuMain menuMain = new MenuMain(); this.Hide(); menuMain.Show(); } } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { Log.Error(ex.ToString(), ex); } }
public ActionResult updatedid(USER_LOGIN model) { Dp_List ul = new Dp_List(); Data_UserDataContext db = new Data_UserDataContext(); ul.STCODE = model.STCODE; ul.JT_LIST = new SelectList(db.MAS_DEPs, "DP_ID", "DEPARTMENT"); return(View(ul)); }
public ActionResult Manage_Partial(int page = 1, string sh = "") { Detail cc = new Detail(); cc.STCODE = userOnline; cc.sh = sh; //cc.Ticket_ID = Id; //var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_OP/api/TicketOP/Ticketlist"); var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_LE/api/TicketLE/Manage_Partial"); var request = new RestRequest(Method.POST); request.RequestFormat = DataFormat.Json; request.AddJsonBody(cc); var response = restClient.Execute(request); var json = response.Content; JsonDeserializer deserial = new JsonDeserializer(); List <ListUserLogin> items = JsonConvert.DeserializeObject <List <ListUserLogin> >(json); var Ans = items.FirstOrDefault(); // ------------------------------------------------------------------------------------ Data_UserDataContext DropD = new Data_UserDataContext(); var dep = (from xx in DropD.MAS_USER_As orderby xx.US_ID select xx).GroupBy(x => x.ANAME).Select(grp => grp.First()); ViewBag.Dep = new SelectList(dep, "US_ID", "ANAME"); List <USER_LOGIN> list = new List <USER_LOGIN>(); if (Ans.Userloginid != null) { foreach (var dx in Ans.Userloginid) { USER_LOGIN ux = new USER_LOGIN(); ux.ID = dx.ID; ux.STCODE = dx.STCODE; ux.FULLNAME = dx.FULLNAME; ux.DEP = dx.DEP; ux.A_NAME = dx.A_NAME; list.Add(ux); //PhoneModels.RowPhone.Add(ipn); } } ViewBag.sh = sh; return(PartialView(list.ToPagedList(page, 20))); }
public void resetDataManageUserLogin() { txtUserId.Text = ""; txtUserPassword.Text = ""; txtUserFirstname.Text = ""; txtUserLastname.Text = ""; cboStatusFlag.SelectedValue = 1; formUserLogin = new USER_LOGIN(); flagAddEdit = "A"; txtUserId.Enabled = true; txtUserId.Focus(); queryDataLoginStatus(); }
// GET: User public ActionResult Index() { USER_LOGIN userLogin = Session["USER_LOGIN"] as USER_LOGIN; if (userLogin != null) { return(Redirect("/home/")); } else { return(View()); } }
public bool LoginBase(USER_LOGIN model) { bool OK = false; Data_UserDataContext Context = new Data_UserDataContext(); var queryX = Context.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).Count(); if (queryX > 0) { OK = true; } return(OK); }
private bool checkedepartment(USER_LOGIN model) { Data_UserDataContext Context = new Data_UserDataContext(); var queryX = Context.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).FirstOrDefault(); if (queryX.D_ID == 0) { return(true); } else { return(false); } }
public ActionResult Manage_Partial(int page = 1, string sh = "") { UserViewModels Model = new UserViewModels(); data_userDataContext DropD = new data_userDataContext(); var dep = (from xx in DropD.MAS_USER_As orderby xx.US_ID select xx).GroupBy(x => x.ANAME).Select(grp => grp.First()); ViewBag.Dep = new SelectList(dep, "US_ID", "ANAME"); sh = sh.Trim(); List <USER_LOGIN> list = new List <USER_LOGIN>(); using (data_userDataContext Context = new data_userDataContext()) { IQueryable <VW_USER_FOR_LE> DataUser; DataUser = Context.VW_USER_FOR_LEs; if (sh.Length > 0) { DataUser = DataUser.Where(x => x.STCODE.Contains(sh) || x.NAME.Contains(sh) || x.DPCODE.Contains(sh)); } foreach (var dx in DataUser) { USER_LOGIN ux = new USER_LOGIN(); ux.ID = dx.US_ID; ux.STCODE = dx.STCODE; ux.FULLNAME = dx.NAME; ux.DEP = dx.DPCODE; ux.A_NAME = dx.ANAME; list.Add(ux); //PhoneModels.RowPhone.Add(ipn); } //Model.RowUser = list; } ViewBag.sh = sh; return(PartialView(list.ToPagedList(page, 20))); }
public ActionResult Login(string username, string password) { Session.Clear(); string PasUserLogin = WiseOffice.clsSecuritys.Encrypt(password, "", true); EntitiesConnection dbContext = new EntitiesConnection(); USER_LOGIN userLogin = dbContext.USER_LOGIN.FirstOrDefault(a => a.COD_USER_LOGIN == username && a.PAS_USER_LOGIN == PasUserLogin); if (userLogin != null) { Session["USER_LOGIN"] = userLogin; return(Redirect("/home/")); } else { TempData["ErrorMsg"] = "Tài khoản hoặc mật khẩu không đúng !"; return(Redirect("/user/")); } }
public void deleteDataManageUserLogin() { MST007Controller mst007Ctrl = new MST007Controller(); USER_LOGIN form = new USER_LOGIN(); try { form.USER_ID = txtUserId.Text; if (Util.isEmpty(form.USER_ID)) { MessageBox.Show(CommonUtil.SELECT_DATA_DELETE); return; } if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes) { object[] result = mst007Ctrl.deleteDataManageUserLogin(form); MsgForm msgForm = (MsgForm)result[0]; if (msgForm.statusFlag.Equals(1)) { resetDataManageUserLogin(); searchDataManageUserLogin(); MessageBox.Show(CommonUtil.DELETE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
/// <summary>用户指令处理</summary> public ASObject Switch(int moduleNumber, int commandNumber, TGGSession session, ASObject data) { #if DEBUG var sw = Stopwatch.StartNew(); #endif if (commandNumber == (int)UserCommand.USER_SALARY) { if (!CommonHelper.IsOpen(session.Player.Role.Kind.role_level, (int)OpenModelType.俸禄)) { return(CommonHelper.ErrorResult(ResultType.BASE_PLAYER_LEVEL_ERROR)); } } var aso = new ASObject(); //指令匹配 switch (commandNumber) { case (int)UserCommand.USER_CREATE: { aso = USER_CREATE.GetInstance().CommandStart(session, data); break; } case (int)UserCommand.USER_LOGIN: { aso = USER_LOGIN.GetInstance().CommandStart(session, data); break; } case (int)UserCommand.CONSUME: { aso = CONSUME.GetInstance().CommandStart(session, data); break; } case (int)UserCommand.HEARTBEAT: { aso = HEARTBEAT.GetInstance().CommandStart(session, data); break; } case (int)UserCommand.REWARDS: { REWARDS.GetInstance().CommandStart(session, data); break; } case (int)UserCommand.USER_SALARY: { aso = USER_SALARY.GetInstance().CommandStart(session, data); break; } case (int)UserCommand.USER_MODULE_ACTIVETION: { aso = USER_MODULE_ACTIVETION.GetInstance().CommandStart(session, data); break; } case (int)UserCommand.ACTIVITY_OPEN: { aso = ACTIVITY_OPEN.GetInstance().CommandStart(session, data); break; } } #if DEBUG sw.Stop(); XTrace.WriteLine("指令 {1} 运行总耗时:{0} 毫秒", sw.ElapsedMilliseconds.ToString(), GetType().Namespace); #endif return(aso); }
public void insertOrUpdateDataManageUserLogin() { MST007Controller mst007Ctrl = new MST007Controller(); USER_LOGIN form = new USER_LOGIN(); LOGIN_STATUS formUpdateStatusLogin = new LOGIN_STATUS(); try { if (Util.isEmpty(txtUserId.Text) || Util.isEmpty(txtUserPassword.Text) || Util.isEmpty(cboStatusFlag.SelectedValue)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE); return; } form.USER_ID = txtUserId.Text; form.USER_PASSWORD = txtUserPassword.Text; form.USER_FIRSTNAME = txtUserFirstname.Text; form.USER_LASTNAME = txtUserLastname.Text; //form.STATUS_FLAG = Int32.Parse(cboStatusFlag.SelectedValue.ToString()); form.STATUS_FLAG = Int32.Parse("1"); formUpdateStatusLogin.LOGIN_STATUS_VALUE = Int32.Parse(cboStatusFlag.SelectedValue.ToString()); if (Util.isEmpty(form) && Util.isEmpty(formUpdateStatusLogin.LOGIN_STATUS_VALUE)) { return; } object[] result = mst007Ctrl.insertOrUpdateDataManageUserLogin(form, formUpdateStatusLogin, flagAddEdit); MsgForm msgForm = (MsgForm)result[0]; USER_LOGIN data = (USER_LOGIN)result[1]; if (flagAddEdit.Equals("A")) { if (Util.isNotEmpty(data)) { if (msgForm.statusFlag.Equals(1)) { MessageBox.Show(CommonUtil.DUPLICATE_DATA); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } else { if (msgForm.statusFlag.Equals(1)) { resetDataManageUserLogin(); searchDataManageUserLogin(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } else if (flagAddEdit.Equals("E")) { if (msgForm.statusFlag.Equals(1)) { resetDataManageUserLogin(); searchDataManageUserLogin(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
private void btnsubmit_Click(object sender, EventArgs e) { try { int valid1 = 0; if (cbgen.Text == "Select Gender" || cbssn.Text == "Select ID proof type") { valid = 1; } if (lblcaptcha.Text != tbcaptcha.Text) { MessageBox.Show("Incorrect Captcha"); Random random = new Random(); string combination = "0123456789ABCDEFGHIJKJLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"; StringBuilder captcha = new StringBuilder(); for (int i = 0; i < 6; i++) { captcha.Append(combination[random.Next(combination.Length)]); } lblcaptcha.Text = captcha.ToString(); } foreach (Control tb in this.Controls) { if (tb is TextBox) { valid1 = bussiness_accesslayer.null_validation(tb.Text); if (valid1 == 1 || valid == 1) { MessageBox.Show("Empty Fields Not Allowed", "Error"); break; } if (valid == 2 || valid3 == 2 || valid4 == 2) { MessageBox.Show("Validations Not Satisfied", "Error"); break; } else { valid4 = 0; } } } if (valid == 0 && valid1 == 0 && valid3 == 0 && valid4 == 0 && lblcaptcha.Text == tbcaptcha.Text) { string encrpyt = bussiness_accesslayer.Encrypt(tbpass.Text); SqlDataReader sdr = null; string conn = "Data Source=DESKTOP-OPN87JD\\SQLEXPRESS;Initial Catalog=ExpDB;Integrated Security=True"; SqlConnection sc = null; sc = new SqlConnection(conn); try { sc.Open(); SqlCommand cmd = new SqlCommand("Cust_Reg", sc); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Cname", tbname.Text); cmd.Parameters.AddWithValue("@DOB", dob.Value.Date.ToShortDateString()); cmd.Parameters.AddWithValue("@Address", tbadd.Text); cmd.Parameters.AddWithValue("@Phone", tbphone.Text); cmd.Parameters.AddWithValue("@Email", tbemail.Text); cmd.Parameters.AddWithValue("@Password", encrpyt); cmd.Parameters.AddWithValue("@SSNType", cbssn.Text); cmd.Parameters.AddWithValue("@SSNNumber", tbssn.Text); cmd.Parameters.AddWithValue("@Gender", cbgen.Text); cmd.Parameters.AddWithValue("@Security1", cmbsecurity1.Text); cmd.Parameters.AddWithValue("@Security2", cmbsecurity2.Text); cmd.Parameters.AddWithValue("@Security3", cmbsecurity3.Text); cmd.Parameters.AddWithValue("@Answer1", tbanswer1.Text); cmd.Parameters.AddWithValue("@Answer2", tbanswer2.Text); cmd.Parameters.AddWithValue("@Answer3", tbanswer3.Text); sdr = cmd.ExecuteReader(); } catch (Exception ex) { bussiness_accesslayer.LogErrorFile(ex.Message + DateTime.Now.ToLongDateString() + DateTime.Now.ToLongTimeString()); MessageBox.Show("Internal Error Occured", "Sorry"); this.BeginInvoke(new MethodInvoker(Close)); } MessageBox.Show("Registration is Successful", "Congrats"); MessageBox.Show("Your Email will be user ID", "Remember"); btnclear_Click(btnclear, null); this.Close(); USER_LOGIN ul = new USER_LOGIN(); ul.Show(); } valid = 0; } catch (Exception ex) { bussiness_accesslayer.LogErrorFile(ex.Message + DateTime.Now.ToLongDateString() + DateTime.Now.ToLongTimeString()); MessageBox.Show("Internal Error Occured", "Sorry"); this.BeginInvoke(new MethodInvoker(Close)); } }
public object[] insertOrUpdateDataManageUserLogin(USER_LOGIN param, LOGIN_STATUS paramStatus, string flagAddEdit) { log.Info("Start log INFO... insertOrUpdateDataManageUserLogin"); MsgForm msgError = new MsgForm(); USER_LOGIN formInsert = new USER_LOGIN(); USER_LOGIN formUpdate = new USER_LOGIN(); LOGIN_STATUS formUpdateStatusLogin = new LOGIN_STATUS(); try { using (var db = new PaknampoScaleDBEntities()) { formUpdate = (from row in db.USER_LOGIN where row.USER_ID == param.USER_ID select row).FirstOrDefault(); formUpdateStatusLogin = (from row in db.LOGIN_STATUS where row.LOGIN_STATUS_ID == 1 select row).FirstOrDefault(); if (flagAddEdit.Equals("A")) { if (Util.isEmpty(formUpdate)) { formInsert.USER_ID = param.USER_ID; formInsert.USER_PASSWORD = param.USER_PASSWORD; formInsert.USER_FIRSTNAME = param.USER_FIRSTNAME; formInsert.USER_LASTNAME = param.USER_LASTNAME; formInsert.STATUS_FLAG = param.STATUS_FLAG; db.USER_LOGIN.Add(formInsert); log.Info("Insert Data form USER_LOGIN" + " USER_ID : " + formInsert.USER_ID + " USER_PASSWORD : "******" USER_FIRSTNAME : " + formInsert.USER_FIRSTNAME + " USER_LASTNAME : " + formInsert.USER_LASTNAME + " STATUS_FLAG : " + formInsert.STATUS_FLAG ); } } else if (flagAddEdit.Equals("E")) { if (Util.isNotEmpty(formUpdate)) { formUpdate.USER_PASSWORD = param.USER_PASSWORD; formUpdate.USER_FIRSTNAME = param.USER_FIRSTNAME; formUpdate.USER_LASTNAME = param.USER_LASTNAME; formUpdate.STATUS_FLAG = param.STATUS_FLAG; log.Info("Update Data form USER_LOGIN" + " USER_ID : " + formUpdate.USER_ID + " USER_PASSWORD : "******" USER_FIRSTNAME : " + formUpdate.USER_FIRSTNAME + " USER_LASTNAME : " + formUpdate.USER_LASTNAME + " STATUS_FLAG : " + formUpdate.STATUS_FLAG ); } } formUpdateStatusLogin.LOGIN_STATUS_VALUE = paramStatus.LOGIN_STATUS_VALUE; log.Info("Update Data form LOGIN_STATUS" + " LOGIN_STATUS_ID : " + paramStatus.LOGIN_STATUS_ID + " LOGIN_STATUS_VALUE : " + paramStatus.LOGIN_STATUS_VALUE ); db.SaveChanges(); msgError.statusFlag = MsgForm.STATUS_SUCCESS; } } catch (Exception ex) { log.Error(ex.ToString(), ex); msgError.statusFlag = MsgForm.STATUS_ERROR; msgError.messageDescription = ex.ToString(); } finally { log.Info("End log INFO... insertOrUpdateDataManageUserLogin"); } return(new object[] { msgError, formUpdate }); }