/// <summary>
/// btLogin_Click: DO LOGIN
/// </summary>
protected void Button1_Click(object sender, EventArgs e)
{
LoginDAO loginDAO = new LoginDAO();
LoginRole loginRole = new LoginRole();
loginRole = loginDAO.GetLoginRole(tbUserName.Text, tbPassword.Text);
if (loginRole.Role == string.Empty)
{
lbMessage.Text = "Username/password do not match. Try again.";
}
if (loginRole.Role != string.Empty)
{
Session["username"] = tbUserName.Text;
if (loginRole.Role == "administrator")
{
Session["administrator"] = tbUserName.Text;
}
lbMessage.Text = "";
Page.Response.Redirect("Default.aspx");
}
}
protected void btnRoleAssignSave_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null)
{
Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx");
}
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
try
{
LoginRole loginRole = new LoginRole();
loginRole.LoginID = Int32.Parse(ddlLogin.SelectedValue.Split('-')[0]);
loginRole.RowStatusID = 1;
loginRole.AddedDate = DateTime.Now;
loginRole.AddedBy = loginID;
loginRole.ModifyDate = DateTime.Now;
loginRole.ModifyBy = loginID;
bool resutl = LoginRoleManager.UpdateLoginRoleByIDs(loginRole, getSelectedRoleIds());
}
catch (Exception ex)
{ }
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null) { Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx"); }
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
LoginRole loginRole = new LoginRole();
loginRole = LoginRoleManager.GetLoginRoleByID(Int32.Parse(Request.QueryString["loginRoleID"]));
LoginRole tempLoginRole = new LoginRole();
tempLoginRole.LoginRoleID = loginRole.LoginRoleID;
tempLoginRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
tempLoginRole.LoginID = Int32.Parse(ddlLogin.SelectedValue);
tempLoginRole.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
tempLoginRole.AddedDate = DateTime.Now;
tempLoginRole.AddedBy = loginID;
tempLoginRole.ModifyDate = DateTime.Now;
tempLoginRole.ModifyBy = loginID;
bool result = LoginRoleManager.UpdateLoginRole(tempLoginRole);
Response.Redirect("AdminLoginRoleDisplay.aspx");
}
protected void btnRoleAssignSave_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null) { Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx"); }
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
try
{
LoginRole loginRole = new LoginRole();
loginRole.LoginID = Int32.Parse(ddlLogin.SelectedValue.Split('-')[0]);
loginRole.RowStatusID = 1;
loginRole.AddedDate = DateTime.Now;
loginRole.AddedBy = loginID;
loginRole.ModifyDate = DateTime.Now;
loginRole.ModifyBy = loginID;
bool resutl = LoginRoleManager.UpdateLoginRoleByIDs(loginRole,getSelectedRoleIds());
}
catch (Exception ex)
{ }
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null)
{
Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx");
}
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
LoginRole loginRole = new LoginRole();
loginRole = LoginRoleManager.GetLoginRoleByID(Int32.Parse(Request.QueryString["loginRoleID"]));
LoginRole tempLoginRole = new LoginRole();
tempLoginRole.LoginRoleID = loginRole.LoginRoleID;
tempLoginRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
tempLoginRole.LoginID = Int32.Parse(ddlLogin.SelectedValue);
tempLoginRole.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
tempLoginRole.AddedDate = DateTime.Now;
tempLoginRole.AddedBy = loginID;
tempLoginRole.ModifyDate = DateTime.Now;
tempLoginRole.ModifyBy = loginID;
bool result = LoginRoleManager.UpdateLoginRole(tempLoginRole);
Response.Redirect("AdminLoginRoleDisplay.aspx");
}
public Person()
{
//取得UserData
string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData;
SPerson Myperson = JsonConvert.DeserializeObject<SPerson>(strUserData);
_Account = Myperson.account;
_people_id = Myperson.people_id;
_Email = Myperson.email;
_Name = Myperson.name;
_Permission = Myperson.Permission;
_School_id = Myperson.School_id;
switch (Myperson.Role)
{
case "0":
_Role = LoginRole.Teacher;
break;
case "1":
_Role = LoginRole.Student;
break;
case "2":
_Role = LoginRole.Parent;
break;
case "3":
_Role = LoginRole.SchoolAdmin;
break;
case "4":
_Role = LoginRole.Administrator;
break;
}
}
public LoginRole GetLoginRole(string username, string password)
{
LoginRole loginRole = new LoginRole();
// ----------------------------------------------------------
// TO DO: The login role must be retrieved from the database
//
// The below is here for testing purposes ONLY.
// ----------------------------------------------------------
loginRole.Role = null;
IDataReader resultSet;
myDatabase.Open(myConnectionString);
String sqlText =
@"SELECT role
FROM Rider
WHERE username = '******' AND password = '******'"; //Correct?
resultSet = myDatabase.ExecuteQuery(sqlText);
while (resultSet.Read() == true)
{
loginRole.Role = (String)resultSet["role"]; //Correct pl0x?
}
resultSet.Close();
myDatabase.Close();
return(loginRole);
}
/// <summary>
/// Accessing user account by a valid username
/// </summary>
/// <param name="username">valid username</param>
/// <returns>user account if success, otherwise null</returns>
private static UserAccount GetUserAccount(string username)
{
if (username == null)
{
return(null);
}
LoginRole loginRole = (LoginRole)(int)(decimal)
DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
"Login_Role_ID", LoginTable, "Username = :username"),
new CommandParameter(":username", username)).Rows[0][0];
switch (loginRole)
{
case LoginRole.Student:
return(new Account.Student());
case LoginRole.Teacher:
return(new Account.Teacher());
case LoginRole.School:
return(new Account.School());
}
return(null);
}
// GET: Roles/Delete/5
public async Task <ActionResult> Delete(string id)
{
LoginRole role = await this._roleManager.FindByIdAsync(id);
var result = await this._roleManager.DeleteAsync(role);
return(RedirectToAction(nameof(List)));
}
public static LoginRole GetLoginRoleByID(int id)
{
LoginRole loginRole = new LoginRole();
SqlLoginRoleProvider sqlLoginRoleProvider = new SqlLoginRoleProvider();
loginRole = sqlLoginRoleProvider.GetLoginRoleByID(id);
return(loginRole);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
LoginRole loginRole = await db.LoginRoles.FindAsync(id);
db.LoginRoles.Remove(loginRole);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public LoginRole GetLoginRole(string username, string password)
{
LoginRole loginRole = new LoginRole();
IDataReader resultSet;
loginRole.Role = string.Empty;
try
{
myDatabase.Open(myConnectionString);
String sqlText = String.Format(@"Select role FROM Members Where username='******' AND password='******'");
resultSet = myDatabase.ExecuteQuery(sqlText);
if (resultSet.Read() == true)
{
loginRole.Role = (String)resultSet["role"];
return(loginRole);
}
else
{
return(loginRole);
}
}
catch (Exception)
{
return(loginRole);
}
finally
{
myDatabase.Close();
}
// ----------------------------------------------------------
// TO DO: The login role must be retrieved from the database
//
// The below is here for testing purposes ONLY.
// ----------------------------------------------------------
/*loginRole.Role = null;
*
* if (username == "user" && password == "user")
* {
* loginRole.Role = "user";
* }
*
* if (username == "admin" && password == "admin")
* {
* loginRole.Role = "administrator";
* }*/
}
public static Login AddNewLoginAndPerson(RegisterViewModel model, string emailConfirmToken)
{
var salt = UtilService.GeneratePassword(10, 5);
var passwordHash = AccountService.CreatePasswordHash(model.Password, salt);
try
{
var user = new Login
{
UserName = model.UserName,
Email = model.UserName,
PasswordHash = passwordHash,
SecurityStamp = salt,
EmailConfirmationToken = emailConfirmToken.ToString(),
EmailConfirmationTokenExpiryDate = DateTime.Now.AddHours(2).ToUniversalTime(), // FOR TESTING PUPROSE VALIDITY ONLY FOR 2HRS
EmailConfirmed = false,
CreatedBy = model.UserName,
CreatedOn = DateTime.Now,
IsActive = false
};
var person = new Person
{
FirstName = model.FirstName,
MiddleName = model.MiddleName,
LastName = model.LastName,
Login = user,
Address = new Address
{
CountryId = 1,
IsActive = true,
},
Address1 = new Address
{
CountryId = 1,
IsActive = true
},
UID = Guid.NewGuid(),
IsActive = true
};
var loginRole = new LoginRole
{
RoleId = model.RoleId,
IsActive = true,
PendingApproval = false
};
var result = AddNewUser(user, person, loginRole);
return(result.IsSuccess ? user : null);
}
catch (Exception ex)
{
return(null);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
LoginRole role = new LoginRole();
role.RoleName = txtRoleName.Text.Trim();
authService.myService.DaoInsert(role);
string JsStr = JavascriptUtil.AlertJSAndRedirect("新增成功", LIST_PAGE);
ScriptManager.RegisterClientScriptBlock(lblMsg, lblMsg.GetType(), "data", JsStr, false);
}
public ViewModelInformation RegisterStudent(ViewModelRegisterStudent viewModelRegisterStudent)
{
ViewModelInformation viewModelInformation = null;
try
{
viewModelInformation = new ViewModelInformation();
string js_code = viewModelRegisterStudent.Code.ToString();
string serviceAddress = "https://api.weixin.qq.com/sns/jscode2session?appid=wxece27e98fc59b527&secret=3efec00e6fe037602aeae3a317608942&js_code=" + js_code + "&grant_type=authorization_code";
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(serviceAddress);
request.Method = "GET";
request.ContentType = "text/html;charset=UTF-8";
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream myResponseStream = response.GetResponseStream();
StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.UTF8);
string retString = myStreamReader.ReadToEnd();
myStreamReader.Close();
myResponseStream.Close();
string key = "\"openid\":\"";
int startIndex = retString.IndexOf(key);
int endIndex = retString.IndexOf("\"}", startIndex);
string openid = retString.Substring(startIndex + key.Length, endIndex - startIndex - key.Length);
var user = new Student();
user.OpenId = openid;
user.StudentId = viewModelRegisterStudent.StudentId;
user.Name = viewModelRegisterStudent.Name;
user.ProfessionalClass = viewModelRegisterStudent.ProfessionalClass;
user.TotalSignIn = 0;
user.TotalAttendance = 0;
unitOfWork.StudentRepository.Insert(user); //增加新User
unitOfWork.Save();
var users = new Login();
users.OpenId = openid;
unitOfWork.LoginRepository.Insert(users);
unitOfWork.Save();
var sysRole = unitOfWork.SysRoleRepository.Get().Where(s => s.RoleName.Equals("学生")).FirstOrDefault(); //寻找用户所选择角色在UserRole里的实例，返回对象
var userRole = new LoginRole();
userRole.UserID = users.ID;
userRole.PrimaryRoleID = sysRole.ID;
userRole.ConfirmRoleID = 0;
unitOfWork.LoginRoleRepository.Insert(userRole);
unitOfWork.Save();
throw new Exception("提交成功");
}
catch (Exception ex)
{
viewModelInformation.Message = ex.Message;
return(viewModelInformation);
}
}
public async Task <ActionResult> Edit([Bind(Include = "Id,RoleType,RoleDescription,CreatedBy,ModifiedBy,CreatedOn,ModifiedOn")] LoginRole loginRole)
{
if (ModelState.IsValid)
{
db.Entry(loginRole).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(loginRole));
}
private void showLoginRoleData()
{
LoginRole loginRole = new LoginRole();
loginRole = LoginRoleManager.GetLoginRoleByID(Int32.Parse(Request.QueryString["loginRoleID"]));
ddlRole.SelectedValue = loginRole.RoleID.ToString();
ddlLogin.SelectedValue = loginRole.LoginID.ToString();
ddlRowStatus.SelectedValue = loginRole.RowStatusID.ToString();
txtAddedBy.Text = loginRole.AddedBy;
txtModifyDate.Text = loginRole.ModifyDate.ToString("dd MMM yyyy hh:mm tt");
txtModifyBy.Text = loginRole.ModifyBy;
}
protected void Page_Load(object sender, EventArgs e)
{
//可以在页面加载时设置页面的缓存为“SetNoStore()”，即无缓存
Response.Cache.SetNoStore();
//Session中存储的变量“IsSubmit”是标记是否提交成功的
if (Convert.ToBoolean(Session["IsSubmit"]))
{
//如果表单数据提交成功，就设“Session["IsSubmit"]”为false
Session["IsSubmit"] = false;
//显示提交成功信息
}
if (!Page.IsPostBack)
{
string url = SPWeb == null ? "test.aspx" : SPWeb.Url;
try
{
//专家评分操作
if (!IsWebAdmin && !LoginRole.Contains(3))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script defer>alert('没有权限');top.location.href='" + url + "'</script>");
return;
}
}
catch
{
}
DataTable dt = GetCurrentWorks.Tables[0];
if (dt.Rows.Count == 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script defer>alert('评分已经结束');top.location.href='" + url + "'</script>");
return;
}
ddlNumber.DataSource = dt.DefaultView;
ddlNumber.DataTextField = "Number";
ddlNumber.DataValueField = "WorksID";
ddlNumber.DataBind();
ddlNumber_SelectedIndexChanged(null, null);
}
ddlNumber.SelectedIndexChanged += new EventHandler(ddlNumber_SelectedIndexChanged);
btnSubmit.Click += new EventHandler(btnSubmit_Click);
if (HiddenField1.Value != "")
{
lblTotalScore.InnerText = HiddenField1.Value;
}
InitControl();
}
// GET: LoginRoles/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LoginRole loginRole = await db.LoginRoles.FindAsync(id);
if (loginRole == null)
{
return(HttpNotFound());
}
return(View(loginRole));
}
/// <summary>
/// Get headmaster name if assigned, otherwise "N/A"
/// </summary>
/// <returns>headmaster name if assigned, otherwise "N/A"</returns>
public string GetHeadmasterName()
{
DataTable dataTable = DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
"Headmaster_ID", LoginRole.ToString(), "ID = :ID"),
new CommandParameter(":ID", ID));
if (!dataTable.Rows[0].IsNull(0))
{
int headmasterID = (int)(decimal)dataTable.Rows[0][0];
return((string)DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
"Name", "Teacher", "ID = :headmasterID"),
new CommandParameter(":headmasterID", headmasterID)).Rows[0][0]);
}
return(EmptyField);
}
public LoginRole GetLoginRole(string username, string password)
{
LoginRole loginRole = new LoginRole();
loginRole.Role = null;
IDataReader resultSet;
try
{
myDatabase = new Database();
myDatabase.Open(myConnectionString);
String role = "";
String sqlText =
"SELECT role " +
"FROM Rider " +
"WHERE username = '******' AND password = '******'";
resultSet = myDatabase.ExecuteQuery(sqlText);
if (resultSet.Read() == true)
{
role = (String)resultSet["role"];
}
if (role == "user")
{
loginRole.Role = "user";
}
else if (role == "admin")
{
loginRole.Role = "administrator";
}
resultSet.Close();
return loginRole;
}
catch (Exception)
{
return null;
}
finally
{
myDatabase.Close();
}
}
public LoginRole GetLoginRole(string username, string password)
{
LoginRole loginRole = new LoginRole();
loginRole.Role = null;
IDataReader resultSet;
try
{
myDatabase = new Database();
myDatabase.Open(myConnectionString);
String role = "";
String sqlText =
"SELECT role " +
"FROM Rider " +
"WHERE username = '******' AND password = '******'";
resultSet = myDatabase.ExecuteQuery(sqlText);
if (resultSet.Read() == true)
{
role = (String)resultSet["role"];
}
if (role == "user")
{
loginRole.Role = "user";
}
else if (role == "admin")
{
loginRole.Role = "administrator";
}
resultSet.Close();
return(loginRole);
}
catch (Exception)
{
return(null);
}
finally
{
myDatabase.Close();
}
}
public bool UpdateLoginRoleByIDs(LoginRole loginRole,String RoleIDs)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateLoginRoleByIDs", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RoleIDs", SqlDbType.NVarChar).Value = RoleIDs;
cmd.Parameters.Add("@LoginID", SqlDbType.Int).Value = loginRole.LoginID;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = loginRole.RowStatusID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = loginRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = loginRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = loginRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = loginRole.ModifyBy;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
// GET: Home
public ActionResult Index()
{
if (!User.Identity.IsAuthenticated)
{
return(RedirectToRoute(new { controller = "Login", action = "Index" }));
}
else
{
if (Session["UserInfo"] == null || Session["LoginRole"] == null || Session["ControlRoles"] == null)
{
return(RedirectToRoute(new { controller = "Login", action = "Index" }));
}
User_Info user = (User_Info)Session["UserInfo"];
LoginRole role = (LoginRole)Session["LoginRole"];
int id = Common.PageValidate.FilterParam(User.Identity.Name);
var userInfo = (from u in db.User_Info
where u.user_id == id
select new UserModel
{
name = u.real_name,
times = u.user_login_times
}).FirstOrDefault();
var loginInfos = (from l in db.Sys_Log
where l.log_user_id == id
select l
);
if (loginInfos.Count() <= 1)
{
userInfo.lastIp = "无";
userInfo.lastTime = "无";
}
else
{
var loginInfo = loginInfos.OrderByDescending(x => x.log_time).Skip(1).FirstOrDefault();
userInfo.lastIp = loginInfo.log_ip;
userInfo.lastTime = loginInfo.log_time.ToString("yyyy年MM月dd日 HH时mm分");
}
userInfo.roleName = role.roleName;
userInfo.name = AESEncrypt.Decrypt(userInfo.name);
//如果是有批复权限的，显示待批复列表
return(View(userInfo));
}
}
public int InsertLoginRole(LoginRole loginRole)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_InsertLoginRole", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@LoginRoleID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = loginRole.RoleID;
cmd.Parameters.Add("@LoginID", SqlDbType.Int).Value = loginRole.LoginID;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = loginRole.RowStatusID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = loginRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = loginRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = loginRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = loginRole.ModifyBy;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@LoginRoleID"].Value;
}
}
public async Task <ActionResult> Create(LoginRole role)
{
try
{
var result = await this._roleManager.CreateAsync(role);
if (result.Succeeded)
{
return(RedirectToAction(nameof(List)));
}
else
{
return(View());
}
}
catch
{
return(View());
}
}
public LoginRole GetLoginRoleFromReader(IDataReader reader)
{
try
{
LoginRole loginRole = new LoginRole
(
(int)reader["LoginRoleID"],
(int)reader["RoleID"],
(int)reader["LoginID"],
(int)reader["RowStatusID"],
(DateTime)reader["AddedDate"],
reader["AddedBy"].ToString(),
(DateTime)reader["ModifyDate"],
reader["ModifyBy"].ToString()
);
return loginRole;
}
catch(Exception ex)
{
return null;
}
}
public static string GetLoginRole(LoginRole role)
{
switch (role)
{
case LoginRole.SuperAdmin:
return "sa";
case LoginRole.Agent:
return "ag";
case LoginRole.Tenant:
return "t";
case LoginRole.Landlord:
return "l";
case LoginRole.None:
return "";
case LoginRole.Owner:
return "o";
case LoginRole.Admin:
return "a";
default:
return "";
}
}
protected UserAccount(string username)
{
if (username == null)
{
throw new AccessViolationException(ErrorStringNoLogin);
}
LoginRole = (LoginRole)(int)(decimal)DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
"Login_Role_ID", LoginTable, "Username = :username"),
new CommandParameter(":username", username)).Rows[0][0];
LoginID = (int)(decimal)DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
"ID", LoginTable, "Username = :username"),
new CommandParameter(":username", username)).Rows[0][0];
ID = (int)(decimal)DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
"ID", LoginRole.ToString(), "Login_ID = :LoginID"),
new CommandParameter(":LoginID", LoginID)).Rows[0][0];
Name = (string)DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
"Name", LoginRole.ToString(), "ID = :ID"),
new CommandParameter(":ID", ID)).Rows[0][0];
}
public static ServiceResponseResult CreateTenantAccount(AddTenantToPropertyModel model, Login creartor, string temPass)
{
using (var db = new KeysEntities())
{
var salt = UtilService.GeneratePassword(10, 5);
//var temPass = UtilService.GeneraterRandomKey(8);
var passwordHash = AccountService.CreatePasswordHash(temPass, salt);
var login = new Login
{
UserName = model.TenantEmail,
Email = model.TenantEmail,
PasswordHash = passwordHash,
SecurityStamp = salt,
EmailConfirmed = true,
CreatedBy = creartor.Email,
CreatedOn = DateTime.Now,
IsActive = true
};
var person = new Person
{
FirstName = model.FirstName,
LastName = model.LastName,
Login = login,
Address = new Address
{
CountryId = 1,
IsActive = true,
},
Address1 = new Address
{
CountryId = 1,
IsActive = true
},
UID = Guid.NewGuid(),
IsActive = true
};
var loginRole = new LoginRole
{
RoleId = 5,
IsActive = true,
PendingApproval = false
};
db.Login.Add(login);
person.Login = login;
db.Person.Add(person);
loginRole.Person = person;
db.LoginRole.Add(loginRole);
var tenant = new Tenant
{
Person = person,
IsCompletedPersonalProfile = false,
HasProofOfIdentity = false,
CreatedOn = DateTime.UtcNow,
CreatedBy = creartor.Id,
UpdatedOn = DateTime.UtcNow,
IsActive = true,
Address = new Address
{
CountryId = 1,
IsActive = true,
}
};
db.Tenant.Add(tenant);
try
{
db.SaveChanges();
return(new ServiceResponseResult {
IsSuccess = true, NewObject = login
});
}
catch (Exception e)
{
return(new ServiceResponseResult {
IsSuccess = false
});
}
}
}
private void initAuthData()
{
LoginUser user = new LoginUser();
LoginRole role = new LoginRole();
user.UserId = "admin";
user.Password = EncryptUtil.GetMD5(PASS_WORD);
user.Name = "系統管理者";
user.IsEnable = true;
user.Email = "*****@*****.**";
myService.DaoInsert(user);
role.RoleName = "系統管理者";
myService.DaoInsert(role);
List<LoginUser> userList = new List<LoginUser>();
List<LoginRole> roleList = new List<LoginRole>();
roleList.Add(role);
user.BelongRoles = new List<LoginRole>();
role.BelongUsers = userList;
user.BelongRoles = roleList;
myService.DaoUpdate(role);
myService.DaoUpdate(user);
lblStatus.Text = "初始化資料成功!!";
}
public static bool UpdateLoginRole(LoginRole loginRole)
{
SqlLoginRoleProvider sqlLoginRoleProvider = new SqlLoginRoleProvider();
return(sqlLoginRoleProvider.UpdateLoginRole(loginRole));
}
public static bool UpdateLoginRoleByIDs(LoginRole loginRole, string RoleIDs)
{
SqlLoginRoleProvider sqlLoginRoleProvider = new SqlLoginRoleProvider();
return(sqlLoginRoleProvider.UpdateLoginRoleByIDs(loginRole, RoleIDs));
}
private void showLoginRoleData()
{
LoginRole loginRole = new LoginRole();
loginRole = LoginRoleManager.GetLoginRoleByID(Int32.Parse(Request.QueryString["loginRoleID"]));
ddlRole.SelectedValue = loginRole.RoleID.ToString();
ddlLogin.SelectedValue = loginRole.LoginID.ToString();
ddlRowStatus.SelectedValue = loginRole.RowStatusID.ToString();
txtAddedBy.Text = loginRole.AddedBy;
txtModifyDate.Text = loginRole.ModifyDate.ToString("dd MMM yyyy hh:mm tt");
txtModifyBy.Text = loginRole.ModifyBy;
}
public LoginRole GetLoginRoleFromReader(IDataReader reader)
{
try
{
LoginRole loginRole = new LoginRole
(
(int)reader["LoginRoleID"],
(int)reader["RoleID"],
(int)reader["LoginID"],
(int)reader["RowStatusID"],
(DateTime)reader["AddedDate"],
reader["AddedBy"].ToString(),
(DateTime)reader["ModifyDate"],
reader["ModifyBy"].ToString()
);
return loginRole;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateLoginRoleByIDs(LoginRole loginRole,String RoleIDs)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateLoginRoleByIDs", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RoleIDs", SqlDbType.NVarChar).Value = RoleIDs;
cmd.Parameters.Add("@LoginID", SqlDbType.Int).Value = loginRole.LoginID;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = loginRole.RowStatusID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = loginRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = loginRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = loginRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = loginRole.ModifyBy;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertLoginRole(LoginRole loginRole)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_InsertLoginRole", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@LoginRoleID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = loginRole.RoleID;
cmd.Parameters.Add("@LoginID", SqlDbType.Int).Value = loginRole.LoginID;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = loginRole.RowStatusID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = loginRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = loginRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = loginRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = loginRole.ModifyBy;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@LoginRoleID"].Value;
}
}
public static ServiceResponseResult AddNewRoleToUser(int roleId, Person person)
{
using (var db = new KeysEntities())
{
var login = db.Login.FirstOrDefault(x => x.Id == person.Id);
var loginRole = new LoginRole
{
RoleId = roleId,
PersonId = person.Id,
IsActive = true,
PendingApproval = false
};
db.LoginRole.Add(loginRole);
db.SaveChanges();
switch (roleId)
{
case 4:
var owner = new Owners {
Person = person
};
db.Owners.Add(owner);
break;
case 5:
var tenant = new Tenant
{
Id = person.Id,
IsCompletedPersonalProfile = false,
HasProofOfIdentity = false,
CreatedOn = DateTime.UtcNow,
CreatedBy = person.Id,
UpdatedOn = DateTime.UtcNow,
IsActive = true,
Address = new Address
{
CountryId = 1,
IsActive = true,
}
};
db.Tenant.Add(tenant);
break;
case 6:
var com = new Company
{
UpdatedBy = login.Email,
CreatedOn = DateTime.UtcNow,
CreatedBy = login.Email,
UpdatedOn = DateTime.UtcNow,
IsActive = true,
Address = new Address //Bug Fix #2075
{
CountryId = 1,
IsActive = true
},
Address1 = new Address //Bug Fix #2075
{
CountryId = 1,
IsActive = true
}
};
var sp = new ServiceProvider {
Id = person.Id, Company = com, IsProfileComplete = false
};
db.ServiceProvider.Add(sp);
break;
}
try
{
db.SaveChanges();
return(new ServiceResponseResult {
IsSuccess = true
});
}
catch (Exception e)
{
return(new ServiceResponseResult {
IsSuccess = false
});
}
}
}
public static ServiceResponseResult AddNewUser(Login login, Person person, LoginRole loginRole)
{
using (var db = new KeysEntities())
{
try
{
db.Login.Add(login);
//person.LoginId = login.Id;
person.Id = login.Id;
db.Person.Add(person);
loginRole.PersonId = person.Id;
db.LoginRole.Add(loginRole);
switch (loginRole.RoleId)
{
case 4:
var owner = new Owners {
Person = person
};
db.Owners.Add(owner);
break;
case 5:
var tenant = new Tenant
{
Person = person,
IsCompletedPersonalProfile = false,
HasProofOfIdentity = false,
CreatedOn = DateTime.UtcNow,
CreatedBy = login.Id,
UpdatedOn = DateTime.UtcNow,
IsActive = true,
Address = new Address
{
CountryId = 1,
IsActive = true,
}
};
db.Tenant.Add(tenant);
break;
case 6:
var com = new Company
{
UpdatedBy = login.Email,
CreatedOn = DateTime.UtcNow,
CreatedBy = login.Email,
UpdatedOn = DateTime.UtcNow,
IsActive = true,
Address = new Address //Bug Fix #2075
{
CountryId = 1,
IsActive = true
},
Address1 = new Address //Bug Fix #2075
{
CountryId = 1,
IsActive = true
}
};
var sp = new ServiceProvider {
Person = person, Company = com, IsProfileComplete = false
};
db.ServiceProvider.Add(sp);
break;
}
db.SaveChanges();
return(new ServiceResponseResult {
IsSuccess = true
});
}
catch (Exception ex)
{
return(new ServiceResponseResult {
IsSuccess = false
});
}
}
}
public static int InsertLoginRole(LoginRole loginRole)
{
SqlLoginRoleProvider sqlLoginRoleProvider = new SqlLoginRoleProvider();
return(sqlLoginRoleProvider.InsertLoginRole(loginRole));
}
public static void Initialize(WorkDbContext context)
{
context.Database.EnsureDeleted();
context.Database.Migrate();
//if (context.Companies.Any() && context.Employees.Any() && context.Users.Any() && context.TokenModels.Any())
//{
// return;
//}
var companies = new Company[]
{
new Company
{
Id = Guid.Parse("620f23d6-6a9c-43b9-a70a-c93cf0096ee5"),
Name = "Microsoft",
Introduction = "Great Company"
},
new Company
{
Id = Guid.Parse("f6ee3f75-8659-4ab1-a1a3-d799b8a8f70c"),
Name = "Google",
Introduction = "404 Company"
},
new Company
{
Id = Guid.Parse("28e2b431-f8b3-4fad-af74-602278ebda00"),
Name = "Alipapa",
Introduction = "FuBao Company"
},
new Company
{
Id = Guid.Parse("aeb13c79-f6d4-4d23-b06b-01d550e2acc6"),
Name = "Face Book",
Introduction = "Freedown Company"
},
new Company
{
Id = Guid.Parse("290d2019-1a83-4afd-b370-7e19f8965c92"),
Name = "BaiDu",
Introduction = "Ads Company"
},
new Company
{
Id = Guid.Parse("8bc932ea-9f54-4da2-a7a1-2e8045a8a5cf"),
Name = "Wang Yi",
Introduction = "Freedown Company"
},
new Company
{
Id = Guid.Parse("6db2af13-fce8-4731-9d8f-92abf87a55b0"),
Name = "JingDong",
Introduction = "Fast Company"
},
new Company
{
Id = Guid.Parse("412300f6-a923-45ee-92c1-581fcf93c21a"),
Name = "Xiao Mi",
Introduction = "Smart Company"
},
new Company
{
Id = Guid.Parse("6b48611b-f96c-4527-aebd-db96e7b02146"),
Name = "Bilibili",
Introduction = "Acg Company"
},
new Company
{
Id = Guid.Parse("f69e131f-1cfb-4e26-8661-79ad9be75ace"),
Name = "Zhang Zi Dao",
Introduction = "Faker Company"
}
};
foreach (var i in companies)
{
context.Companies.Add(i);
}
context.SaveChanges();
var employees = new Employee[]
{
new Employee
{
Id = Guid.Parse("347e2607-04ba-43de-a8df-07154856f824"),
CompanyId = Guid.Parse("620f23d6-6a9c-43b9-a70a-c93cf0096ee5"),
EmployeeNo = "A001",
FirstName = "张",
LastName = "一",
Gender = Gender.男,
BirthOfDate = new DateTime(1990, 01, 01)
},
new Employee
{
Id = Guid.Parse("15422d65-3426-4ad0-a815-ce70f4ba5174"),
CompanyId = Guid.Parse("620f23d6-6a9c-43b9-a70a-c93cf0096ee5"),
EmployeeNo = "A002",
FirstName = "张",
LastName = "二",
Gender = Gender.男,
BirthOfDate = new DateTime(1991, 01, 01)
},
new Employee
{
Id = Guid.Parse("d454a121-7f98-4641-a996-10f6a02701d8"),
CompanyId = Guid.Parse("620f23d6-6a9c-43b9-a70a-c93cf0096ee5"),
EmployeeNo = "A003",
FirstName = "张",
LastName = "三",
Gender = Gender.男,
BirthOfDate = new DateTime(1992, 01, 01)
},
new Employee
{
Id = Guid.Parse("72562ee7-b32b-435b-b91f-c65e487a487d"),
CompanyId = Guid.Parse("f6ee3f75-8659-4ab1-a1a3-d799b8a8f70c"),
EmployeeNo = "B001",
FirstName = "王",
LastName = "一",
Gender = Gender.男,
BirthOfDate = new DateTime(1993, 01, 01)
},
new Employee
{
Id = Guid.Parse("0f33e571-69f8-45c4-96d7-734dd775ded4"),
CompanyId = Guid.Parse("f6ee3f75-8659-4ab1-a1a3-d799b8a8f70c"),
EmployeeNo = "B002",
FirstName = "王",
LastName = "二",
Gender = Gender.男,
BirthOfDate = new DateTime(1994, 01, 01)
},
new Employee
{
Id = Guid.Parse("9daced10-9473-47aa-bd84-f5f52da7d4a3"),
CompanyId = Guid.Parse("f6ee3f75-8659-4ab1-a1a3-d799b8a8f70c"),
EmployeeNo = "B003",
FirstName = "王",
LastName = "三",
Gender = Gender.男,
BirthOfDate = new DateTime(1995, 01, 01)
},
new Employee
{
Id = Guid.Parse("c9ccdadd-325f-4f84-8cec-b668a76047e8"),
CompanyId = Guid.Parse("28e2b431-f8b3-4fad-af74-602278ebda00"),
EmployeeNo = "C001",
FirstName = "李",
LastName = "一",
Gender = Gender.女,
BirthOfDate = new DateTime(1996, 01, 01)
},
new Employee
{
Id = Guid.Parse("8b623d8f-3ab9-4941-8625-8fa8405175ef"),
CompanyId = Guid.Parse("28e2b431-f8b3-4fad-af74-602278ebda00"),
EmployeeNo = "C002",
FirstName = "李",
LastName = "二",
Gender = Gender.女,
BirthOfDate = new DateTime(1997, 01, 01)
},
new Employee
{
Id = Guid.Parse("3006d592-2fa2-41cf-ba51-9a4f7e705eac"),
CompanyId = Guid.Parse("28e2b431-f8b3-4fad-af74-602278ebda00"),
EmployeeNo = "C003",
FirstName = "李",
LastName = "三",
Gender = Gender.女,
BirthOfDate = new DateTime(1998, 01, 01)
}
};
foreach (var i in employees)
{
context.Employees.Add(i);
}
context.SaveChanges();
var users = new User[]
{
new User
{
Id = 1,
UserName = "******",
PassWord = "******"
},
new User
{
Id = 2,
UserName = "******",
PassWord = "******"
},
new User
{
Id = 3,
UserName = "******",
PassWord = "******"
}
};
foreach (var i in users)
{
context.Users.Add(i);
}
context.Database.OpenConnection();
try
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Users ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Users OFF");
}
finally
{
context.Database.CloseConnection();
}
//context.SaveChanges();
var tokenModels = new TokenModel[]
{
new TokenModel
{
Uid = 1,
Uname = "The Giao",
Role = Role.Admin,
UserId = 1
},
new TokenModel
{
Uid = 2,
Uname = "The Shy",
Role = Role.Admin,
UserId = 2
},
new TokenModel
{
Uid = 3,
Uname = "The Bug",
Role = Role.Leader,
UserId = 3
}
};
foreach (var i in tokenModels)
{
context.TokenModels.Add(i);
}
context.Database.OpenConnection();
try
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.TokenModels ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.TokenModels OFF");
}
finally
{
context.Database.CloseConnection();
}
//context.SaveChanges();
var loginRoles = new LoginRole[]
{
new LoginRole
{
Id = 1,
RoleName = Role.Admin,
Discription = "拥有一切权限"
},
new LoginRole
{
Id = 2,
RoleName = Role.Leader,
Discription = "拥有对Employee的权限"
}
};
foreach (var i in loginRoles)
{
context.LoginRoles.Add(i);
}
context.Database.OpenConnection();
try
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.LoginRoles ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.LoginRoles OFF");
}
finally
{
context.Database.CloseConnection();
}
var urls = new Url[]
{
new Url
{
Id = 1,
LinkUrl = "/api/companies",
RoleId = 1
},
new Url
{
Id = 2,
LinkUrl = "/api/text",
RoleId = 2
}
};
foreach (var i in urls)
{
context.Urls.Add(i);
}
context.Database.OpenConnection();
try
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Urls ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Urls OFF");
}
finally
{
context.Database.CloseConnection();
}
}
