public OptionParameterMappingList GetOptionParameters(int Pid)
{
OracleConnection con = new OracleConnection(connStr);
OracleCommand cmd;
string proc = "USP_GET_PARAMETERS";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("OPTIONAVAILABLEID_", Pid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
OptionParameterMappingBO oOptionParameterBO = null;
OptionParameterMappingList lstOptionGroup = new OptionParameterMappingList();
while (dr.Read())
{
oOptionParameterBO = new OptionParameterMappingBO();
oOptionParameterBO.ID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PARAMETERID"))));
oOptionParameterBO.Name = dr.GetValue(dr.GetOrdinal("PARAMETERNAME")).ToString();
lstOptionGroup.Add(oOptionParameterBO);
}
dr.Close();
return(lstOptionGroup);
}
/// <summary>
/// To fetch data from database based on ParishID
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetParishById()
{
OptionParameterMappingBLL oOptPrmMapBLL = new OptionParameterMappingBLL();
OptionParameterMappingBO oOptPrmMapBO = oOptPrmMapBLL.GetOptionalParameterMappingById(Convert.ToInt32(ViewState["OptParID"]));
if (oOptPrmMapBO != null)
{
//BindOptionAvailable();
//BindOptionGroup();
//BindOptionDescription();
//BindOptionParameters();
ddlParameter.ClearSelection();
ddlOptionGroup.ClearSelection();
ddlOptionAvailable.ClearSelection();
ddlDescription.ClearSelection();
ddlOptionGroup.SelectedValue = oOptPrmMapBO.OptionGroupID.ToString();
ddlOptionAvailable.SelectedValue = oOptPrmMapBO.OptionAvailableID.ToString();
BindOptionParameters();
ddlParameter.SelectedValue = oOptPrmMapBO.ParameterID.ToString();
BindOptionDescription();
ddlDescription.SelectedValue = oOptPrmMapBO.DescriptionID.ToString();
}
SetUpdateMode(true);
}
/// <summary>
/// To Get Option Parameter By Id
/// </summary>
/// <param name="ParishId"></param>
/// <returns></returns>
public OptionParameterMappingBO GetOptionalParameterMappingById(Int32 pOptParameterId)
{
proc = "USP_GET_OPT_PRM_MAPPING_BYID";
cnn = new OracleConnection(connStr);
OptionParameterMappingBO oOptPrmMappingBO = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("OptParID_", pOptParameterId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oOptPrmMappingBO = new OptionParameterMappingBO();
oOptPrmMappingBO = Mapping(dr);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(oOptPrmMappingBO);
}
/// <summary>
/// To Get All Option Parameter
/// </summary>
/// <param name="subcountyid"></param>
/// <param name="countyid"></param>
/// <param name="districtid"></param>
/// <returns></returns>
public OptionParameterMappingList GetAllOptionParameterMapping()
{
OptionParameterMappingList lstOptPrmMapping = null;
using (cnn = new OracleConnection(connStr))
{
using (cmd = new OracleCommand("USP_GET_ALL_OPT_PRM_MAPPING", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("SUBCOUNTYID_", subcountyid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
OptionParameterMappingBO optPrmMappingBO = null;
lstOptPrmMapping = new OptionParameterMappingList();
while (dr.Read())
{
optPrmMappingBO = new OptionParameterMappingBO();
optPrmMappingBO = Mapping(dr);
lstOptPrmMapping.Add(optPrmMappingBO);
}
dr.Close();
}
}
return(lstOptPrmMapping);
}
/// <summary>
/// To Update Option Parameter
/// </summary>
/// <param name="ParishBOobj"></param>
/// <returns></returns>
public String UpdateOptionParameterMapping(OptionParameterMappingBO pOptParmMappingBO)
{
string result = "";
using (cnn = new OracleConnection(connStr))
{
using (cmd = new OracleCommand("USP_MST_UPD_OPT_PRM_MAP", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("OptParID_", pOptParmMappingBO.OptParID);
cmd.Parameters.Add("DescriptionID_", pOptParmMappingBO.DescriptionID);
cmd.Parameters.Add("OptionAvailableID_", pOptParmMappingBO.OptionAvailableID);
cmd.Parameters.Add("OptionGroupID_", pOptParmMappingBO.OptionGroupID);
cmd.Parameters.Add("ParameterID_", pOptParmMappingBO.ParameterID);
cmd.Parameters.Add("UPDATEDBY_", pOptParmMappingBO.UpdatedBy);
cmd.Parameters.Add("ERRORMESSAGE_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["ERRORMESSAGE_"].Value != null)
{
result = cmd.Parameters["ERRORMESSAGE_"].Value.ToString();
}
cmd.Connection.Close();
}
}
return(result);
}
private OptionParameterMappingBO Mapping(IDataReader reader)
{
OptionParameterMappingBO optPrmMappingBO = new OptionParameterMappingBO();
if (ColExists(reader, "OPTPARID") && !reader.IsDBNull(reader.GetOrdinal("OPTPARID")))
{
optPrmMappingBO.OptParID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("OPTPARID")));
}
if (ColExists(reader, "OPTIONGROUPID") && !reader.IsDBNull(reader.GetOrdinal("OPTIONGROUPID")))
{
optPrmMappingBO.OptionGroupID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("OPTIONGROUPID")));
}
if (ColExists(reader, "ID") && !reader.IsDBNull(reader.GetOrdinal("ID")))
{
optPrmMappingBO.OptionAvailableID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("ID")));
}
if (ColExists(reader, "DESCRIPTIONID") && !reader.IsDBNull(reader.GetOrdinal("DESCRIPTIONID")))
{
optPrmMappingBO.DescriptionID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("DESCRIPTIONID")));
}
if (ColExists(reader, "PARAMETERID") && !reader.IsDBNull(reader.GetOrdinal("PARAMETERID")))
{
optPrmMappingBO.ParameterID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("PARAMETERID")));
}
//----------------------------------------------------------------------------------------------------
if (ColExists(reader, "OPTIONGROUP") && !reader.IsDBNull(reader.GetOrdinal("OPTIONGROUP")))
{
optPrmMappingBO.OptionGroup = reader.GetString(reader.GetOrdinal("OPTIONGROUP"));
}
if (ColExists(reader, "OPTIONAVAILABLE") && !reader.IsDBNull(reader.GetOrdinal("OPTIONAVAILABLE")))
{
optPrmMappingBO.OptionAvailable = reader.GetString(reader.GetOrdinal("OPTIONAVAILABLE"));
}
if (ColExists(reader, "DESCRIPTION") && !reader.IsDBNull(reader.GetOrdinal("DESCRIPTION")))
{
optPrmMappingBO.Description = reader.GetString(reader.GetOrdinal("DESCRIPTION"));
}
if (ColExists(reader, "PARAMETERNAME") && !reader.IsDBNull(reader.GetOrdinal("PARAMETERNAME")))
{
optPrmMappingBO.ParameterName = reader.GetString(reader.GetOrdinal("PARAMETERNAME"));
}
if (ColExists(reader, "IsDeleted") && !reader.IsDBNull(reader.GetOrdinal("IsDeleted")))
{
optPrmMappingBO.IsDeleted = reader.GetString(reader.GetOrdinal("IsDeleted"));
}
return(optPrmMappingBO);
}
/// <summary>
/// To update details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Update_OptionParameterMapping()
{
OptionParameterMappingBLL oOptPrmMappingBLL = new OptionParameterMappingBLL();
OptionParameterMappingBO oOptPrmMappingBO = new OptionParameterMappingBO();
string message = "";
try
{
if (ViewState["OptParID"] != null)
{
oOptPrmMappingBO.OptParID = Convert.ToInt32(ViewState["OptParID"].ToString());
}
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
oOptPrmMappingBO.OptionGroupID = Convert.ToInt32(ddlOptionGroup.SelectedItem.Value);
oOptPrmMappingBO.OptionAvailableID = Convert.ToInt32(ddlOptionAvailable.SelectedItem.Value);
oOptPrmMappingBO.DescriptionID = Convert.ToInt32(ddlDescription.SelectedItem.Value);
oOptPrmMappingBO.ParameterID = Convert.ToInt32(ddlParameter.SelectedItem.Value);
oOptPrmMappingBO.CreatedBy = Convert.ToInt32(uID);
oOptPrmMappingBO.UpdatedBy = Convert.ToInt32(uID);
message = oOptPrmMappingBLL.UpdateOptionParameterMapping(oOptPrmMappingBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
//ClearData();
//BindGrid();
SetUpdateMode(false);
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
oOptPrmMappingBO = null;
}
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Save_OptionParameterMapping()
{
OptionParameterMappingBLL oOptPrmMappingBLL = new OptionParameterMappingBLL();
OptionParameterMappingBO oOptPrmMappingBO = new OptionParameterMappingBO();
string message = "";
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
oOptPrmMappingBO.OptionGroupID = Convert.ToInt32(ddlOptionGroup.SelectedItem.Value);
oOptPrmMappingBO.OptionAvailableID = Convert.ToInt32(ddlOptionAvailable.SelectedItem.Value);
oOptPrmMappingBO.DescriptionID = Convert.ToInt32(ddlDescription.SelectedItem.Value);
oOptPrmMappingBO.ParameterID = Convert.ToInt32(ddlParameter.SelectedItem.Value);
oOptPrmMappingBO.CreatedBy = Convert.ToInt32(uID);
try
{
message = oOptPrmMappingBLL.AddOptionParameterMapping(oOptPrmMappingBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ee)
{
throw ee;
}
finally
{
oOptPrmMappingBO = null;
}
}
public String UpdateOptionParameterMapping(OptionParameterMappingBO pOptParmMappingBO)
{
return((new OptionParameterMappingDAL()).UpdateOptionParameterMapping(pOptParmMappingBO));
}
