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);
}
