protected void btnEdit_Click(object sender, EventArgs e)
{
WaterLevel WaterLevel = new WaterLevel();
WaterLevelTableAdapter WaterLevelTableAdapter = new WaterLevelTableAdapter();
WaterLevel originalWaterLevel = WaterLevelTableAdapter.GetWaterLevelByID(Convert.ToInt32(Request["WaterLevelID"]));
if (IsValidData())
{
WaterLevel.ID = originalWaterLevel.ID;
WaterLevel.RiverID = Convert.ToInt32(ddlRiverName.SelectedValue);
WaterLevel.RiverName = ddlRiverName.SelectedItem.ToString();
WaterLevel.LevelFeet = txtWaterLevelFeet.Text.Trim();
WaterLevel.Remark = txtRemark.Text.Trim();
WaterLevel.CreatedDate = Convert.ToDateTime(txtDate.Text);
WaterLevel.CreatedTime = txtTime.Text;
WaterLevel.Status = "ACTIVE";
if (WaterLevelTableAdapter.Update(WaterLevel) > 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("~/WaterLevels/waterlevellist.aspx");
}
}
}
protected void btnYes_Click(object sender, EventArgs e)
{
WaterLevelTableAdapter WaterLevelTableAdapter = new WaterLevelTableAdapter();
WaterLevel originalWaterLevel = WaterLevelTableAdapter.GetWaterLevelByID(Convert.ToInt32(Request["WaterLevelID"]));
WaterLevel WaterLevel = new WaterLevel();
WaterLevel.ID = originalWaterLevel.ID;
WaterLevel.RiverID = originalWaterLevel.RiverID;
WaterLevel.RiverName = originalWaterLevel.RiverName;
WaterLevel.LevelFeet = originalWaterLevel.LevelFeet;
WaterLevel.Remark = originalWaterLevel.Remark;
WaterLevel.CreatedDate = originalWaterLevel.CreatedDate;
WaterLevel.CreatedTime = originalWaterLevel.CreatedTime;
WaterLevel.Status = "INACTIVE";
if (WaterLevelTableAdapter.Update(WaterLevel) > 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>" + originalWaterLevel.RiverName + "</b>.</div>";
Response.Redirect("~/WaterLevels/waterlevellist.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ltlMessage.Text = null;
if (!IsPostBack)
{
RiverTableAdapter riverTableAdapter = new RiverTableAdapter();
DataTable dtRiver = riverTableAdapter.GetDataByStatus("ACTIVE");
ddlRiverName.DataValueField = "ID";
ddlRiverName.DataTextField = "RiverName";
ddlRiverName.DataSource = dtRiver;
ddlRiverName.DataBind();
ddlRiverName.Items.Insert(0, new ListItem("Select River Name"));
WaterLevelTableAdapter WaterLevelTableAdapter = new WaterLevelTableAdapter();
WaterLevel originalWaterLevel = WaterLevelTableAdapter.GetWaterLevelByID(Convert.ToInt32(Request["WaterLevelID"]));
ddlRiverName.SelectedValue = originalWaterLevel.RiverID.ToString();
txtWaterLevelFeet.Text = originalWaterLevel.LevelFeet;
txtRemark.Text = originalWaterLevel.Remark;
txtDate.Text = originalWaterLevel.CreatedDate.ToString("dd/MMM/yyyy");
txtTime.Text = originalWaterLevel.CreatedTime;
}
}
