/// <summary>
/// To Map Data
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private MemberClaimsBO MapData(IDataReader reader)
{
MemberClaimsBO oMemberClaimsBO = new MemberClaimsBO();
if (ColumnExists(reader, "LND_RESPONDENTID") && !reader.IsDBNull(reader.GetOrdinal("LND_RESPONDENTID")))
{
oMemberClaimsBO.LND_RESPONDENTID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("LND_RESPONDENTID")));
}
if (ColumnExists(reader, "HHID") && !reader.IsDBNull(reader.GetOrdinal("HHID")))
{
oMemberClaimsBO.HHID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("HHID")));
}
if (ColumnExists(reader, "CLAIMDETAILS") && !reader.IsDBNull(reader.GetOrdinal("CLAIMDETAILS")))
{
oMemberClaimsBO.CLAIMDETAILS = reader.GetString(reader.GetOrdinal("CLAIMDETAILS"));
}
if (ColumnExists(reader, "HASCLAIM") && !reader.IsDBNull(reader.GetOrdinal("HASCLAIM")))
{
oMemberClaimsBO.HASCLAIM = reader.GetString(reader.GetOrdinal("HASCLAIM"));
}
if (ColumnExists(reader, "OTHEREASEMENT") && !reader.IsDBNull(reader.GetOrdinal("OTHEREASEMENT")))
{
oMemberClaimsBO.OTHEREASEMENT = reader.GetString(reader.GetOrdinal("OTHEREASEMENT"));
}
if (ColumnExists(reader, "OTHEREASEMENTDETAILS") && !reader.IsDBNull(reader.GetOrdinal("OTHEREASEMENTDETAILS")))
{
oMemberClaimsBO.OTHEREASEMENTDETAILS = reader.GetString(reader.GetOrdinal("OTHEREASEMENTDETAILS"));
}
if (ColumnExists(reader, "OTHPEOPLEACCESSWATER") && !reader.IsDBNull(reader.GetOrdinal("OTHPEOPLEACCESSWATER")))
{
oMemberClaimsBO.OTHPEOPLEACCESSWATER = reader.GetString(reader.GetOrdinal("OTHPEOPLEACCESSWATER"));
}
if (ColumnExists(reader, "OTHPEOPLEPICK") && !reader.IsDBNull(reader.GetOrdinal("OTHPEOPLEPICK")))
{
oMemberClaimsBO.OTHPEOPLEPICK = reader.GetString(reader.GetOrdinal("OTHPEOPLEPICK"));
}
if (ColumnExists(reader, "PICKFROMOTHPEOPLELAND") && !reader.IsDBNull(reader.GetOrdinal("PICKFROMOTHPEOPLELAND")))
{
oMemberClaimsBO.PICKFROMOTHPEOPLELAND = reader.GetString(reader.GetOrdinal("PICKFROMOTHPEOPLELAND"));
}
if (ColumnExists(reader, "ACCESSWATERFRMOTHPEOPLE") && !reader.IsDBNull(reader.GetOrdinal("ACCESSWATERFRMOTHPEOPLE")))
{
oMemberClaimsBO.ACCESSWATERFRMOTHPEOPLE = reader.GetString(reader.GetOrdinal("ACCESSWATERFRMOTHPEOPLE"));
}
return(oMemberClaimsBO);
}
/// <summary>
/// To Add Member
/// </summary>
/// <param name="MCBO"></param>
/// <returns></returns>
public string AddMember(MemberClaimsBO MCBO)
{
string returnResult = string.Empty;
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
int result = 0;
{
try
{
OracleCommand myCommand;
myCommand = new OracleCommand("USP_TRN_INS_PAP_LND_RESPONDENT", con);
myCommand.Connection = con;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("LND_RESPONDENTID_", MCBO.LND_RESPONDENTID);
myCommand.Parameters.Add("HHID_", MCBO.HHID);
myCommand.Parameters.Add("HASCLAIM_", MCBO.HASCLAIM);
myCommand.Parameters.Add("CLAIMDETAILS_", MCBO.CLAIMDETAILS);
myCommand.Parameters.Add("OTHPEOPLEPICK_", MCBO.OTHPEOPLEPICK);
myCommand.Parameters.Add("PICKFROMOTHPEOPLELAND_", MCBO.PICKFROMOTHPEOPLELAND);
myCommand.Parameters.Add("OTHPEOPLEACCESSWATER_", MCBO.OTHPEOPLEACCESSWATER);
myCommand.Parameters.Add("ACCESSWATERFRMOTHPEOPLE_", MCBO.ACCESSWATERFRMOTHPEOPLE);
myCommand.Parameters.Add("OTHEREASEMENT_", MCBO.OTHEREASEMENT);
myCommand.Parameters.Add("OTHEREASEMENTDETAILS_", MCBO.OTHEREASEMENTDETAILS);
myCommand.Parameters.Add("CREATEDBY_", MCBO.CreatedBy);
myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
con.Open();
result = myCommand.ExecuteNonQuery();
if (myCommand.Parameters["errorMessage_"].Value != null)
{
returnResult = myCommand.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch (Exception ex)
{ throw ex; }
finally
{
con.Close();
}
return(returnResult);
}
}
//USP_MST_SELECTCONCERN-SP
/// <summary>
/// To get Member Claim
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public MemberClaimsBO getMemberClaim(int HHID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_PAP_LND_RESPONDENT";
MemberClaimsBO objMemberClaimsBO = null;
try
{
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", HHID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
BatchList oBatchList = new BatchList();
while (dr.Read())
{
objMemberClaimsBO = new MemberClaimsBO();
objMemberClaimsBO = MapData(dr);
//oBatchList.Add(objMemberClaimsBO);
}
dr.Close();
}
catch (Exception ex) { throw ex; }
finally
{
}
return(objMemberClaimsBO);
}
/// <summary>
/// to get the data of the Member claim
/// </summary>
private void getMemberClaim()
{
MemberClaimsBLL oMemberClaimsBLL = new MemberClaimsBLL();
MemberClaimsBO oMemberClaimsBO = new MemberClaimsBO();
oMemberClaimsBO = oMemberClaimsBLL.getMemberClaim(Convert.ToInt32(Session["HH_ID"]));
if (oMemberClaimsBO != null)
{
if (oMemberClaimsBO.HASCLAIM.ToLower() == "Yes".ToLower())
{
ChkHoldings.Checked = true;
txtenterholdings.Enabled = true;
}
else
{
ChkHoldings.Checked = false;
txtenterholdings.Enabled = false;
}
if (oMemberClaimsBO.OTHEREASEMENT.ToLower() == "Yes".ToLower())
{
ChkEasements.Checked = true;
txtentereaseemnts.Enabled = true;
}
else
{
ChkEasements.Checked = false;
txtentereaseemnts.Enabled = false;
}
if (oMemberClaimsBO.PICKFROMOTHPEOPLELAND.ToLower() == "Yes".ToLower())
{
Chkrighttopick.Checked = true;
}
else
{
Chkrighttopick.Checked = false;
}
if (oMemberClaimsBO.OTHPEOPLEACCESSWATER.ToLower() == "Yes".ToLower())
{
Chkotherland.Checked = true;
}
else
{
Chkotherland.Checked = false;
}
if (oMemberClaimsBO.OTHPEOPLEPICK.ToLower() == "Yes".ToLower())
{
Chkwaterother.Checked = true;
}
else
{
Chkwaterother.Checked = false;
}
if (oMemberClaimsBO.ACCESSWATERFRMOTHPEOPLE.ToLower() == "Yes".ToLower())
{
Chkrighttoacess.Checked = true;
}
else
{
Chkrighttoacess.Checked = false;
}
txtenterholdings.Text = oMemberClaimsBO.CLAIMDETAILS;
txtentereaseemnts.Text = oMemberClaimsBO.OTHEREASEMENTDETAILS;
}
}
/// <summary>
/// to save the data members to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Savemambers_Click(object sender, EventArgs e)
{
string message = string.Empty;
string AlertMessage = string.Empty;
MemberClaimsBO MCBO = new MemberClaimsBO();
//MCBO.HOLDINGID = int.Parse(ViewState["LND_HOLDINGID"].ToString());
if (ChkHoldings.Checked == true)
{
MCBO.HASCLAIM = "Yes";
txtenterholdings.Enabled = true;
}
else if (ChkHoldings.Checked == false)
{
MCBO.HASCLAIM = "No";
txtenterholdings.Enabled = false;
}
if (ChkEasements.Checked == true)
{
MCBO.OTHEREASEMENT = "Yes";
txtentereaseemnts.Enabled = true;
}
else if (ChkEasements.Checked == false)
{
MCBO.OTHEREASEMENT = "No";
txtentereaseemnts.Enabled = false;
}
if (Chkrighttopick.Checked == true)
{
MCBO.PICKFROMOTHPEOPLELAND = "Yes";
}
else if (Chkrighttopick.Checked == false)
{
MCBO.PICKFROMOTHPEOPLELAND = "No";
}
if (Chkotherland.Checked == true)
{
MCBO.OTHPEOPLEACCESSWATER = "Yes";
}
else if (Chkotherland.Checked == false)
{
MCBO.OTHPEOPLEACCESSWATER = "No";
}
if (Chkwaterother.Checked == true)
{
MCBO.OTHPEOPLEPICK = "Yes";
}
else if (Chkwaterother.Checked == false)
{
MCBO.OTHPEOPLEPICK = "No";
}
if (Chkrighttoacess.Checked == true)
{
MCBO.ACCESSWATERFRMOTHPEOPLE = "Yes";
}
else if (Chkrighttoacess.Checked == false)
{
MCBO.ACCESSWATERFRMOTHPEOPLE = "No";
}
if (Session["HH_ID"] != null)
{
MCBO.HHID = Convert.ToInt32(Session["HH_ID"].ToString());
}
MCBO.CLAIMDETAILS = txtenterholdings.Text;
MCBO.OTHEREASEMENTDETAILS = txtentereaseemnts.Text;
MCBO.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString());
MemberClaimsBLL objMCBLL = new MemberClaimsBLL();
message = objMCBLL.AddMember(MCBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
//ClearDetails();
projectFrozen();
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
projectFrozen();
ChangeRequestStatusMCE();
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Members respondents updated successfully');", true);
}
/// <summary>
/// To Add Member
/// </summary>
/// <param name="MCBO"></param>
/// <returns></returns>
public string AddMember(MemberClaimsBO MCBO)
{
MemberClaimsDAL objMCDAL = new MemberClaimsDAL();
return(objMCDAL.AddMember(MCBO));
}
