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); }
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 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 }); } }
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); } }
void LoadData() { uxTable.ClientIDMode = ClientIDMode.Static; NSIADataContext dc = new NSIADataContext(); List <vEmployeeName> llist = AttendanceBLL.GetEmployeesName(); uxEmployees.DataSource = llist; uxEmployees.DataBind(); //List<ExceptionType> elist = AttendanceBLL.GetExceptionTypeList("Leave"); //uxEmployees.DataSource = elist; //uxEmployees.DataBind(); //List<vUrgentTicket> ut = AttendanceBLL.GetAllTickets(); //ListsBLL.GenerateUrgentTicket(ut); //String output = ""; //int counter = 1; //foreach (vUrgentTicket m in ut) //{ // String label = ""; // if (m.WillReturn.Equals(true)) // { // label = "label bg-success-400"; // } // else // { // label = "label bg-danger"; // } // output = output + Temp.Replace("$Counter", counter.ToString()).Replace("$Name", m.NameLocal).Replace("$Date", m.TicketDate.ToShortDateString()).Replace("$OutTime", m.OutTime.ToString()).Replace("$Return", m.WillReturn.ToString()).Replace("$ReturnTime", m.ReturnTime.ToString()).Replace("$Note", m.Note); // counter++; //} //uxTable.InnerHtml = output; }
public static List <vUserAccount> GetUsersAccounts() { NSIADataContext dc = new NSIADataContext(); return(dc.vUserAccounts.ToList()); }
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); }