public int Update(WaterLevelDam waterLeveldam)
{
UpdateCommand.Parameters["@ID"].Value = waterLeveldam.ID;
UpdateCommand.Parameters["@DamID"].Value = waterLeveldam.DamID;
UpdateCommand.Parameters["@DamName"].Value = waterLeveldam.DamName;
UpdateCommand.Parameters["@LevelFeet"].Value = waterLeveldam.LevelFeet;
UpdateCommand.Parameters["@Remark"].Value = waterLeveldam.Remark;
UpdateCommand.Parameters["@CreatedDate"].Value = waterLeveldam.CreatedDate;
UpdateCommand.Parameters["@CreatedTime"].Value = waterLeveldam.CreatedTime;
UpdateCommand.Parameters["@Status"].Value = waterLeveldam.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
public int Insert(WaterLevelDam waterLeveldam)
{
InsertCommand.Parameters["@DamID"].Value = waterLeveldam.DamID;
InsertCommand.Parameters["@DamName"].Value = waterLeveldam.DamName;
InsertCommand.Parameters["@LevelFeet"].Value = waterLeveldam.LevelFeet;
InsertCommand.Parameters["@Remark"].Value = waterLeveldam.Remark;
InsertCommand.Parameters["@CreatedDate"].Value = waterLeveldam.CreatedDate;
InsertCommand.Parameters["@CreatedTime"].Value = waterLeveldam.CreatedTime;
InsertCommand.Parameters["@Status"].Value = waterLeveldam.Status;
int returnValue = -1;
try
{
InsertCommand.Connection.Open();
returnValue = (int)InsertCommand.ExecuteScalar();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
InsertCommand.Connection.Close();
}
return(returnValue);
}
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 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)
{
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;
}
}
private WaterLevelDam DataTableToEntity(DataTable dt)
{
WaterLevelDam waterLeveldam = new WaterLevelDam();
if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0)
{
if (Null.IsNotNull(dt.Rows[0]))
{
DataRow dr = dt.Rows[0];
if (Null.IsNotNull(dr["ID"]))
{
waterLeveldam.ID = Convert.ToInt32(dr["ID"]);
}
else
{
waterLeveldam.ID = 0;
}
if (Null.IsNotNull(dr["DamID"]))
{
waterLeveldam.DamID = Convert.ToInt32(dr["DamID"]);
}
else
{
waterLeveldam.DamID = 0;
}
if (Null.IsNotNull(dr["DamName"]))
{
waterLeveldam.DamName = Convert.ToString(dr["DamName"]);
}
else
{
waterLeveldam.DamName = string.Empty;
}
if (Null.IsNotNull(dr["LevelFeet"]))
{
waterLeveldam.LevelFeet = Convert.ToString(dr["LevelFeet"]);
}
else
{
waterLeveldam.LevelFeet = string.Empty;
}
if (Null.IsNotNull(dr["Remark"]))
{
waterLeveldam.Remark = Convert.ToString(dr["Remark"]);
}
else
{
waterLeveldam.Remark = string.Empty;
}
if (Null.IsNotNull(dr["CreatedDate"]))
{
waterLeveldam.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
}
else
{
waterLeveldam.CreatedDate = DateTime.Now;
}
if (Null.IsNotNull(dr["CreatedTime"]))
{
waterLeveldam.CreatedTime = Convert.ToString(dr["CreatedTime"]);
}
else
{
waterLeveldam.CreatedTime = string.Empty;
}
if (Null.IsNotNull(dr["Status"]))
{
waterLeveldam.Status = Convert.ToString(dr["Status"]);
}
else
{
waterLeveldam.Status = string.Empty;
}
}
}
return(waterLeveldam);
}
