public static bool UpdateUser(USERINFO Employee) { NSIADataContext dc = new NSIADataContext(); USERINFO emp = (from a in dc.USERINFOs where a.usernameid == Employee.usernameid select a).SingleOrDefault(); emp.NAME = Employee.NAME; emp.NAMELOCAL = Employee.NAMELOCAL; try { dc.SubmitChanges(); return(true); } catch (Exception e) { return(false); } }
//public static List<USERINFO> GetByRoleName(string RoleName) //{ // NSIADataContext dc = new NSIADataContext(); // aspnet_Role Role = (from a in dc.aspnet_Roles where a.LoweredRoleName.Equals(RoleName.ToLower()) select a).SingleOrDefault(); // List<aspnet_UsersInRole> Users = (from a in dc.aspnet_UsersInRoles where a.RoleId.Equals(Role.RoleId) select a).ToList(); // List<Employee> EmployeeList = new List<Employee>(); // foreach (aspnet_UsersInRole user in Users) // { // List<Employee> emp = (from a in dc.Employees where a.ID == user.UserId select a).ToList(); // EmployeeList.AddRange(emp); // } // return EmployeeList; //} //public static vEmployee GetUserViewByID(Guid UserID) //{ // NSIADataContext dc = new NSIADataContext(); // vEmployee Result = (from x in dc.vEmployees where x.UserId == UserID select x).SingleOrDefault(); // return Result; //} //public static List<vAdminMenu> GetMenusForRole(String[] roles) //{ // NSIADataContext dc = new NSIADataContext(); // List<vAdminMenu> Result = new List<vAdminMenu>(); // foreach (string role in roles) // { // List<vAdminMenu> menu = (from a in dc.vAdminMenus where a.LoweredRoleName.Equals(role) select a).ToList(); // Result.AddRange(menu); // } // return Result; //} public static Message SaveEmployee(USERINFO Data) { NSIADataContext dc = new NSIADataContext(); dc.USERINFOs.InsertOnSubmit(Data); try { dc.SubmitChanges(); return(new Message { ID = 1, Text = "کارمند جدید موفقانه ثبت سیستم گردید" }); } catch (Exception e) { return(new Message { ID = -1, Text = e.Message }); } }
protected void Save(object sender, EventArgs args) { MembershipCreateStatus result; MembershipUser CreatedUser = Membership.CreateUser(uxEmail.Text, uxPassword.Text, uxEmail.Text, null, null, true, out result); String MessageText = null; if (result.Equals(MembershipCreateStatus.Success)) { Roles.AddUserToRole(CreatedUser.UserName, uxRole.SelectedItem.Text); NSIADataContext dc = new NSIADataContext(); USERINFO user = (from a in dc.USERINFOs where a.USERID == Convert.ToInt32(uxEmployees.SelectedValue) select a).SingleOrDefault(); user.usernameid = new Guid(CreatedUser.ProviderUserKey.ToString()); Label ResultLabel = new Label(); try { dc.SubmitChanges(); uxEmail.Text = ""; uxRole.SelectedIndex = 0; uxPassword.Text = ""; uxConfirm.Text = ""; ResultLabel.Text = "کاربر جدید ایجاد گردید"; uxUserSucc.Controls.Add(ResultLabel); uxUserSucc.Visible = true; uxUserFail.Visible = false; } catch (Exception e) { Membership.DeleteUser(CreatedUser.UserName); ResultLabel.Text = e.Message; uxUserFail.Controls.Add(ResultLabel); uxUserFail.Visible = true; uxUserFail.Visible = false; } } else if (result.Equals(MembershipCreateStatus.DuplicateUserName)) { MessageText = "This login name already exist, please try again"; } else if (result.Equals(MembershipCreateStatus.DuplicateEmail)) { MessageText = "This email address already exist, please try another email."; } else if (result.Equals(MembershipCreateStatus.InvalidUserName)) { MessageText = "This login is invalid, please try another login name."; } else { MessageText = "Failed to create this account. Please Contact Development Team"; } string str = "<script>alert(\"ok\");</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", str, false); }