protected void btnEdit_Click(object sender, EventArgs e) { UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile originalUserProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Request["UserProfileID"])); UserProfile userProfile = new UserProfile(); if (originalUserProfile.ID != 1) { if (IsValidData()) { userProfile.ID = originalUserProfile.ID; userProfile.Name = Server.HtmlEncode(txtName.Text.Trim()); userProfile.Username = Server.HtmlEncode(txtUsername.Text.Trim()); userProfile.Password = originalUserProfile.Password; userProfile.DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue); userProfile.UserRoleID = Convert.ToInt32(ddlUserRole.SelectedValue); userProfile.Status = "ACTIVE"; if (userProfileTableAdapter.Update(userProfile) > 0) { ltlMessage.Text = "<div class=\"alert alert-success alert-dismissible\"><button type = \"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button> <h4><i class=\"icon fa fa-check\"></i> Alert!</h4> Sucessfully Updated <b>" + txtName.Text.Trim() + "</b>.</div>"; Response.Redirect("~/UserProfiles/userprofilelist.aspx"); } } } else { ShowErrorMessage(GetGlobalResourceObject("UserResource", "systemdefaultuser").ToString()); } }
protected void Page_Load(object sender, EventArgs e) { ltlMessage.Text = null; if (!Page.IsPostBack) { DepartmentTableAdapter departmentTableAdapter = new DepartmentTableAdapter(); DataTable dtDepartment = departmentTableAdapter.GetDataByStatus("ACTIVE"); ddlDepartment.DataValueField = "ID"; ddlDepartment.DataTextField = "DepartmentName"; ddlDepartment.DataSource = dtDepartment; ddlDepartment.DataBind(); ddlDepartment.Items.Insert(0, new ListItem("Select Department")); UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter(); DataTable dtUserRoleName = userRoleTableAdapter.GetDataByStatus("ACTIVE"); ddlUserRole.DataValueField = "ID"; ddlUserRole.DataTextField = "RoleName"; ddlUserRole.DataSource = dtUserRoleName; ddlUserRole.DataBind(); ddlUserRole.Items.Insert(0, new ListItem("Select User Role")); UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile originalUserProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Request["UserProfileID"])); ddlDepartment.SelectedValue = originalUserProfile.DepartmentID.ToString(); ddlUserRole.SelectedValue = originalUserProfile.UserRoleID.ToString(); txtName.Text = originalUserProfile.Name; txtUsername.Text = originalUserProfile.Username; } }
protected void btnVerify_Click(object sender, EventArgs e) { UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile userProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Session["Login"])); if (userProfile.UserRoleID == 1) { Session["Login"] = userProfile.ID; Session["Name"] = userProfile.Name; Session["Role"] = userProfile.UserRoleID; Session["ResetCode"] = resetCode(); Response.Redirect("~/verifypasswordresetcode.aspx"); } }
protected void btnVerify_Click(object sender, EventArgs e) { UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile userProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Session["Login"])); if (userProfile.UserRoleID == 1) { if (txtVerifyCode.Text.Trim() == Session["ResetCode"].ToString()) { Session["Login"] = userProfile.ID; Session["Name"] = userProfile.Name; Session["Role"] = userProfile.UserRoleID; Response.Redirect("~/changepassword.aspx"); } } else { Response.Redirect("~/signin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { ltlMessage.Text = null; if (!Page.IsPostBack) { if (Request["q"] != null) { if (Session["Login"].ToString() != null) { Session["Login"] = null; Session["Name"] = null; Response.Redirect(ConfigurationManager.AppSettings.GetValues("mainURL") + "signin.aspx"); } } } UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile userProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Session["Login"])); if (userProfile.UserRoleID == 1) { txtUsername.Text = userProfile.Username; } }
private void BindRepeaterByName() { UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile userProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Session["Login"])); if (userProfile.UserRoleID == 1) { DataTable dtUserProfileList = userProfileTableAdapter.GetDataByStatus("ACTIVE"); if (dtUserProfileList.Rows.Count > 0) { DataView dvData = new DataView(dtUserProfileList); dvData.Sort = ViewState["Column"].ToString() + " " + ViewState["Order"].ToString(); rptUserProfileList.DataSource = dvData; rptUserProfileList.DataBind(); rptUserProfileList.Dispose(); dvData.Dispose(); } } else { DataTable dtUserProfileList = userProfileTableAdapter.GetDataByDepartmentIDAndStatus(userProfile.DepartmentID, "ACTIVE"); if (dtUserProfileList.Rows.Count > 0) { DataView dvData = new DataView(dtUserProfileList); dvData.Sort = ViewState["Column"].ToString() + " " + ViewState["Order"].ToString(); rptUserProfileList.DataSource = dvData; rptUserProfileList.DataBind(); rptUserProfileList.Dispose(); dvData.Dispose(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Request["q"] != null) { if (Session["Login"].ToString() != null) { Session["Login"] = null; Session["Name"] = null; Response.Redirect(ConfigurationManager.AppSettings.GetValues("mainURL") + "signin.aspx"); } } UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile userProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Session["Login"])); DataTable dtUserProfile = userProfileTableAdapter.GetDataByStatus("ACTIVE"); if (userProfile.DepartmentID == 1) { if (userProfile.UserRoleID == 1) { ltlCustomer.Visible = true; ltlDepartmentView.Visible = true; ltlInvoiceReportView.Visible = true; ltlUserProfileView.Visible = true; ltlUserRoleView.Visible = true; ltlRiver.Visible = true; ltlRiverView.Visible = true; //chartWaterLevel.Visible = true; //string[] x = new string[dtWaterLevel.Rows.Count]; //int[] y = new int[dtWaterLevel.Rows.Count]; //for (int i = 0; i < dtWaterLevel.Rows.Count; i++) //{ // x[i] = dtWaterLevel.Rows[i][2].ToString(); // y[i] = Convert.ToInt32(dtWaterLevel.Rows[i][0]); //} //chartWaterLevel.Series[0].Points.DataBindXY(x, y); //chartWaterLevel.Series[0].ChartType = SeriesChartType.Column; //chartWaterLevel.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; //chartWaterLevel.Legends[0].Enabled = true; } } else if (userProfile.DepartmentID == 2) { if (userProfile.UserRoleID == 2) { ltlCustomerView.Visible = true; ltlDepartmentView.Visible = true; ltlUserProfileView.Visible = true; ltlUserRoleView.Visible = true; } else if (userProfile.UserRoleID == 3) { ltlCustomerView.Visible = true; ltlDepartmentView.Visible = false; ltlInvoiceReportView.Visible = true; ltlUserProfileView.Visible = false; ltlUserRoleView.Visible = false; } } else if (userProfile.DepartmentID == 3) { if (userProfile.UserRoleID == 4) { ltlCustomerView.Visible = false; ltlDepartmentView.Visible = false; ltlUserProfileView.Visible = false; ltlUserRoleView.Visible = false; } } else if (userProfile.DepartmentID == 4) { if (userProfile.UserRoleID == 5 || userProfile.UserRoleID == 6) { ltlCustomerView.Visible = false; ltlDepartmentView.Visible = false; ltlInvoiceReportView.Visible = false; ltlUserProfileView.Visible = false; ltlUserRoleView.Visible = false; } } else if (userProfile.DepartmentID == 5) { if (userProfile.UserRoleID == 7) { ltlCustomerView.Visible = true; ltlDepartmentView.Visible = false; ltlInvoiceReportView.Visible = false; ltlUserProfileView.Visible = false; ltlUserRoleView.Visible = false; } } else if (userProfile.DepartmentID == 6) { if (userProfile.UserRoleID == 8) { ltlCustomerView.Visible = false; ltlDepartmentView.Visible = false; ltlInvoiceReportView.Visible = false; ltlUserProfileView.Visible = false; ltlUserRoleView.Visible = false; } } DataTable dtUserProfileList = userProfileTableAdapter.GetDataByStatus("ACTIVE"); ltlUser.Text = dtUserProfileList.Rows.Count.ToString(); CustomerTableAdapter customeTableAdapter = new CustomerTableAdapter(); DataTable dtCustomerList = customeTableAdapter.GetDataByStatus("ACTIVE"); ltlCustomer.Text = dtCustomerList.Rows.Count.ToString(); ProjectTableAdapter projectTableAdapter = new ProjectTableAdapter(); DataTable dtProjectList = projectTableAdapter.GetDataByStatus("ACTIVE"); DepartmentTableAdapter departmentTableAdapter = new DepartmentTableAdapter(); DataTable dtDepartmentList = departmentTableAdapter.GetDataByStatus("ACTIVE"); ltlDepartment.Text = dtDepartmentList.Rows.Count.ToString(); UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter(); DataTable dtUserRole = userRoleTableAdapter.GetDataByStatus("ACTIVE"); ltlUserRole.Text = dtUserRole.Rows.Count.ToString(); WaterLevelTableAdapter waterLevelTabeleAdapter = new WaterLevelTableAdapter(); DataTable dtWaterLevel = waterLevelTabeleAdapter.GetDataByStatus("ACTIVE"); ltlWaterLevel.Text = dtWaterLevel.Rows.Count.ToString(); RiverTableAdapter riverTableAdapter = new RiverTableAdapter(); DataTable dtRiver = riverTableAdapter.GetDataByStatus("ACTIVE"); ltlRiver.Text = dtRiver.Rows.Count.ToString(); DamTableAdapter damTableAdapter = new DamTableAdapter(); DataTable dtDam = damTableAdapter.GetDataByStatus("ACTIVE"); ltlDam.Text = dtDam.Rows.Count.ToString(); WaterLevelDamTableAdapter waterLevelDamTabeleAdapter = new WaterLevelDamTableAdapter(); DataTable dtWaterLevelDam = waterLevelDamTabeleAdapter.GetDataByStatus("ACTIVE"); ltlWaterLevelDam.Text = dtWaterLevelDam.Rows.Count.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["Login"] != null) { UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter(); UserProfile userProfile = userProfileTableAdapter.GetUserProfileByID(Convert.ToInt32(Session["Login"])); if (userProfile.DepartmentID == 1) { if (userProfile.UserRoleID == 1) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/management.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } } else if (userProfile.DepartmentID == 2) { if (userProfile.UserRoleID == 2) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/admin.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } if (userProfile.UserRoleID == 3) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/assistantadmin.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } } else if (userProfile.DepartmentID == 3) { if (userProfile.UserRoleID == 4) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/doctor.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } } else if (userProfile.DepartmentID == 4) { if (userProfile.UserRoleID == 5) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/medtech.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } else if (userProfile.UserRoleID == 6) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/labassistant.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } } else if (userProfile.DepartmentID == 5) { if (userProfile.UserRoleID == 7) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/cashier.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } } else if (userProfile.DepartmentID == 6) { if (userProfile.UserRoleID == 8) { using (StreamReader reader = new StreamReader(Server.MapPath("~/TextFiles/radiologist.txt"))) { ltlSideBar.Text = reader.ReadToEnd(); } } } } if (Request["q"] != null) { if (Session["Login"].ToString() != null) { Session["Login"] = null; Session["Name"] = null; Session["Role"] = null; Session["RoleName"] = null; Response.Redirect("~/signin.aspx"); } } } }