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 btnResetPassword_Click(object sender, EventArgs e)
{
if (IsValidData())
{
UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter();
UserProfile userProfile = userProfileTableAdapter.GetUserProfileByUsername(txtEmail.Text.Trim(), "ACTIVE");
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
UserRole userRole = userRoleTableAdapter.GetUserRoleByID(userProfile.ID);
if (userProfile.UserRoleID == 1)
{
Session["Login"] = userProfile.ID;
Session["Name"] = userProfile.Name;
Session["Role"] = userProfile.UserRoleID;
Session["RoleName"] = userRole.RoleName;
Response.Redirect("~/passwordresetcode.aspx");
}
else
{
ShowErrorMessage(GetGlobalResourceObject("UserResource", "pleasecontactadmin").ToString());
}
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
UserRole userRole = new UserRole();
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
UserRole originalUserRole = userRoleTableAdapter.GetUserRoleByID(Convert.ToInt32(Request["UserRoleID"]));
if (originalUserRole.ID != 1)
{
if (IsValidData())
{
userRole.ID = originalUserRole.ID;
userRole.RoleName = txtUserRoleName.Text.Trim();
userRole.Status = "ACTIVE";
if (userRoleTableAdapter.Update(userRole) > 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>" + txtUserRoleName.Text.Trim() + "</b>.</div>";
Response.Redirect("~/UserRoles/userrolelist.aspx");
}
}
}
else
{
ShowErrorMessage(GetGlobalResourceObject("UserRoleResource", "systemdefaultuserrole").ToString());
}
}
private void BindPaging()
{
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
DataTable dtUserRoleList = userRoleTableAdapter.GetDataByStatus("ACTIVE");
PagedDataSource pgitems = new PagedDataSource();
pgitems.DataSource = dtUserRoleList.DefaultView;
pgitems.AllowPaging = true;
pgitems.PageSize = 12;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i <= pgitems.PageCount - 1; i++)
{
pages.Add((i + 1).ToString());
}
rptPaging.DataSource = pages;
rptPaging.DataBind();
}
else
{
rptPaging.Visible = false;
}
rptUserRoleList.DataSource = pgitems;
rptUserRoleList.DataBind();
}
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"));
}
}
private void SignIn()
{
UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter();
UserProfile userProfile = userProfileTableAdapter.GetUserProfileByUsername(txtEmail.Text.Trim(), "ACTIVE");
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
UserRole userRole = userRoleTableAdapter.GetUserRoleByID(userProfile.ID);
if (IsValidData())
{
if (userProfile.Username == txtEmail.Text.Trim())
{
if (userProfile.Password == txtPassword.Text.Trim())
{
if (chbRememberMe.Checked)
{
Session["Login"] = userProfile.ID;
Session["Name"] = userProfile.Name;
Session["Role"] = userProfile.UserRoleID;
Session["RoleName"] = userRole.RoleName;
Response.Cookies["Username"].Value = txtEmail.Text.Trim();
Response.Cookies["Password"].Value = txtPassword.Text.Trim();
Response.Cookies["Username"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("~/default.aspx");
}
else
{
Session["Login"] = userProfile.ID;
Session["Name"] = userProfile.Name;
Session["Role"] = userProfile.UserRoleID;
Session["RoleName"] = userRole.RoleName;
Response.Cookies["Username"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1);
if(userProfile.DepartmentID == 5 && userProfile.UserRoleID == 7)
{
Response.Redirect("~/Invoices/newinvoice.aspx");
}
else
{
Response.Redirect("~/default.aspx");
}
}
}
else
{
ShowErrorMessage(GetGlobalResourceObject("UserResource", "wrongpassword").ToString());
}
}
else
{
ShowErrorMessage(GetGlobalResourceObject("UserResource", "wrongusername").ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ltlMessage.Text = null;
if (!IsPostBack)
{
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
UserRole originalUserRole = userRoleTableAdapter.GetUserRoleByID(Convert.ToInt32(Request["UserRoleID"]));
txtUserRoleName.Text = originalUserRole.RoleName;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
UserRole userRole = new UserRole();
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
if (IsValidData())
{
userRole.RoleName = txtUserRoleName.Text.Trim();
userRole.Status = "ACTIVE";
if (userRoleTableAdapter.Insert(userRole) > 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 Created <b>" + txtUserRoleName.Text.Trim() + "</b>.</div>";
Response.Redirect("~/UserRoles/userrolelist.aspx");
}
}
}
private void BindRepeater()
{
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
DataTable dtUserRoleList = userRoleTableAdapter.GetDataByStatus("ACTIVE");
if (dtUserRoleList.Rows.Count > 0)
{
DataView dvData = new DataView(dtUserRoleList);
dvData.Sort = ViewState["Column"].ToString() + " " + ViewState["Order"].ToString();
rptUserRoleList.DataSource = dvData;
rptUserRoleList.DataBind();
rptUserRoleList.Dispose();
dvData.Dispose();
}
}
private void SignIn()
{
if (Session["Login"] != null)
{
Session["Login"] = null;
Session["Role"] = null;
Session["RoleName"] = null;
UserProfileTableAdapter userProfileTableAdapter = new UserProfileTableAdapter();
UserProfile userProfile = userProfileTableAdapter.GetUserProfileByName(ltlName.Text, "ACTIVE");
UserRoleTableAdapter userRoleTableAdapter = new UserRoleTableAdapter();
UserRole userRole = userRoleTableAdapter.GetUserRoleByID(userProfile.ID);
if (userProfile.Password == txtPassword.Text.Trim())
{
Session["Login"] = userProfile.ID;
Session["Name"] = userProfile.Name;
Session["Role"] = userProfile.UserRoleID;
Session["RoleName"] = userRole.RoleName;
Response.Redirect("~/default.aspx");
}
else
{
ltlMessage.Text = "<div class=\"alert alert-danger alert-dismissible\"><button type = \"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">×</button> <h4><i class=\"icon fa fa-ban\"></i> Alert!</h4> Username and Password didn't match.</div>";
}
}
else
{
Session["Login"] = null;
Session["Name"] = null;
Session["Role"] = null;
Session["RoleName"] = null;
Response.Redirect("~/signin.aspx");
}
}
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();
}
}
