public OptionGrpParamList getdatatogrid()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_GET_ALL_OPTIONGRP";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
OptionGroupParametersBO objOptionGroupParamBO = null;
OptionGrpParamList OptionGroupLst = new OptionGrpParamList();
while (dr.Read())
{
objOptionGroupParamBO = new OptionGroupParametersBO();
objOptionGroupParamBO.ParamID = dr.GetInt32(dr.GetOrdinal("PARAMETERID"));
objOptionGroupParamBO.Optiongrpname = dr.GetString(dr.GetOrdinal("OPTIONGROUP"));
objOptionGroupParamBO.Optiongrpstatusname = dr.GetString(dr.GetOrdinal("papdesignation"));
objOptionGroupParamBO.IsResident = dr.GetString(dr.GetOrdinal("ISRESIDENT"));
objOptionGroupParamBO.LandCompensation = dr.GetString(dr.GetOrdinal("LANDCOMPENSATION"));
objOptionGroupParamBO.HouseCompensation = dr.GetString(dr.GetOrdinal("HOUSECOMPENSATION"));
OptionGroupLst.Add(objOptionGroupParamBO);
}
dr.Close();
return(OptionGroupLst);
}
public string UpdateOptionGroup(OptionGroupParametersBO objOptionGroupParametersBO)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_MST_UPD_OPTIONGRP";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("paramID_", objOptionGroupParametersBO.ParamID);
cmd.Parameters.Add("OptionGrpID_", objOptionGroupParametersBO.OptionGrpID);
cmd.Parameters.Add("OptionStatusID_", objOptionGroupParametersBO.OptionstatusID);
cmd.Parameters.Add("IsResident_", objOptionGroupParametersBO.IsResident);
cmd.Parameters.Add("landCompen_", objOptionGroupParametersBO.LandCompensation);
cmd.Parameters.Add("HouseCompen_", objOptionGroupParametersBO.HouseCompensation);
cmd.Parameters.Add("updatedBy_", objOptionGroupParametersBO.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);
}
public string SaveOptionGroup(OptionGroupParametersBO objOptionGroupParametersBO)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_MST_INS_OPTIONGRPPARAMETER";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("OPTIONGROUPID_", objOptionGroupParametersBO.OptionGrpID);
cmd.Parameters.Add("LANDSTATUSID_", objOptionGroupParametersBO.OptionstatusID);
cmd.Parameters.Add("ISRESIDENT_", objOptionGroupParametersBO.IsResident);
cmd.Parameters.Add("LANDCOMPENSATION_", objOptionGroupParametersBO.LandCompensation);
cmd.Parameters.Add("HOUSECOMPENSATION_", objOptionGroupParametersBO.HouseCompensation);
cmd.Parameters.Add("CREATEDBY_", objOptionGroupParametersBO.Createdby);
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);
}
public OptionGroupParametersBO GetOptionalDetailsByID(int paramID)
{
proc = "USP_GET_OPTIONGRPDETAILS_BYID";
cnn = new OracleConnection(con);
OptionGroupParametersBO objGrpParam = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("paraID_", paramID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objGrpParam = new OptionGroupParametersBO();
if (!dr.IsDBNull(dr.GetOrdinal("PARAMETERID")))
{
objGrpParam.ParamID = dr.GetInt32(dr.GetOrdinal("PARAMETERID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OPTIONGROUPID")))
{
objGrpParam.OptionGrpID = dr.GetInt32(dr.GetOrdinal("OPTIONGROUPID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LANDSTATUSID")))
{
objGrpParam.OptionstatusID = dr.GetInt32(dr.GetOrdinal("LANDSTATUSID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISRESIDENT")))
{
objGrpParam.IsResident = dr.GetString(dr.GetOrdinal("ISRESIDENT"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LANDCOMPENSATION")))
{
objGrpParam.LandCompensation = dr.GetString(dr.GetOrdinal("LANDCOMPENSATION"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HOUSECOMPENSATION")))
{
objGrpParam.HouseCompensation = dr.GetString(dr.GetOrdinal("HOUSECOMPENSATION"));
}
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(objGrpParam);
}
public string SaveOptionGrp(OptionGroupParametersBO objgrpparam)
{
return((new OptionGroupParametersDAL()).SaveOptionGroup(objgrpparam));
}
public string UpdateOptionGroup(OptionGroupParametersBO objOptionGroupParametersBO)
{
return((new OptionGroupParametersDAL()).UpdateOptionGroup(objOptionGroupParametersBO));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "Save")
{
string AlertMessage = string.Empty;
OptionGroupParametersBO objgrpParamBO = new OptionGroupParametersBO();
objgrpParamBO.OptionGrpID = Convert.ToInt32(ddloptionGroup.SelectedValue);
objgrpParamBO.OptionstatusID = Convert.ToInt32(OccupationStatus.SelectedValue);
if (RdbtnYES.Checked == true)
{
objgrpParamBO.IsResident = "Yes";
}
else
{
objgrpParamBO.IsResident = "No";
}
if (RdbtnCash.Checked == true)
{
objgrpParamBO.LandCompensation = "Cash";
}
else if (Rdbtninkind.Checked == true)
{
objgrpParamBO.LandCompensation = "In Kind";
}
else if (RdbtnBoth.Checked == true)
{
objgrpParamBO.LandCompensation = "Both";
}
if (RdbtnHcash.Checked == true)
{
objgrpParamBO.HouseCompensation = "Cash";
}
else if (RdbtnHbtninkind.Checked == true)
{
objgrpParamBO.HouseCompensation = "In Kind";
}
else if (RdbtnHBoth.Checked == true)
{
objgrpParamBO.HouseCompensation = "Both";
}
objgrpParamBO.Createdby = Convert.ToInt32(Session["USER_ID"]);
OptionGroupParametersBLL objgrpParam = new OptionGroupParametersBLL();
string res = objgrpParam.SaveOptionGrp(objgrpParamBO);
if (string.IsNullOrEmpty(res) || res == "" || res == "null")
{
res = "Data saved successfully";
clearDetails();
AlertMessage = "alert('" + res + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
loadGrid();
}
AlertMessage = "alert('" + res + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clearDetails();
}
else if (btnAdd.Text == "Update")
{
string AlertMessage = string.Empty;
OptionGroupParametersBO objgrpParamBO = new OptionGroupParametersBO();
objgrpParamBO.ParamID = Convert.ToInt32(ViewState["ParamID"]);
objgrpParamBO.OptionGrpID = Convert.ToInt32(ddloptionGroup.SelectedValue);
objgrpParamBO.OptionstatusID = Convert.ToInt32(OccupationStatus.SelectedValue);
if (RdbtnYES.Checked == true)
{
objgrpParamBO.IsResident = "Yes";
}
else
{
objgrpParamBO.IsResident = "No";
}
if (RdbtnCash.Checked == true)
{
objgrpParamBO.LandCompensation = "Cash";
}
else if (Rdbtninkind.Checked == true)
{
objgrpParamBO.LandCompensation = "In Kind";
}
else
{
objgrpParamBO.LandCompensation = "Both";
}
if (RdbtnHcash.Checked == true)
{
objgrpParamBO.HouseCompensation = "Cash";
}
else if (RdbtnHbtninkind.Checked == true)
{
objgrpParamBO.HouseCompensation = "In Kind";
}
else
{
objgrpParamBO.HouseCompensation = "Both";
}
objgrpParamBO.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
OptionGroupParametersBLL objgrpParam = new OptionGroupParametersBLL();
string res = objgrpParam.UpdateOptionGroup(objgrpParamBO);
if (string.IsNullOrEmpty(res) || res == "" || res == "null")
{
res = "Data Updated successfully";
clearDetails();
AlertMessage = "alert('" + res + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
else
{
AlertMessage = "alert('" + res + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clearDetails();
}
btnAdd.Text = "Save";
btnCncl.Text = "Clear";
loadGrid();
}
}
protected void grdOptionGrp_RowCommand(object sender, GridViewCommandEventArgs e)
{
string message = string.Empty;
if (e.CommandName == "EditRow")
{
ViewState["ParamID"] = Convert.ToInt32(e.CommandArgument);
int paramid = Convert.ToInt32(ViewState["ParamID"]);
OptionGroupParametersBLL objgrpParam = new OptionGroupParametersBLL();
OptionGroupParametersBO objgrpDetails = objgrpParam.GetOptionalDetailsByID(paramid);
ddloptionGroup.SelectedValue = Convert.ToString(objgrpDetails.OptionGrpID);
OccupationStatus.SelectedValue = Convert.ToString(objgrpDetails.OptionstatusID);
if (objgrpDetails.IsResident == "Yes")
{
RdbtnYES.Checked = true;
}
else
{
RdbtnNO.Checked = true;
}
if (objgrpDetails.LandCompensation == "Cash")
{
RdbtnCash.Checked = true;
}
else if (objgrpDetails.LandCompensation == "In kind")
{
Rdbtninkind.Checked = true;
}
else if (objgrpDetails.LandCompensation == "Both")
{
RdbtnBoth.Checked = true;
}
if (objgrpDetails.HouseCompensation == "Cash")
{
RdbtnHcash.Checked = true;
}
else if (objgrpDetails.HouseCompensation == "In kind")
{
Rdbtninkind.Checked = true;
}
else if (objgrpDetails.HouseCompensation == "Both")
{
RdbtnHBoth.Checked = true;
}
btnAdd.Text = "Update";
btnCncl.Text = "Cancel";
}
else if (e.CommandName == "DeleteRow")
{
ViewState["ParamID"] = Convert.ToInt32(e.CommandArgument);
int paramid = Convert.ToInt32(ViewState["ParamID"]);
OptionGroupParametersBLL objgrpParam = new OptionGroupParametersBLL();
message = objgrpParam.DeleteOptionGrp(paramid);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data deleted successfully";
}
clearDetails();
loadGrid();
}
}
