protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (string.IsNullOrWhiteSpace(Convert.ToString(Request.QueryString["userid"].ToString())) ||
string.IsNullOrWhiteSpace(Convert.ToString(Request.QueryString["Key"].ToString())))
{
divConfirm.Visible = false;
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CallJS", "alert('Network Problem Please Try Again later');", true);
return;
}
UserBE userInfo = new UserBE();
UserBAL userBAL = new UserBAL();
DataSet ds = userBAL.CheckConfirmationRequest(Request.QueryString["userid"].ToString(), Request.QueryString["Key"].ToString());
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows[0][0].ToString().Equals("No"))
{
divConfirm.Visible = false;
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CallJS", "alert('You are already verified');", true);
}
}
}
}
}
/// <summary>
/// To check user is authorised or not from database
/// </summary>
/// <returns></returns>
public DataTable GetUserDetails()
{
UserBAL UserBAL = new UserBAL();
DataTable UserTable = new DataTable();
try
{
UserTable = UserBAL.SelectUserName(LoginUserName, LoginUserID, Ret);
if (UserTable.Rows.Count > 0)
{
LoginUser = Convert.ToInt16(UserTable.Rows[0][0]);
LogedInUser = UserTable.Rows[0][5].ToString();
ValidUser = "******";
}
else
{
ValidUser = "******";
}
}
catch
{
}
finally
{
UserBAL = null;
}
return UserTable;
}
public AuthUserStore()
{
if (userBAL == null)
{
userBAL = new UserBAL();
}
}
public frmUserPassword()
{
InitializeComponent();
userbal = new UserBAL();
err = new ErrorProviderExtended();
current_user = new tbl_000_USER();
}
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (UserBAL userBAL = new UserBAL(ContextInfo))
{
userBAL.Login(model);
}
if (model.HasErrorByType())
{
return(View(model));
}
ApplicationUser user = await UserManager.FindByNameAsync(model.UserName);
await SignInManager.SignInAsync(user, model.RememberMe, model.RememberMe);
System.Security.Principal.GenericIdentity genericIdentity = new System.Security.Principal.GenericIdentity(user.UserName, "ApplicationCookie");
string[] roles = user.Roles.Select(x => x.RoleId).ToArray();
System.Security.Principal.GenericPrincipal genericPrincipal = new GenericPrincipal(genericIdentity, user.Roles.Select(x => x.RoleId).ToArray());
return(RedirectToLocal(returnUrl, genericPrincipal));
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
//var result = await SignInManager.PasswordSignInAsync(model.UserName, model.Password, model.RememberMe, shouldLockout: false);
}
private void fillGridViewEmployee()
{
DataTable dtUser = new DataTable();
UserBAL balUser = new UserBAL();
UserENT entUser = new UserENT();
entUser = balUser.SelectUserCount();
lblTotalEmployee.Text = entUser.Usercount.ToString();
lblPendingLeave.Text = Session["PendingLeaveRequest"].ToString();
dtUser = balUser.SelectAll();
if (dtUser != null && dtUser.Rows.Count > 0)
{
gvEmployeeDetails.DataSource = dtUser;
gvEmployeeDetails.DataBind();
}
else if (dtUser.Rows.Count < 1)
{
gvEmployeeDetails.DataSource = null;
gvEmployeeDetails.DataBind();
PanelGV.Visible = false;
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balUser.Message;
}
}
public void GetDocument()
{
DataTable document = new DataTable();
if (ViewState["DocumentDS"] != null)
{
document = (DataTable)ViewState["DocumentDS"];
}
else
{
UserBAL doc = new UserBAL();
document = doc.UserDocument(false);
//grdDocument.DataSource = document;
//grdDocument.DataBind();
ViewState["DocumentDS"] = document;
}
String sort = String.Empty;
if (null != sortExpression && String.Empty != sortExpression)
{
sort = String.Format("{0} {1}", sortExpression, (sortDirection == SortDirection.Descending) ? "DESC" : "ASC");
}
DataView dv = new DataView(document, String.Empty, sort, DataViewRowState.CurrentRows);
grdDocument.DataSource = dv;
grdDocument.DataBind();
}
private void mbtnSave_Click(object sender, EventArgs e)
{
string msg = "";
switch (MyState)
{
case FormState.Add:
case FormState.Edit:
case FormState.Delete:
msg = "save";
if (MyState == FormState.Edit)
{
msg = "update";
}
if (MyState == FormState.Delete)
{
msg = "delete";
}
if (MessageHelpers.ShowQuestion("Are you sure you want to " + msg + " record?") == System.Windows.Forms.DialogResult.Yes)
{
SaveRecord();
}
break;
case FormState.View:
MyState = FormState.Edit;
username = usr.Username;
userbal = new UserBAL();
Init_Form();
break;
}
}
private void FillGridViewLeave()
{
LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
DataTable dtLeaveStatus = new DataTable();
UserBAL balUser = new UserBAL();
UserENT entUser = new UserENT();
entUser = balUser.SelectUserCount();
lblTotalEmployee.Text = entUser.Usercount.ToString();
dtLeaveStatus = balLeaveStatus.SelectAll();
Session["PendingLeaveRequest"] = dtLeaveStatus.Rows.Count;
if (dtLeaveStatus != null && dtLeaveStatus.Rows.Count > 0)
{
lblPendingLeave.Text = dtLeaveStatus.Rows.Count.ToString();
gvLeaveStatus.DataSource = dtLeaveStatus;
gvLeaveStatus.DataBind();
}
else if (dtLeaveStatus.Rows.Count < 1)
{
lblPendingLeave.Text = 0.ToString();
gvLeaveStatus.DataSource = null;
gvLeaveStatus.DataBind();
PanelGV.Visible = false;
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balLeaveStatus.Message;
}
}
public ActionResult Messages()
{
UserBAL _bal = new UserBAL();
IEnumerable <User> doctors = _bal.GetActiveDoctors();
return(View(doctors));
}
private void SerchData(int UserId)
{
UserBAL userBal = new UserBAL();
UserDom user = new UserDom();
user = userBal.ReadUserById(UserId);
lblUserName.Text = user.FirstName + " " + user.MiddleName + " " + user.LastName;
hdfldUserId.Value = user.UserId.ToString();
List <UserTaskMaping> lst = new List <UserTaskMaping>();
lst = userBal.ReadUserTask(UserId);
BindCheckBoxList();
//foreach (ListItem item in chbxUserTask.Items)
//{
// item.Selected = false;
//}
foreach (ListItem item in chbxUserTask.Items)
{
foreach (UserTaskMaping pop in lst)
{
if (Convert.ToInt32(item.Value) == pop.MetadataUserTask.Id)
{
item.Selected = true;
}
}
}
}
private UserDom ReadUserByLoginId(string loginId)
{
UserBAL userBal = new UserBAL();
UserDom user = userBal.ReadUserByLoginId(loginId);
return(user);
}
public AccountController(ApplicationUserManager userManager, ApplicationSignInManager signInManager, UserBAL userBAL, TokenBAL tokenBAL)
{
UserManager = userManager;
SignInManager = signInManager;
_userBAL = userBAL;
_tokenBAL = tokenBAL;
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
string strcolumn = dataGridView1.Columns[e.ColumnIndex].DataPropertyName;//获取列datapropertyname
if (e.RowIndex.ToString() != "-1")
{
if (Convert.ToBoolean(dataGridView1.Rows[e.RowIndex].Cells[0].Value) == false)
{
string strrow = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); //获取焦点触发行的第二个值
string name = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); //获取焦点触发行的第san个值
string value = dataGridView1.CurrentCell.Value.ToString();
if (strcolumn == "brithday" || strcolumn == "employdate" || strcolumn == "workdate")
{
DateTime t = DateTime.Parse(value);
bool flag = new UserBAL().Update2(strcolumn, t, strrow, name);
cc++;
}
else
{
bool flag = new UserBAL().Update(strcolumn, value, strrow, name);
cc++;
}
}
}
else
{
}
}
private void button4_Click(object sender, EventArgs e)
{
int hs = dataGridView1.Rows.Count;
if (hs > count)
{
for (int i = count - 1; i < hs - 1; i++)
{
System.DateTime d1 = System.DateTime.Now;
System.DateTime d2 = System.DateTime.Now;
System.DateTime d3 = System.DateTime.Now;
int useId = Convert.ToInt32(this.dataGridView1.Rows[i].Cells[1].Value.ToString()); //获取焦点触发行的第二个值
string name = dataGridView1.Rows[i].Cells["Column3"].Value.ToString(); //获取焦点触发行的第san个值
string bday = dataGridView1.Rows[i].Cells["Column6"].Value.ToString();
try
{
d1 = DateTime.Parse(bday);
}
catch
{
d1 = System.DateTime.Now;
}
string sex = dataGridView1.Rows[i].Cells["Column1"].Value.ToString();
string ori = dataGridView1.Rows[i].Cells["Column7"].Value.ToString();
string mar = dataGridView1.Rows[i].Cells["Column8"].Value.ToString();
string emday = dataGridView1.Rows[i].Cells["Column9"].Value.ToString();
try
{
d2 = DateTime.Parse(emday);
}
catch
{
d2 = System.DateTime.Now;
}
string hrole = dataGridView1.Rows[i].Cells["Column10"].Value.ToString();
string nrow = dataGridView1.Rows[i].Cells["Column11"].Value.ToString();
string workday = dataGridView1.Rows[i].Cells["Column12"].Value.ToString();
try
{
d3 = DateTime.Parse(workday);
}
catch
{
d3 = System.DateTime.Now;
}
string tel = dataGridView1.Rows[i].Cells["Column2"].Value.ToString();
string mail = dataGridView1.Rows[i].Cells["Column5"].Value.ToString();
string wd = dataGridView1.Rows[i].Cells["Column13"].Value.ToString();
string card = dataGridView1.Rows[i].Cells["Column14"].Value.ToString();
bool flag = new UserBAL().Insert(useId, name, d1, sex, ori, mar, d2, hrole, nrow, d3, tel, mail, wd, card);
if (flag)
{
MessageBox.Show("添加成功！");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserBAL skillList = new UserBAL();
gridViewSkills.DataSource = skillList.ListSkillsBal();
gridViewSkills.DataBind();
}
public void GetTeacherData()
{
UserBO teacherDetails = new UserBO
{
UserId = Request.QueryString["resource_value"]
};
UserBAL _teacherDetails = new UserBAL();
DataTable details = _teacherDetails.TeacherDetailsDisplay(teacherDetails);
grdTeacher.DataSource = details;
grdTeacher.DataBind();
UserBO schedule = new UserBO
{
UserId = Request.QueryString["resource_value"]
};
UserBAL scheduleList = new UserBAL();
grdTeacherSchedule.DataSource = scheduleList.ScheduleTeacher(schedule);
grdTeacherSchedule.DataBind();
grdTSchedule.DataSource = scheduleList.ScheduleTeacher(schedule);
grdTSchedule.DataBind();
//grdTeacherScheduleEn.DataSource = scheduleList.ScheduleTeacher(schedule);
//grdTeacherScheduleEn.DataBind();
}
protected void btnUpdateProfileImage_Click(object sender, EventArgs e)
{
UserENT entUser = new UserENT();
entUser.UserID = Convert.ToInt32(Session["UserID"].ToString());
if (fuProfile.HasFiles)
{
string strPath = "~/UserImages/";
string strPhysicalPath = "";
strPhysicalPath = Server.MapPath(strPath);
strPhysicalPath += fuProfile.FileName;
strPath += fuProfile.FileName;
if (File.Exists(strPhysicalPath))
{
File.Delete(strPhysicalPath);
}
fuProfile.SaveAs(strPhysicalPath);
entUser.UserProfileImage = strPath;
Session["UserProfileImage"] = strPath;
}
UserBAL balUser = new UserBAL();
if (balUser.UpdateProfile(entUser))
{
Response.Redirect("~/AdminPanel/Profile/Profile.aspx");
}
else
{
lblMessageProfile.Text = balUser.Message;
}
}
//public override void OnAuthorization(HttpActionContext actionContext)
//{
// var isAuthorized = base.IsAuthorized(actionContext);
// // base.AuthorizeCore(httpContext);
// if (!isAuthorized)
// {
// return;
// // return false;
// }
// string CurrentUserRole = "Admin";
// if (this.UserRole.Contains(CurrentUserRole))
// {
// return ;
// }
// else
// {
// // return false;
// }
// // base.OnAuthorization(actionContext);
//}
public override void OnAuthorization(HttpActionContext actionContext)
{
var authorizeHeader = actionContext.Request.Headers.Authorization;
//var authorizeHeader = actionContext.Request.Headers.Authorization;
//if (authorizeHeader != null && String.IsNullOrEmpty(authorizeHeader.Parameter) == false)
//{
UserBAL objUserBLL = new UserBAL();
// UserBLL objUserBLL = new UserBLL();
var existingToken = objUserBLL.GetAuthorizeRole();
if (existingToken != null)
{
// var Data = existingToken.description;
var Role = existingToken.description;
var principal = new GenericPrincipal((new GenericIdentity(existingToken.roleid.ToString())),
(new[] { existingToken.description.ToString() }));
Thread.CurrentPrincipal = principal;
if (HttpContext.Current != null)
{
HttpContext.Current.User = principal;
}
return;
}
// }
Result outResult = new Result
{
//status = false,
MessageId = -1
};
actionContext.Response = actionContext.Request.CreateResponse(HttpStatusCode.OK, outResult);
}
public override Task OnDisconnected(bool stopCalled)
{
string id = Context.ConnectionId;
if (ContextInfo == null)
{
ContextInfo = ContextInfoInitilizer.GetContextInfo(Context.Request.GetHttpContext(), Context.User, Context.QueryString["SessionID"]);
}
UserModel userModel = new UserModel();
if (ContextInfo.IsUserAuthenticated)
{
using (UserBAL userBAL = new UserBAL(ContextInfo))
{
userModel.Id = ContextInfo.UserID;
userBAL.removeConnection(id);
userBAL.GetUserModel(userModel);
}
if (userModel.IsOnline == false)
{
Clients.Client(id).disconnected(true);
Clients.All.userIsOnline(ContextInfo.UserID, false);
}
}
return(base.OnDisconnected(stopCalled));
}
protected void btnReset_Click(object sender, EventArgs e)
{
UserBAL userBAL = new UserBAL();
UserBE user = new UserBE();
LoggedIn master = (LoggedIn)this.Master;
if (txtOldPass.Text == commonBAL.Decrypt(((UserBE)Session["LoggedInUser"]).EncPass.ToString(), false))
{
user.UserId = Convert.ToInt32(((UserBE)Session["LoggedInUser"]).UserId);
user.EncPass = commonBAL.Encrypt(txtNewPass.Text, false);
if (txtNewPass.Text == txtconfirmPass.Text)
{
if (userBAL.ResetPassword(user))
{
master.ShowMessage("Password Changed Successfully", true);
}
else
{
master.ShowMessage("Unsuccessful", false);
}
}
else
{
master.ShowMessage("Password Mismatched", false);
}
}
else
{
master.ShowMessage("Incorrect Old Password", false);
}
}
public DataTable AuthenticateUser(UserBAL obj)
{
DataTable dtUser = new DataTable();
dtUser = objUserBAL.CheckLoginExistOrNot(obj);
return(dtUser);
}
protected void grdTeacherSchedule_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
GridViewRow row = grdTeacherSchedule.Rows[e.NewSelectedIndex];
string batchId = (row.FindControl("lblBatchId") as Label).Text;
UserBO enrollBO = new UserBO
{
UserId = Session["UserId"].ToString(),
BatchId = batchId
};
UserBAL enrollBAL = new UserBAL();
int result = enrollBAL.Enroll(enrollBO);
if (result >= 1)
{
lblStatus.Text = "Successfully Enrolled";
// lblStaus = "Successfully Enrolled";
}
else
{
lblStatus.Text = "Already Enrolled";
// lblStaus = "Fail to Enrolle";
}
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
// lblStatus = ex.me
}
}
public BuildingController()
{
_buildingBAL = new BuildingBAL();
_userBAL = new UserBAL();
result = new Result();
}
public static bool RegisterUser(string email)
{
User user = new User();
user.Email = email;
return(UserBAL.RegisterUser(user, "", "", ""));
}
protected void btnSubmitQ_Click(object sender, EventArgs e)
{
try
{
if (txtBoxKeyword.Text != "")
{
UserBAL search = new UserBAL();
string keyWordId = dropDownKeyword.SelectedValue;
string keyWord = txtBoxKeyword.Text;
DataTable searchTable = search.AdvanceSearchTable(keyWordId, keyWord);
if (searchTable.Rows.Count > 0)
{
gridViewSearch.DataSource = searchTable;
gridViewSearch.DataBind();
}
else
{
lblStatus.Text = "Document not found";
}
}
else
{
lblStatus.Text = "please enter a keyword for search";
}
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
}
/// <summary>
/// To check user is authorised or not from database
/// </summary>
/// <returns></returns>
public DataTable GetUserDetails()
{
UserBAL UserBAL = new UserBAL();
DataTable UserTable = new DataTable();
try
{
UserTable = UserBAL.SelectUserName(LoginUserName, LoginUserID, Ret);
if (UserTable.Rows.Count > 0)
{
LoginUser = Convert.ToInt16(UserTable.Rows[0][0]);
LogedInUser = UserTable.Rows[0][5].ToString();
ValidUser = "******";
}
else
{
ValidUser = "******";
}
}
catch
{
}
finally
{
UserBAL = null;
}
return(UserTable);
}
protected void btnRegister_Click(object sender, EventArgs e)
{
#region Server Side Validation
string strErrorMessage = "";
if (txtUserName.Text.Trim() == "")
{
strErrorMessage += "-Enter User Name <br />";
}
if (txtPassword.Text.Trim() == "")
{
strErrorMessage += "-Enter Password <br />";
}
if (strErrorMessage.Trim() != "")
{
lblMassage.Text = strErrorMessage;
lblMassage.CssClass = "text-danger";
return;
}
#endregion Server Side Validation
UserENT entUser = new UserENT();
UserBAL balUser = new UserBAL();
if (balUser.SelectByUserName(txtUserName.Text.ToString().Trim()).IsNull)
{
readData();
string strOTP = GeneratePassword().ToString();
Session["OTP"] = strOTP;
MailMessage msg = new MailMessage();
msg.From = new MailAddress("*****@*****.**");
msg.To.Add(txtUserName.Text);
msg.Subject = "Verfiy your email account";
msg.Body = "Welcome to Income Expence <br/><br/>Your OTP is:<strong>" + strOTP + "</strong>";
msg.IsBodyHtml = true;
SmtpClient smt = new SmtpClient();
smt.Host = "smtp.gmail.com";
System.Net.NetworkCredential ntwd = new NetworkCredential();
ntwd.UserName = "******"; // Your Email ID
ntwd.Password = ""; // Your Password
smt.UseDefaultCredentials = true;
smt.Credentials = ntwd;
smt.Port = 587;
smt.EnableSsl = true;
smt.Send(msg);
lblMassage.Text = "Email Sent Successfully";
lblMassage.ForeColor = System.Drawing.Color.ForestGreen;
ClearControls();
Response.Redirect("~/AdminPanel/Authentication/VerifyEmail.aspx");
}
else
{
lblMassage.Text = "User Name is alrady Entered";
lblMassage.CssClass = "text-danger";
ClearControls();
}
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" });
DataTable dtUser = new DataTable();
UserBAL obj = new UserBAL {
LoginID = context.UserName, Password = context.Password
};
dtUser = obj.CheckLoginExistOrNot(obj);
if (dtUser == null || dtUser.Rows.Count == 0)
{
context.SetError("invalid_grant", "1");
return;
}
else if (dtUser.Rows[0][0].ToString() == "0")
{
context.SetError("invalid_grant", "0");
return;
}
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
identity.AddClaim(new Claim("ID", dtUser.Rows[0]["UserID"].ToString()));
identity.AddClaim(new Claim(ClaimTypes.Role, dtUser.Rows[0]["UserType"].ToString()));
context.Validated(identity);
}
public ActionResult ChangePassword(UserModel userModel)
{
//List<string> validateList = new List<string>() {
// userModel.nameof(x=>x.Password)
//};
//ModelState.ClearAllExcept<UserModel>(validateList);
using (UserBAL userBAL = new UserBAL(ContextInfo))
{
if (ModelState.IsValidFor <UserModel>(x => x.Password))
{
userBAL.ChangePassword(userModel);
}
if (userModel.HasErrorByType(LMYFrameWorkMVC.Common.LookUps.ErrorType.Critical) || userModel.HasSuccess(LMYFrameWorkMVC.Common.LookUps.SuccessType.Full))
{
return(base.RedirectToActionWithData(new Dictionary <string, object> {
{ "baseModel", userModel }
}, "Edit"));
}
// userBAL.PrepareUserModel(userModel);
}
return(View(userModel));
}
protected void btnSavePassword_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrWhiteSpace(txtPassword.Text) || string.IsNullOrWhiteSpace(txtConfirmPassword.Text))
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CallJS", "alert('Please enter Password');", true);
}
else if (!txtPassword.Text.Trim().Equals(txtConfirmPassword.Text.Trim()))
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CallJS", "alert('Password does not matched.');", true);
}
else
{
UserBE userInfo = new UserBE();
UserBAL userBAL = new UserBAL();
CommonBAL combal = new CommonBAL();
string pwd = combal.Encrypt(txtPassword.Text.Trim(), false);
int i = userBAL.SaveConfirmation(Request.QueryString["userid"].ToString(), Request.QueryString["key"].ToString(), pwd);
if (i > 0)
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CallJS", "alert('Password saved, Please relogin'); location.href ='login.aspx';", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CallJS", "alert('try again later');", true);
}
}
}
catch (Exception ex)
{
}
}
private void BindData()
{
IUserBAL itemBAL = new UserBAL();
User user = itemBAL.GetUserByLoginName(HttpContext.Current.User.Identity.Name.Trim());
if (user == null || user.UserGuid == Guid.Empty)
return;
this.TextBoxUserID.Text = user.UserID;
this.TextBoxUerName.Text = user.UserName;
}
void btnSave_Click(object sender, EventArgs e)
{
IUserBAL ItemBAL = new UserBAL();
if (TextBoxPassWord.Text == TextBoxRePassWord.Text)
{
if (ItemBAL.UpdatePassWord(TextBoxUserID.Text, TextBoxPassWord.Text))
{
LabelThongbao.BackColor = Color.Blue;
LabelThongbao.Text = "Đổi mật khẩu thành công!";
//sau khi luuw mật khẩu thành công thì bắt đăng nhập lại
WebUtils.SetupRedirect(this, SiteUtils.GetNavigationSiteRoot() + "/Secure/Logoff.aspx");
}
else
LabelThongbao.Text = "Đổi mật khẩu không thành công!";
}
}
internal DataTable UserCheck(UserBAL userBAL)
{
try
{
con = Connection.GetConnection();
cmd = Connection.GetCommand("UserCheck", con);
cmd.Parameters.AddWithValue("@userName", userBAL.UserName);
cmd.Parameters.AddWithValue("@userPassword", userBAL.UserPassword);
sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
internal int UserInsert(UserBAL userBAL)
{
try
{
con = Connection.GetConnection();
cmd = Connection.GetCommand("UserInsert", con);
con.Open();
cmd.Parameters.AddWithValue("@firstName", userBAL.FirstName);
cmd.Parameters.AddWithValue("@lastName", userBAL.LastName);
cmd.Parameters.AddWithValue("@email", userBAL.Email);
cmd.Parameters.AddWithValue("@userName", userBAL.UserName);
cmd.Parameters.AddWithValue("@userPassword", userBAL.UserPassword);
cmd.Parameters.AddWithValue("@title", userBAL.Title);
cmd.Parameters.AddWithValue("@officeNo", userBAL.OfficeNo);
cmd.Parameters.AddWithValue("@mobileNo", userBAL.MobileNo);
cmd.Parameters.AddWithValue("@userRoleId", userBAL.UserRoleId);
cmd.Parameters.AddWithValue("@companyId", userBAL.CompanyId);
cmd.Parameters.AddWithValue("@userId", userBAL.UserId);
cmd.Parameters["@userId"].Direction = ParameterDirection.InputOutput;
cmd.ExecuteNonQuery();
int userId = Convert.ToInt32(cmd.Parameters["@userId"].Value);
con.Close();
return userId;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
}
/// <summary>
/// To get active User details
/// </summary>
/// <returns></returns>
private DataTable ActivegetUserDetails()
{
UserBAL UserBAL = new UserBAL();
DataTable DtUserDe = new DataTable();
try
{
DtUserDe = UserBAL.LoadActiveUser(true, LoginUser, Ret);
}
catch
{
}
finally
{
UserBAL = null;
}
return DtUserDe;
}
/// <summary>
/// To save and update user details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string Status = ddlUserStatus.SelectedItem.Text;
string FName = txtFName.Text;
string Lname = txtLastName.Text;
string Email = txtEmail.Text;
string Remarks = txtRemarks.Text;
string UserName = txtUserName.Text;
string UIsAdmin = ddlIsAdmin.SelectedItem.Text;
bool IsAdmin = true;
if (UIsAdmin == "True")
{
IsAdmin = true;
}
else if (UIsAdmin == "False")
{
IsAdmin = false;
}
bool UserStatus;
if (ddlUserStatus.SelectedItem.Text != "Select")
{
if (Status == "Active")
{
UserStatus = true;
}
else
{
UserStatus = false;
}
if (btnSave.Text == "Save")
{
int IntResult = 0;
UserBAL UserBAL = new UserBAL();
try
{
// 'InsertUser' is User business Access Layer function called
// to insert User details
IntResult = UserBAL.InsertUser(FName, Lname, Email, Remarks, IsAdmin, UserStatus, UserName, LoginUser, Ret);
//msgUser.Msg = "User details submited successfully";
//msgUser.showmsg();
btnUserGroRol.Enabled = true;
Clear();
Response.Redirect("UserList.aspx", false);
}
catch (Exception ee)
{
if (ee.Message == "Duplicate Entry")
{
// Duplicate Entry is catched when inserting Group
msgUser.Msg = "Duplicate Entry!";
msgUser.showmsg();
Clear();
}
}
finally
{
UserBAL = null;
}
}
else if (btnSave.Text == "Update")
{
int IntResult = 0;
UserBAL UserBAL = new UserBAL();
try
{
// 'UpdateUser' is User business Access Layer function called
// to update User details
IntResult = UserBAL.UpdateUser(UserId, FName, Lname, Email, Remarks, IsAdmin, UserStatus, LoginUser, Ret);
msgUser.Msg = "User details updated successfully";
msgUser.showmsg();
btnSave.Text = "Save";
Clear();
Response.Redirect("UserList.aspx", false);
}
catch (Exception ee)
{
// Duplicate Entry is catched when updating Group
if (ee.Message == "Duplicate Entry")
{
msgUser.Msg = "Duplicate Entry!";
msgUser.showmsg();
Clear();
}
}
finally
{
UserBAL = null;
}
}
}
}
/// <summary>
/// To load selected user details from database
/// </summary>
/// <param name="FName"></param>
/// <param name="LName"></param>
/// <param name="ISActive"></param>
/// <returns></returns>
protected DataTable SelectUserdetails(string FName,string LName,bool ISActive)
{
ISActive=true;
UserBAL UserBAL = new UserBAL();
DataTable DtSelUser = new DataTable();
try
{
DtSelUser = UserBAL.SelectUserdetails(FName, LName, ISActive, LoginUser, Ret);
}
catch (Exception ee)
{
throw;
}
finally
{
UserBAL = null;
}
return DtSelUser;
}
/// <summary>
/// To get User details from 'user Business access layer'
/// </summary>
/// <returns></returns>
private DataTable getUserDetails()
{
UserBAL UserBAL = new UserBAL();
DataTable DtUDetails = new DataTable();
try
{
DtUDetails = UserBAL.LoadAllUser(LoginUser, Ret);
}
catch
{
}
finally
{
UserBAL = null;
}
return DtUDetails;
}
/// <summary>
/// To get selected user
/// </summary>
/// <param name="UserIdNew"></param>
/// <returns></returns>
protected DataTable UserIDDetails(int UserIdNew)
{
UserBAL UserBAL = new UserBAL();
DataTable DtUserIdDet = new DataTable();
try
{
DtUserIdDet = UserBAL.SelectUserID(UserIdNew, LoginUser, Ret);
DataView DvUserDet = DtUserIdDet.DefaultView;
DvUserDet.RowFilter = "IsActive=true";
DtUserIdDet = DvUserDet.ToTable();
}
catch (Exception ee)
{
throw;
}
finally
{
UserBAL = null;
}
return DtUserIdDet;
}
/// <summary>
/// To get User details
/// </summary>
/// <returns></returns>
protected DataTable UserPerDetails()
{
UserBAL UserBAL = new UserBAL();
DataTable DtUser = new DataTable();
try
{
DtUser = UserBAL.LoadActiveUser(IsActive, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
UserBAL = null;
}
return DtUser;
}
/// <summary>
/// To take user list from database
/// </summary>
/// <returns></returns>
protected DataTable UserPerDetails()
{
UserBAL UserBAL = new UserBAL();
DataTable DtUserPerDe = new DataTable();
try
{
DtUserPerDe = UserBAL.LoadNameEmail(LoginUser, Ret);
}
catch (Exception ee)
{
throw;
}
finally
{
UserBAL = null;
}
return DtUserPerDe;
}
/// <summary>
/// To get Menu details from Menu Business Access Layer
/// </summary>
/// <param name="menuId"></param>
/// <returns></returns>
private DataTable BinMenu()
{
UserBAL UserBAL = new UserBAL();
DataTable DtUser = new DataTable();
try
{
DtUser = UserBAL.LoadUserPermission(LoginUser, true, LoginUser, Ret);
}
catch
{
}
finally
{
UserBAL = null;
}
return DtUser;
}
public override bool ValidateUser(string userName, string password)
{
string urlApp = SiteUtils.GetSiteId();
bool result = false;
IUserBAL itemBAL = new UserBAL();
User user = itemBAL.GetUserByLogin(userName, password, urlApp);
//login trang thái,
//get value phân quyền
if (user.UserGuid != Guid.Empty)
{
HttpContext.Current.Session["permissionvalue"] = user.ValuePermission;
result = true;
}
return result;
}
public static Guid GetCurrentUserId()
{
if (HttpContext.Current == null || HttpContext.Current.User == null)
return Guid.Empty;
if (!HttpContext.Current.Request.IsAuthenticated)
return Guid.Empty;
if (HttpContext.Current.Session["LoggedUserId"] != null)
{
return new Guid(HttpContext.Current.Session["LoggedUserId"].ToString());
}
else
{
UserBAL itemBAL = new UserBAL();
User item = itemBAL.GetUserByLoginName(HttpContext.Current.User.Identity.Name.Trim());
return item.UserGuid;
}
}
public static SiteUser GetCurrentUser(bool bypassAuthCheck)
{
if (HttpContext.Current == null)
return null;
if (bypassAuthCheck || (HttpContext.Current.Request.IsAuthenticated))
{
if (HttpContext.Current.Items["CurrentUser"] != null)
{
try
{
return (SiteUser)HttpContext.Current.Items["CurrentUser"];
}
catch
{
}
}
IUserBAL itemBAl = new UserBAL();
User item = itemBAl.GetUserByLoginName(HttpContext.Current.User.Identity.Name.Trim());
SiteUser siteUser = new SiteUser();
siteUser.UserId = item.UserGuid;
siteUser.Name = item.UserName;
siteUser.LoginName = item.UserID;
if (siteUser.UserId != Guid.Empty)
{
HttpContext.Current.Items["CurrentUser"] = siteUser.ToString();
return siteUser;
}
}
return null;
}
protected void SiteLogin_LoggedIn(object sender, EventArgs e)
{
IUserBAL itemBAL = new UserBAL();
User item = itemBAL.GetUserByLoginName(this.UserName.Trim());
SiteUser siteUser = new SiteUser();
siteUser.LoginName = item.UserID;
siteUser.Name = item.UserName;
siteUser.UserId = item.UserGuid;
string cookieName = "siteguid" + SiteUtils.GetSiteId();
CookieHelper.SetCookie(cookieName, siteUser.UserId.ToString(), this.RememberMeSet);
if (siteUser.UserId == Guid.Empty)
return;
UserSignInEventArgs u = new UserSignInEventArgs(siteUser);
OnUserSignIn(u);
}
/// <summary>
/// To load user details from database
/// </summary>
/// <returns></returns>
protected DataTable GetUserDetails()
{
UserBAL UserBAL = new UserBAL();
DataTable DtUserDet = new DataTable();
try
{
DtUserDet = UserBAL.SelectUserID(UserId, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
UserBAL = null;
}
return DtUserDet;
}
