/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdAffectedLandUsers_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["LANDUSER_ID"] = e.CommandArgument;
PAP_RelationBLL objAffLandUserBLL = new PAP_RelationBLL();
PAP_AffectedLandUserList AffecLandUserList = objAffLandUserBLL.GetAffectedLandUsers(Convert.ToInt32(ViewState["LANDUSER_ID"]), Convert.ToInt32(Session["HH_ID"]));
AffectedLandUserBO objAffLandUser = AffecLandUserList[0];
txtAffecLandUserName.Text = objAffLandUser.LandUserName;
ddlStatus.ClearSelection();
ddlStatus.Items.FindByValue(objAffLandUser.StatusID.ToString()).Selected = true;
txtRelatedTo.Text = objAffLandUser.RelatedTo;
txtTimeOnLand.Text = objAffLandUser.TimeOnLand;
SetLandUserUPDMode(true);
}
else if (e.CommandName == "DeleteRow")
{
ViewState["LANDUSER_ID"] = e.CommandArgument;
PAP_RelationBLL objAffLandUserBLL = new PAP_RelationBLL();
objAffLandUserBLL.DeleteAffectedLandUser(Convert.ToInt32(ViewState["LANDUSER_ID"]), Convert.ToInt32(Session["USER_ID"]));
ClearLandUserDetails();
SetLandUserUPDMode(false);
BindAffectedLandUsers();
}
}
/// <summary>
/// To Get Affected Land Users
/// </summary>
/// <param name="landUserID"></param>
/// <param name="householdID"></param>
/// <returns></returns>
public PAP_AffectedLandUserList GetAffectedLandUsers(int landUserID, int householdID)
{
proc = "USP_TRN_GET_AFFECTEDLNDUSERS";
cnn = new OracleConnection(con);
AffectedLandUserBO objAffecLandUser = null;
PAP_AffectedLandUserList AffecLandUserList = new PAP_AffectedLandUserList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
if (landUserID > 0)
{
cmd.Parameters.Add("LANDUSERID_", landUserID);
}
else
{
cmd.Parameters.Add("LANDUSERID_", DBNull.Value);
}
cmd.Parameters.Add("HOUSEHOLDID_", householdID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objAffecLandUser = new AffectedLandUserBO();
if (!dr.IsDBNull(dr.GetOrdinal("LANDUSERID")))
{
objAffecLandUser.LandUserID = dr.GetInt32(dr.GetOrdinal("LANDUSERID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objAffecLandUser.HouseholdID = dr.GetInt32(dr.GetOrdinal("HHID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LANDUSERNAME")))
{
objAffecLandUser.LandUserName = dr.GetString(dr.GetOrdinal("LANDUSERNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("STATUSID")))
{
objAffecLandUser.StatusID = dr.GetInt32(dr.GetOrdinal("STATUSID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("STATUSNAME")))
{
objAffecLandUser.StatusName = dr.GetString(dr.GetOrdinal("STATUSNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("RELATEDTO")))
{
objAffecLandUser.RelatedTo = dr.GetString(dr.GetOrdinal("RELATEDTO"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TIMEONLAND")))
{
objAffecLandUser.TimeOnLand = dr.GetString(dr.GetOrdinal("TIMEONLAND"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objAffecLandUser.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
AffecLandUserList.Add(objAffecLandUser);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(AffecLandUserList);
}
