public static string GetUserName(Guid UserID) { NSIADataContext dc = new NSIADataContext(); USERINFO employee = (from a in dc.USERINFOs where a.usernameid.Value.Equals(UserID) select a).SingleOrDefault(); return(employee.NAMELOCAL); }
public bool UpdateUSERINFO(USERINFO uSERINFO) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateUSERINFO", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@USERINFOID", SqlDbType.Int).Value = uSERINFO.USERINFOID; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = uSERINFO.AddedDate; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = uSERINFO.AddedBy; cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = uSERINFO.ModifyDate; cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = uSERINFO.ModifyBy; cmd.Parameters.Add("@Type", SqlDbType.NVarChar).Value = uSERINFO.Type; cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = uSERINFO.UserName; cmd.Parameters.Add("@Agent_LocationID", SqlDbType.Int).Value = uSERINFO.Agent_LocationID; cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = uSERINFO.FirstName; cmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = uSERINFO.LastName; cmd.Parameters.Add("@MiddleName", SqlDbType.NVarChar).Value = uSERINFO.MiddleName; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = uSERINFO.Address; cmd.Parameters.Add("@City", SqlDbType.NVarChar).Value = uSERINFO.City; cmd.Parameters.Add("@State", SqlDbType.NVarChar).Value = uSERINFO.State; cmd.Parameters.Add("@Country", SqlDbType.NVarChar).Value = uSERINFO.Country; cmd.Parameters.Add("@PostalCode", SqlDbType.NVarChar).Value = uSERINFO.PostalCode; cmd.Parameters.Add("@ExpDate", SqlDbType.DateTime).Value = uSERINFO.ExpDate; cmd.Parameters.Add("@Status", SqlDbType.Int).Value = uSERINFO.Status; cmd.Parameters.Add("@HomePhone", SqlDbType.NVarChar).Value = uSERINFO.HomePhone; cmd.Parameters.Add("@WorkPhone", SqlDbType.NVarChar).Value = uSERINFO.WorkPhone; cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = uSERINFO.Mobile; cmd.Parameters.Add("@Comm", SqlDbType.NVarChar).Value = uSERINFO.Comm; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public EmpCheckDay(USERINFO emp, CHECKINOUT obj) { Emp = emp; CheckDate = obj.CHECKTIME.Date; RawChecks.Add(obj); Checks = RawChecks; }
public static USERINFO GetUserByID(Guid UserID) { NSIADataContext dc = new NSIADataContext(); USERINFO Result = (from x in dc.USERINFOs where x.usernameid == UserID select x).SingleOrDefault(); return(Result); }
private void reLoadSession() { if (Session["userType"] == null || Session["aGENT"] != null || Session["lOCATION"] != null) { USERINFO userInfo = new USERINFO(); userInfo = USERINFOManager.GetUSERINFOByUserNameType("Agent", User.Identity.Name);//"Agent" is dami in database i have not use the if (userInfo != null) { Session["userType"] = userInfo.Type.ToString(); Session["userInfoID"] = userInfo.USERINFOID.ToString(); Session["userName"] = userInfo.UserName.ToString(); //if (userInfo.Agent_LocationID.ToString() == ddlAgent.SelectedItem.Value.ToString()) if (userInfo.Type == "Agent") { Session["aGENT"] = AGENTManager.GetAGENTByID(userInfo.Agent_LocationID); Session["role"] = "Agent"; } else if (userInfo.Type == "Location") { Session["lOCATION"] = LOCATIONGROUPManager.GetLOCATIONGROUPByID(userInfo.Agent_LocationID); Session["role"] = "Location"; } } } }
public ActionResult Index(FormCollection post) { Session["USERID"] = string.Empty; Session["LEVEL"] = string.Empty; Session["AREAID"] = string.Empty; USERINFO USER = new USERINFO() { ID = post["ACCOUNT"], PASSWORD = post["PASSWORD"] }; if (USER.ID != string.Empty && USER.PASSWORD != string.Empty) { string sql = $"select * from userinfo where ID='{USER.ID}' and PASSWORD='******' AND (STATUS=1 or STATUS is null)"; DataTable DT = CommonTools.GetDataTable(sql, connStr); if (DT != null && DT.Rows.Count > 0) { Session["USERID"] = DT.Rows[0]["USERID"].ToString(); Session["LEVEL"] = DT.Rows[0]["LEVEL"].ToString(); Session["AREAID"] = DT.Rows[0]["AREAID"].ToString(); return(RedirectToAction("UserList", "Home", null)); } else { TempData["message"] = "帳號或密碼錯誤!"; } } else { TempData["message"] = "請輸入帳號密碼!"; } return(View()); }
public async Task <IHttpActionResult> PutUSERINFO(int id, USERINFO uSERINFO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != uSERINFO.ID) { return(BadRequest()); } db.Entry(uSERINFO).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { //if (!USERINFOExists(id)) //{ // return NotFound(); //} //else //{ // throw; //} } return(StatusCode(HttpStatusCode.NoContent)); }
public static USERINFO GetUSERINFOByUserNameType(string type, string userName) { USERINFO uSERINFO = new USERINFO(); SqlUSERINFOProvider sqlUSERINFOProvider = new SqlUSERINFOProvider(); uSERINFO = sqlUSERINFOProvider.GetUSERINFOByUserNameType(type, userName); return(uSERINFO); }
public static USERINFO GetUSERINFOByID(int id) { USERINFO uSERINFO = new USERINFO(); SqlUSERINFOProvider sqlUSERINFOProvider = new SqlUSERINFOProvider(); uSERINFO = sqlUSERINFOProvider.GetUSERINFOByID(id); return(uSERINFO); }
public void CreateUserInfo(string idUser, string name, string firstname, string street, string zipcode, string city, string phone) { USERINFO info = new USERINFO { userId = idUser, nameUser = name, firstname = firstname, street = street, zipCode = zipcode, city = city, phone = phone, creationDate = DateTime.Now }; db.USERINFOs.Add(info); db.SaveChanges(); }
/// <summary> /// 根据用户名 密码进行登录 /// </summary> /// <param name="userID"></param> /// <returns></returns> public ActionResult Logins(string userID) { USERINFO_BN user = new USERINFO_BN(); USERINFO dtuser = (USERINFO)user.GetModel(userID); Session["userInfo"] = dtuser; return(RedirectToAction("Index")); }
public ActionResult AddUserInfo(USERINFO userInfo) { userInfo.ID = userInfo.ID; userInfo.DELFLAG = 0; userInfo.MODIFIEDON = DateTime.Now; userInfo.SUBTIME = DateTime.Now; UserInfoService.AddEntity(userInfo); return(Content("ok")); }
public USERINFO GetUserInfo(string CARDID) { USERINFO userinfo = new USERINFO { CARDID = CARDID, USERNAME = "******", ID = "", BIRTHDAY = "", GENDER = "", ISSUEDDATE = "", PHONE = "", ECONTACT = "", EPHONE = "", AREAID = "", LEVEL = "", COL1 = "", COL2 = "", COL3 = "", STATUS = "200", MESSAGE = "Search Success" }; try { MySqlConnection conn = new MySqlConnection(connStr); MySqlCommand command = conn.CreateCommand(); conn.Open(); command.CommandText = "select * from cardlist C left join userinfo U on C.USERID=U.USERID WHERE CARDID='" + CARDID + "'"; DataTable DT = new DataTable(); MySqlDataAdapter MDA = new MySqlDataAdapter(command.CommandText, conn); MDA.Fill(DT); if (DT != null && DT.Rows.Count > 0 && DT.Rows[0]["USERID"].ToString() != "") { userinfo.USERNAME = DT.Rows[0]["USERNAME"].ToString(); userinfo.ID = DT.Rows[0]["ID"].ToString(); userinfo.BIRTHDAY = DT.Rows[0]["BIRTHDAY"].ToString(); userinfo.GENDER = DT.Rows[0]["GENDER"].ToString(); userinfo.ISSUEDDATE = DT.Rows[0]["ISSUEDDATE"].ToString(); userinfo.PHONE = DT.Rows[0]["PHONE"].ToString(); userinfo.ECONTACT = DT.Rows[0]["ECONTACT"].ToString(); userinfo.EPHONE = DT.Rows[0]["EPHONE"].ToString(); userinfo.AREAID = DT.Rows[0]["AREAID"].ToString(); userinfo.LEVEL = DT.Rows[0]["LEVEL"].ToString(); userinfo.COL1 = DT.Rows[0]["COL1"].ToString(); userinfo.COL2 = DT.Rows[0]["COL2"].ToString(); userinfo.COL3 = DT.Rows[0]["COL3"].ToString(); } conn.Close(); } catch (Exception EX) { userinfo.STATUS = "500"; userinfo.MESSAGE = EX.Message; } return(userinfo); }
protected void OnAuthenticate(object sender, AuthenticateEventArgs e) { lblMessage.Text = ""; e.Authenticated = false; Login masterLogin = (Login)masterview.FindControl("masterLogin"); string userName = masterLogin.UserName.ToString(); string password = masterLogin.Password.ToString(); //if (Membership.ValidateUser(userName, password) && (userName.Equals("admin"))) //{ // masterLogin.DestinationPageUrl = "Default.aspx"; // Session["role"] = "Admin"; // e.Authenticated = true; //} //else //{ if (Membership.ValidateUser(userName, password)) { USERINFO userInfo = new USERINFO(); userInfo = USERINFOManager.GetUSERINFOByUserNameType("Agent", userName);//"Agent" is dami in database i have not use the if (userInfo != null) { Session["userType"] = userInfo.Type.ToString(); Session["userInfoID"] = userInfo.USERINFOID.ToString(); Session["userName"] = userInfo.UserName.ToString(); e.Authenticated = true; //if (userInfo.Agent_LocationID.ToString() == ddlAgent.SelectedItem.Value.ToString()) if (userInfo.Type == "Agent") { Session["aGENT"] = AGENTManager.GetAGENTByID(userInfo.Agent_LocationID); Session["role"] = "Agent"; } else if (userInfo.Type == "Location") { Session["lOCATION"] = LOCATIONGROUPManager.GetLOCATIONGROUPByID(userInfo.Agent_LocationID); Session["role"] = "Location"; } //Response.Redirect("Default.aspx"); masterLogin.DestinationPageUrl = "~/Default.aspx"; } else { lblMessage.Text = "Password incorrect!!!"; } } else { //Response.Redirect("~/Forgetpassword.aspx"); } //} }
public async Task <IHttpActionResult> GetUSERINFO(int id) { USERINFO userInfoObj = await db.USERINFOes.FindAsync(id); if (userInfoObj == null) { return(NotFound()); } return(Ok(userInfoObj)); }
public ActionResult EditUserInfo(USERINFO userInfo) { userInfo.MODIFIEDON = DateTime.Now; if (UserInfoService.EditEntity(userInfo)) { return(Content("ok")); } else { return(Content("no")); } }
private USERINFO GetUserByToken(string Token) { string[] arr = GetToKenInfo(Token); USERINFO user = null; if (arr != null) { string UserName = arr[0], Password = arr[1]; user = UserHelper.Login(UserName, Password); } return(user); }
public async Task <IHttpActionResult> PostUSERINFO(USERINFO uSERINFO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.USERINFOes.Add(uSERINFO); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = uSERINFO.ID }, uSERINFO)); }
public ReturnResult Logins(USERINFO user) { ReturnResult result = new ReturnResult(); USERINFO_BN userBN = new USERINFO_BN(); DataTable dt = userBN.GetUserList(user); if (dt.Rows.Count > 0) { result.success = true; result.data = dt; } return(result); }
public async Task <IHttpActionResult> DeleteUSERINFO(int id) { USERINFO uSERINFO = await db.USERINFOes.FindAsync(id); if (uSERINFO == null) { return(NotFound()); } db.USERINFOes.Remove(uSERINFO); await db.SaveChangesAsync(); return(Ok(uSERINFO)); }
public Task <int> updateUserInfo([FromUri] string oldUserName, [FromBody] USERINFO value) { //var data = db.USERINFOes.Where(s => s.LOGIN.UID == value.LOGIN.UID).Select(s => s).FirstOrDefault(); var data = db.USERINFOes.Where(s => s.USER_NAME == oldUserName).Select(s => s).FirstOrDefault(); if (data != null) { data.USER_NAME = value.USER_NAME; db.Entry(data).State = EntityState.Modified; return(db.SaveChangesAsync()); } return(Task.FromResult(0)); }
public string DelUser(string Token, string UserId) { USERINFO user = GetUserByToken(Token); // 登陆 if (null != user) { int count = UserHelper.DelUser(UserId); if (count > 0) { return("{\"State\":\"Success\"}"); } } return("{\"State\":\"Fail\", \"Message\":\"无此用户\"}"); }
public static void Query(USERINFO updateCheckbox, string queryUpdateCheckbox, SettingsDbContent nameofDatabaseSettings, string machineName) { SqlConnection con = new SqlConnection(string.Format(GlobalConstants.ConnectionStringToAx, machineName, nameofDatabaseSettings.NameOfDatabase)); con.Open(); SqlCommand cmd = new SqlCommand(string.Format(queryUpdateCheckbox, nameofDatabaseSettings.NameOfDatabase, updateCheckbox.NAME)); cmd.Connection = con; SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd); DataTable dbTable = new DataTable(); dataAdapter.Fill(dbTable); }
public string LoginWithToken(string Token) { var jss = new System.Web.Script.Serialization.JavaScriptSerializer(); jss.MaxJsonLength = Int32.MaxValue; USERINFO user = GetUserByToken(Token); if (null != user) { return("{\"State\":\"Success\", \"User\":" + jss.Serialize(user) + "}"); } return("{\"State\":\"Fail\"}"); }
public Frm_User_ViewModel(bool bCreateAccount) { userinfo = _Data.Inst.user; BtnEvent = new Command(BtnClickEvnet); ComboEvent = new Command(ComboChangedEvent); if (bCreateAccount) { LoginGridVisibility = Visibility.Visible; } else { RegisterGridVisibility = Visibility.Visible; BtnClickEvnet("btn_openregister"); } }
public string ChangePwd(string Token, string Password) { USERINFO user = GetUserByToken(Token); // 登陆 user.PASSWORD = Utils.md5Unicodebase64(Password); if (null != user) { int count = UserHelper.UpdateUser(user); if (count > 0) { return("{\"State\":\"Success\"}"); } } return("{\"State\":\"Fail\", \"Message\":\"无此用户\"}"); }
void ActualizaSocios(int i) { using (Model1 bd = new Model1()) { USERINFO user = new USERINFO(); user.Badgenumber = Convert.ToString(Dt.Rows[i]["pkMemberID"]); user.Name = Convert.ToString(Dt.Rows[i]["tName"]); user.lastname = Convert.ToString(Dt.Rows[i]["tLastname"]) + " " + Convert.ToString(Dt.Rows[i]["tLastname2"]); // user.BIRTHDAY = Convert.ToDateTime(Dt.Rows[i]["dBirthdate"]); user.email = Convert.ToString(Dt.Rows[i]["temail"]); user.Gender = Convert.ToString(Dt.Rows[i]["tgender"]); user.OPHONE = Convert.ToString(Dt.Rows[i]["tCellPhone"]); // user.PHOTO = FuncNet.ImageTobyteArray(PicDetalle.Image); user.DEFAULTDEPTID = 2; user.ATT = 1; user.INLATE = 1; user.OUTEARLY = 1; user.OVERTIME = 1; user.SEP = 1; user.HOLIDAY = 1; user.privilege = 0; user.AutoSchPlan = 1; user.MinAutoSchInterval = 24; user.RegisterOT = 1; user.status = 0; bd.USERINFO.Add(user); bd.SaveChanges(); var Resultado = (from dd in bd.Zk_Correlativos select dd).First(); int vCodId = Convert.ToInt32(Resultado.codId); Resultado.codId += 1; Resultado.Codigo += 1; bd.SaveChanges(); acc_levelset_emp level = new acc_levelset_emp(); level.employee_id = vCodId; level.acclevelset_id = 1; bd.acc_levelset_emp.Add(level); bd.SaveChanges(); } }
public EmpCheckMonth(USERINFO emp, AttControlClass attControl, GetDeptNameDelgate GetDeptName) { Emp = emp; DeptName = GetDeptName((short)emp.DEFAULTDEPTID); AttControl = attControl; GetDayType = AttControl.GetDayType; EmpNote = AttControl.GetEmpNoteInfoByByte(emp.Notes); if (EmpNote == null) { EmpNote = new EmpNoteInfo(); EmpNote.EmpPyName = PinyinHelper.PinyinString(emp.Name); EmpNote.IsHaveNote = true; AttControl.UpDateEmpNoteInfo(emp.USERID, EmpNote); } }
public async Task <IHttpActionResult> RegisterUser(RegisterModel registermodel) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var user = new USERINFO() { full_name = registermodel.FullName, UserName = registermodel.UserName, Email = registermodel.Email, EmailConfirmed = false, PhoneNumber = registermodel.MobileNo, }; IdentityResult result = await UserManager.CreateAsync(user, registermodel.Password); if (result.Succeeded) { /* * var provider = new DpapiDataProtectionProvider("TalentSpire"); * UserManager.EmailService = new EmailService(); * string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); * var newRouteValues = new System.Web.Routing.RouteValueDictionary(new { userId = user.Id, code = code }) * { * {"httproute", true} * }; * System.Web.Mvc.UrlHelper urlHelper = new System.Web.Mvc.UrlHelper(System.Web.HttpContext.Current.Request.RequestContext, System.Web.Routing.RouteTable.Routes); * var callbackUrl = urlHelper.Action("ConfirmEmail", "Account", newRouteValues, System.Web.HttpContext.Current.Request.Url.Scheme); * var body = CreateMailBody(callbackUrl, "Gabriel xavier"); * await UserManager.SendEmailAsync(user.Id, * "Welcome to Talentspire - Confirm account", body); * Uri locationHeader = new Uri(Url.Link("GetUserById", new { id = user.Id })); */ return(Ok()); } else { return(GetErrorResult(result)); } } catch (Exception ex) { return(BadRequest(ex.InnerException.ToString())); } }
public ActionResult ShowEditInfo() { decimal id = decimal.Parse(Request["id"]); USERINFO userInfo = UserInfoService.LoadEntities(c => c.ID == id).FirstOrDefault(); //使用匿名类,解决USERINFO中有集合类数据ICollection<R_USERINFO_ACTIONINFO>转换JSON失败的问题 var obj = new { userInfo.UNAME, userInfo.UPWD, userInfo.REMARK, userInfo.SORT, userInfo.DELFLAG, userInfo.SUBTIME }; return(Json(obj, JsonRequestBehavior.AllowGet)); }