/// <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); }