/// <summary>
/// To Get Sub Category
/// </summary>
/// <returns></returns>
public SubCategoryList GetSubCategory()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SEL_SUB_CATG";
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);
SubCategoryBO SubCategoryBOobj = null;
SubCategoryList SubCategoryListobj = new SubCategoryList();
while (dr.Read())
{
SubCategoryBOobj = new SubCategoryBO();
SubCategoryBOobj.BGT_SUBCATEGORYID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("bgt_subcategoryid")));
SubCategoryBOobj.BGT_SUBCATEGORYNAME = dr.GetString(dr.GetOrdinal("bgt_subcategoryname"));
SubCategoryBOobj.ACCOUNTCODE = dr.GetString(dr.GetOrdinal("accountcode"));
SubCategoryBOobj.ISDELETED = dr.GetString(dr.GetOrdinal("isdeleted"));
SubCategoryListobj.Add(SubCategoryBOobj);
}
dr.Close();
return(SubCategoryListobj);
}
public List <SubCategory> GetSubCategoryById(int CategoryID)
{
try
{
SubCategoryBO subCategoryBO = new SubCategoryBO();
return(subCategoryBO.GetSubCategoryById(CategoryID));
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignMod");
throw;
}
}
private void GetSubCategoryDetails()
{
SubCategoryBLL SubCategoryBLLobj = new SubCategoryBLL();
int SUBCATEGORYID = 0;
if (ViewState["BGT_SUBCATEGORYID"] != null)
{
SUBCATEGORYID = Convert.ToInt32(ViewState["BGT_SUBCATEGORYID"]);
}
SubCategoryBO SubCategoryBOobj = new SubCategoryBO();
SubCategoryBOobj = SubCategoryBLLobj.GetSubCategoryById(SUBCATEGORYID);
SubcategoryTextBox.Text = SubCategoryBOobj.BGT_SUBCATEGORYNAME;
}
/// <summary>
/// To Edit database
/// </summary>
/// <param name="SubCategoryBOobj"></param>
/// <returns></returns>
public string Edit(SubCategoryBO SubCategoryBOobj)
{
SubCategoryDAL SubCategoryDALobj = new SubCategoryDAL(); //Data pass -to Database Layer
try
{
return(SubCategoryDALobj.Edit(SubCategoryBOobj));
}
catch
{
throw;
}
finally
{
SubCategoryDALobj = null;
}
}
/// <summary>
/// To Edit database
/// </summary>
/// <param name="SubCategoryBOobj"></param>
/// <returns></returns>
public string Edit(SubCategoryBO SubCategoryBOobj)
{
string returnResult = string.Empty;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_UPD_SUB_CATG", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("BGT_SUBCATEGORYNAME_", SubCategoryBOobj.BGT_SUBCATEGORYNAME);
dcmd.Parameters.Add("BGT_SUBCATEGORYID_", SubCategoryBOobj.BGT_SUBCATEGORYID);
dcmd.Parameters.Add("ACCOUNTCODE_", SubCategoryBOobj.ACCOUNTCODE);
dcmd.Parameters.Add("UPDATEDBY_", SubCategoryBOobj.CREATEDBY);
//return dcmd.ExecuteNonQuery();
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
returnResult = dcmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(returnResult);
}
/// <summary>
/// To Get Sub Category By Id
/// </summary>
/// <param name="SubCATEGORYID"></param>
/// <returns></returns>
public SubCategoryBO GetSubCategoryById(int SubCATEGORYID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_SUB_CATG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("BGT_SUBCATEGORYID_", SubCATEGORYID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SubCategoryBO SubCategoryBOobj = null;
SubCategoryList SubCategoryListobj = new SubCategoryList();
SubCategoryBOobj = new SubCategoryBO();
while (dr.Read())
{
if (ColumnExists(dr, "BGT_SUBCATEGORYNAME") && !dr.IsDBNull(dr.GetOrdinal("BGT_SUBCATEGORYNAME")))
{
SubCategoryBOobj.BGT_SUBCATEGORYNAME = dr.GetString(dr.GetOrdinal("BGT_SUBCATEGORYNAME"));
}
if (ColumnExists(dr, "ACCOUNTCODE") && !dr.IsDBNull(dr.GetOrdinal("ACCOUNTCODE")))
{
SubCategoryBOobj.ACCOUNTCODE = dr.GetString(dr.GetOrdinal("ACCOUNTCODE"));
}
if (ColumnExists(dr, "BGT_SUBCATEGORYID") && !dr.IsDBNull(dr.GetOrdinal("BGT_SUBCATEGORYID")))
{
SubCategoryBOobj.BGT_SUBCATEGORYID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_SUBCATEGORYID")));
}
}
dr.Close();
return(SubCategoryBOobj);
}
/// <summary>
/// Used to save details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string AlertMessage = string.Empty;
string message = string.Empty;
if (ViewState["BGT_SUBCATEGORYID"].ToString() == "0")
{
SubCategoryBLL SubCategoryBLLobj = new SubCategoryBLL();
try
{
string uID = Session["USER_ID"].ToString();
SubCategoryBO SubCategoryBOobj = new SubCategoryBO();
SubCategoryBOobj.BGT_SUBCATEGORYNAME = SubcategoryTextBox.Text.ToString().Trim();
SubCategoryBOobj.BGT_CATEGORYID = Convert.ToInt32(Convert.ToInt32(ViewState["BGT_CATEGORYID"]));
SubCategoryBOobj.ACCOUNTCODE = txtAccountCode.Text.Trim();
SubCategoryBOobj.CREATEDBY = Convert.ToInt32(uID);
SubCategoryBLL BLLobj = new SubCategoryBLL();
message = BLLobj.Insert(SubCategoryBOobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
ClearAll();
BindGrid(true, true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
SubCategoryBLLobj = null;
}
}
else
{
SubCategoryBLL SubCategoryBLLobj = new SubCategoryBLL();
try
{
string uID = Session["USER_ID"].ToString();
SubCategoryBO SubCategoryBOobj = new SubCategoryBO();
SubCategoryBOobj.BGT_SUBCATEGORYNAME = SubcategoryTextBox.Text.ToString().Trim();
SubCategoryBOobj.BGT_SUBCATEGORYID = Convert.ToInt32(ViewState["BGT_SUBCATEGORYID"]);
SubCategoryBOobj.ACCOUNTCODE = txtAccountCode.Text.Trim();
SubCategoryBOobj.CREATEDBY = Convert.ToInt32(uID);
SubCategoryBLL BLLobj = new SubCategoryBLL();
message = BLLobj.Edit(SubCategoryBOobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
ClearAll();
BindGrid(true, true);
SetUpdateMode(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
SubCategoryBLLobj = null;
}
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
