protected void btnEdit_Click(object sender, EventArgs e)
{
WaterLevelDam WaterLevelDam = new WaterLevelDam();
WaterLevelDamTableAdapter WaterLevelDamTableAdapter = new WaterLevelDamTableAdapter();
WaterLevelDam originalWaterLevelDam = WaterLevelDamTableAdapter.GetWaterLevelByID(Convert.ToInt32(Request["WaterLevelDamID"]));
if (IsValidData())
{
WaterLevelDam.ID = originalWaterLevelDam.ID;
WaterLevelDam.DamID = Convert.ToInt32(ddlDamName.SelectedValue);
WaterLevelDam.DamName = ddlDamName.SelectedItem.ToString();
WaterLevelDam.LevelFeet = txtWaterLevelFeet.Text.Trim();
WaterLevelDam.Remark = txtRemark.Text.Trim();
WaterLevelDam.CreatedDate = Convert.ToDateTime(txtDate.Text);
WaterLevelDam.CreatedTime = txtTime.Text;
WaterLevelDam.Status = "ACTIVE";
if (WaterLevelDamTableAdapter.Update(WaterLevelDam) > 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>" + txtWaterLevelFeet.Text.Trim() + "</b>.</div>";
Response.Redirect("~/WaterLevelsDam/waterlevellistdam.aspx");
}
}
}
protected void txtSearch_TextChanged(object sender, EventArgs e)
{
WaterLevelDamTableAdapter WaterLevelDamTableAdapter = new WaterLevelDamTableAdapter();
DataSet ds = WaterLevelDamTableAdapter.GetSearchByWaterLevel(txtSearch.Text.Trim(), txtSearch.Text.Trim(), txtSearch.Text.Trim(), Convert.ToDateTime(txtSearch.Text.Trim()), txtSearch.Text.Trim(), "ACTIVE");
if (ds.Tables[0].Rows.Count > 0)
{
Session["dt"] = ds.Tables[0];
PagingDataBind((DataTable)Session["dt"]);
}
}
protected void btnYes_Click(object sender, EventArgs e)
{
WaterLevelDamTableAdapter WaterLevelDamTableAdapter = new WaterLevelDamTableAdapter();
WaterLevelDam originalWaterLevelDam = WaterLevelDamTableAdapter.GetWaterLevelByID(Convert.ToInt32(Request["WaterLevelDamID"]));
WaterLevelDam WaterLevelDam = new WaterLevelDam();
WaterLevelDam.ID = originalWaterLevelDam.ID;
WaterLevelDam.DamID = originalWaterLevelDam.DamID;
WaterLevelDam.DamName = originalWaterLevelDam.DamName;
WaterLevelDam.LevelFeet = originalWaterLevelDam.LevelFeet;
WaterLevelDam.Remark = originalWaterLevelDam.Remark;
WaterLevelDam.CreatedDate = originalWaterLevelDam.CreatedDate;
WaterLevelDam.CreatedTime = originalWaterLevelDam.CreatedTime;
WaterLevelDam.Status = "INACTIVE";
if (WaterLevelDamTableAdapter.Update(WaterLevelDam) > 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 Deleted <b>" + originalWaterLevelDam.DamName + "</b>.</div>";
Response.Redirect("~/WaterLevelsDam/waterlevellistdam.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Null.IsNotNull(Request["q"]))
{
if (Null.IsNotNull(Session["Login"].ToString()))
{
Session["Login"] = null;
Session["Name"] = null;
Response.Redirect("~/signin.aspx");
}
}
if (Null.IsNotNull(Session["Login"]) || Null.IsNotNull(Session["Name"]))
{
WaterLevelDamTableAdapter WaterLevelDamTableAdapter = new WaterLevelDamTableAdapter();
DataSet ds = WaterLevelDamTableAdapter.GetWaterLevelByStatus("ACTIVE");
if (ds.Tables[0].Rows.Count > 0)
{
Session["dt"] = ds.Tables[0];
PagingDataBind((DataTable)Session["dt"]);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ltlMessage.Text = null;
if (!IsPostBack)
{
DamTableAdapter damTableAdapter = new DamTableAdapter();
DataTable dtDam = damTableAdapter.GetDataByStatus("ACTIVE");
ddlDamName.DataValueField = "ID";
ddlDamName.DataTextField = "DamName";
ddlDamName.DataSource = dtDam;
ddlDamName.DataBind();
ddlDamName.Items.Insert(0, new ListItem("Select Dam Name"));
WaterLevelDamTableAdapter WaterLevelDamTableAdapter = new WaterLevelDamTableAdapter();
WaterLevelDam originalWaterLevelDam = WaterLevelDamTableAdapter.GetWaterLevelByID(Convert.ToInt32(Request["WaterLevelDamID"]));
ddlDamName.SelectedValue = originalWaterLevelDam.DamID.ToString();
txtWaterLevelFeet.Text = originalWaterLevelDam.LevelFeet;
txtRemark.Text = originalWaterLevelDam.Remark;
txtDate.Text = originalWaterLevelDam.CreatedDate.ToString("dd/MMM/yyyy");
txtTime.Text = originalWaterLevelDam.CreatedTime;
}
}
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();
}
}
