/// <summary>
/// To Get Group Ownership By HHID
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public PAP_GroupOwnershipList GetGroupOwnershipByHHID(int HHID)
{
PAP_GroupOwnershipBO objGroupOwnership = null;
PAP_GroupOwnershipList PAP_GroupOwnershiplist1;
try
{
cnn = new OracleConnection(con);
cmd = new OracleCommand("USP_TRN_GET_PAP_GROUPMEMBERS", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHIDIN", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cnn.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PAP_GroupOwnershiplist1 = new PAP_GroupOwnershipList();
while (dr.Read())
{
objGroupOwnership = new PAP_GroupOwnershipBO();
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objGroupOwnership.HHID = dr.GetInt32(dr.GetOrdinal("HHID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("GROUPMEMBERID")))
{
objGroupOwnership.Groupmemberid = dr.GetInt32(dr.GetOrdinal("GROUPMEMBERID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("SURNAME")))
{
objGroupOwnership.SurnameIN = dr.GetString(dr.GetOrdinal("SURNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("FIRSTNAME")))
{
objGroupOwnership.FirstnameIN = dr.GetString(dr.GetOrdinal("FIRSTNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OTHERNAME")))
{
objGroupOwnership.OthernameIN = dr.GetString(dr.GetOrdinal("OTHERNAME"));
}
PAP_GroupOwnershiplist1.Add(objGroupOwnership);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(PAP_GroupOwnershiplist1);
}
/// <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 grdGroupMembers_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["Groupmemberid"] = e.CommandArgument;
PAP_GroupOwnershipBLL objGroupOwnershipBLL = new PAP_GroupOwnershipBLL();
PAP_GroupOwnershipList objGroupOwnershipList = objGroupOwnershipBLL.GetGroupOwnershipByHHID(Convert.ToInt32(Session["HH_ID"]));
if (objGroupOwnershipList.Count > 0)
{
for (int iset = 0; iset < objGroupOwnershipList.Count; iset++)
{
if (Convert.ToString(ViewState["Groupmemberid"]) == Convert.ToString(objGroupOwnershipList[iset].Groupmemberid))
{
txtMeberSurname.Text = objGroupOwnershipList[iset].SurnameIN;
txtMeberFirstname.Text = objGroupOwnershipList[iset].FirstnameIN;
txtMeberOthername.Text = objGroupOwnershipList[iset].OthernameIN;
txtMeberFullname.Text = txtMeberSurname.Text + " " + txtMeberFirstname.Text;
btnSavemember.Text = "Update";
btnClearMember.Text = "Cancel";
}
}
}
}
else if (e.CommandName == "DeleteRow")
{
PAP_GroupOwnershipBLL objGroupOwnershipBLL = new PAP_GroupOwnershipBLL();
objGroupOwnershipBLL.DeleteGroupOwnershipByGMID(Convert.ToInt32(e.CommandArgument));
// Reload Pap Details
ReCache(Convert.ToInt32(Session["HH_ID"]));
ViewState["RELATION_ID"] = "0";
txtMeberSurname.Text = "";
txtMeberFirstname.Text = "";
txtMeberOthername.Text = "";
txtMeberFullname.Text = "";
ViewState["Groupmemberid"] = 0;
btnSavemember.Text = "Save";
btnClearMember.Text = "Clear";
BindGrid();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Selected Group Member Deleted successfully');", true);
}
}
