/// <summary>
/// To Get Option Group
/// </summary>
/// <returns></returns>
public OptionGroupList GetOptionGroup()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETOPTION_GROUPS";
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);
OptionGroupBO objOptionGroupBO = null;
OptionGroupList OptionGroup = new OptionGroupList();
while (dr.Read())
{
objOptionGroupBO = new OptionGroupBO();
objOptionGroupBO.OptionGroupID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("optiongroupid")));
objOptionGroupBO.OptionGroupName = dr.GetString(dr.GetOrdinal("optiongroup"));
objOptionGroupBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
OptionGroup.Add(objOptionGroupBO);
}
dr.Close();
return(OptionGroup);
}
public OptionGroupList GetOptionDescription(int Pid)
{
OracleConnection con = new OracleConnection(connStr);
OracleCommand cmd;
string proc = "USP_DSH_GET_OPT_DESCRIPTION";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PID_", Pid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
OptionGroupBO oOptionGroupBO = null;
OptionGroupList lstOptionGroup = new OptionGroupList();
while (dr.Read())
{
oOptionGroupBO = new OptionGroupBO();
oOptionGroupBO.OptionGroupID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("DESCRIPTIONID"))));
oOptionGroupBO.OptionGroupName = dr.GetValue(dr.GetOrdinal("DESCRIPTION")).ToString();
lstOptionGroup.Add(oOptionGroupBO);
}
dr.Close();
return(lstOptionGroup);
}
/// <summary>
/// To fetch Optiongroup from database
/// </summary>
private void GetOptionGroupDetails()
{
OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL();
int OptionGroupID = 0;
if (ViewState["OptionGroupID"] != null)
{
OptionGroupID = Convert.ToInt32(ViewState["OptionGroupID"]);
}
OptionGroupBO objOptionGroupBO = new OptionGroupBO();
objOptionGroupBO = objOptionGroupBLL.GetOptionGroupById(OptionGroupID);
txtOptionGroup.Text = objOptionGroupBO.OptionGroupName;
}
/// <summary>
/// To Update Option Groups
/// </summary>
/// <param name="objOptionGroupBO"></param>
/// <returns></returns>
public string UpdateOptionGroups(OptionGroupBO objOptionGroupBO)
{
OptionGroupDAL objOptionGroupDAL = new OptionGroupDAL(); //Data pass -to Database Layer
try
{
return(objOptionGroupDAL.UpdateOptionGroups(objOptionGroupBO));
}
catch
{
throw;
}
finally
{
objOptionGroupDAL = null;
}
}
/// <summary>
/// To Update Option Groups
/// </summary>
/// <param name="objOptionGroupBO"></param>
/// <returns></returns>
public string UpdateOptionGroups(OptionGroupBO objOptionGroupBO)
{
string result = "";
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_UPDATEOPTION_GROUPS", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("OPTIONGROUPID_", objOptionGroupBO.OptionGroupID);
dcmd.Parameters.Add("OPTIONGROUP_", objOptionGroupBO.OptionGroupName);
dcmd.Parameters.Add("UPDATEDBY_", objOptionGroupBO.UserID);
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
result = dcmd.Parameters["errorMessage_"].Value.ToString();
}
return(result);
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
/// <summary>
/// To Load Option Group Data
/// </summary>
/// <returns></returns>
public OptionGroupList LoadOptionGroupData()
{
cnn = new OracleConnection(AppConfiguration.ConnectionString);
string proc = "USP_MST_GET_OPTIONGROUPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
OptionGroupBO obMaster = null;
OptionGroupList Master = new OptionGroupList();
while (dr.Read())
{
obMaster = new OptionGroupBO();
obMaster.OptionGroupID = dr.GetInt32(dr.GetOrdinal("ID"));
obMaster.OptionGroupName = dr.GetString(dr.GetOrdinal("Name"));
Master.Add(obMaster);
}
dr.Close();
return(Master);
}
/// <summary>
/// To Get Option Group By Id
/// </summary>
/// <param name="OptionGroupID"></param>
/// <returns></returns>
public OptionGroupBO GetOptionGroupById(int OptionGroupID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETOPTION_GROUPSBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("OPTIONGROUPID_", OptionGroupID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
OptionGroupBO objOptionGroupBO = null;
OptionGroupList OptionGroup = new OptionGroupList();
objOptionGroupBO = new OptionGroupBO();
while (dr.Read())
{
if (ColumnExists(dr, "optiongroupid") && !dr.IsDBNull(dr.GetOrdinal("optiongroupid")))
{
objOptionGroupBO.OptionGroupID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("optiongroupid")));
}
if (ColumnExists(dr, "optiongroup") && !dr.IsDBNull(dr.GetOrdinal("optiongroup")))
{
objOptionGroupBO.OptionGroupName = Convert.ToString(dr.GetValue(dr.GetOrdinal("optiongroup")));
}
if (ColumnExists(dr, "isdeleted") && !dr.IsDBNull(dr.GetOrdinal("isdeleted")))
{
objOptionGroupBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
}
}
dr.Close();
return(objOptionGroupBO);
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string message = "";
OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL();
if (Convert.ToInt32(ViewState["OptionGroupID"]) == 0)
{
try
{
string uID = Session["USER_ID"].ToString();
OptionGroupBO objOptionGroupBO = new OptionGroupBO();
objOptionGroupBO.OptionGroupName = txtOptionGroup.Text.ToString().Trim();
objOptionGroupBO.UserID = Convert.ToInt32(uID);
message = objOptionGroupBLL.InsertOptionGroups(objOptionGroupBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
// txtOptionGroup.Text = "0";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objOptionGroupBLL = null;
}
BindGrid(true, true);
}
//edit the data in the textbox exiting in the Grid
else if (Convert.ToInt32(ViewState["OptionGroupID"]) > 0)
{
try
{
string uID = Session["USER_ID"].ToString();
OptionGroupBO objOptionGroupBO = new OptionGroupBO();
objOptionGroupBO.OptionGroupName = txtOptionGroup.Text.ToString().Trim();
objOptionGroupBO.OptionGroupID = Convert.ToInt32(ViewState["OptionGroupID"]);
objOptionGroupBO.UserID = Convert.ToInt32(uID);
message = objOptionGroupBLL.UpdateOptionGroups(objOptionGroupBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
txtOptionGroup.Text = "0";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objOptionGroupBLL = null;
}
BindGrid(true, true);
SetUpdateMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
ClearData();
}
