/// <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 Update Affected Land User
/// </summary>
/// <param name="objAffLandUser"></param>
/// <returns></returns>
public string UpdateAffectedLandUser(AffectedLandUserBO objAffLandUser)
{
string returnResult = string.Empty;
cnn = new OracleConnection(con);
proc = "USP_TRN_UPD_AFFECTEDLNDUSERS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("LANDUSERID_", objAffLandUser.LandUserID);
cmd.Parameters.Add("HOUSEHOLDID_", objAffLandUser.HouseholdID);
cmd.Parameters.Add("LANDUSERNAME_", objAffLandUser.LandUserName);
cmd.Parameters.Add("STATUSID_", objAffLandUser.StatusID);
cmd.Parameters.Add("RELATEDTO_", objAffLandUser.RelatedTo);
cmd.Parameters.Add("TIMEONLAND_", objAffLandUser.TimeOnLand);
cmd.Parameters.Add("UPDATEDBY_", objAffLandUser.UpdatedBy);
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null)
{
returnResult = cmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
cmd.Connection.Close();
return(returnResult);
}
/// <summary>
/// to save the data to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveLandUser_Click(object sender, EventArgs e)
{
string AlertMessage = string.Empty;
string message = string.Empty;
AffectedLandUserBO objAffLandUser = new AffectedLandUserBO();
objAffLandUser.LandUserName = txtAffecLandUserName.Text.Trim();
objAffLandUser.HouseholdID = Convert.ToInt32(Session["HH_ID"]);
objAffLandUser.StatusID = Convert.ToInt32(ddlStatus.SelectedItem.Value);
objAffLandUser.RelatedTo = txtRelatedTo.Text.Trim();
objAffLandUser.TimeOnLand = txtTimeOnLand.Text.Trim();
if (Convert.ToInt32(ViewState["LANDUSER_ID"]) > 0)
{
objAffLandUser.LandUserID = Convert.ToInt32(ViewState["LANDUSER_ID"]);
objAffLandUser.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
message = (new PAP_RelationBLL()).UpdateAffectedLandUser(objAffLandUser);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
SetLandUserUPDMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "LandUserUpdated", "alert('" + message + "');", true);
}
else
{
objAffLandUser.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
message = (new PAP_RelationBLL()).AddAffectedLandUser(objAffLandUser);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "LandUserAdded", "alert('" + message + "');", true);
}
ClearLandUserDetails();
BindAffectedLandUsers();
ChangeRequestStatusLNDUsers();
projectFrozen();
}
/// <summary>
/// To Update Affected Land User
/// </summary>
/// <param name="objAffLandUser"></param>
/// <returns></returns>
public string UpdateAffectedLandUser(AffectedLandUserBO objAffLandUser)
{
return((new PAP_RelationDAL()).UpdateAffectedLandUser(objAffLandUser));
}
/// <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);
}
