/// <summary>
/// To Update CDAP Budget Sub Item
/// </summary>
/// <param name="objCDAPBudgetMasterBO"></param>
/// <returns></returns>
public string UpdateCDAPBudgetSubItem(CDAPBudgetDescrMasterBO objCDAPBudgetMasterBO)
{
cnn = new OracleConnection(con);
string returnResult = "";
proc = "USP_MST_UPD_CDAP_SUBCATEG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("CDAP_SUBCATEGORYID_", objCDAPBudgetMasterBO.SubCategoryID);
cmd.Parameters.Add("CDAP_CATEGORYID_", objCDAPBudgetMasterBO.CategoryID);
cmd.Parameters.Add("CDAP_SUBCATEGORYNAME_", objCDAPBudgetMasterBO.SubCategoryName);
cmd.Parameters.Add("UPDATEDBY_", objCDAPBudgetMasterBO.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();
}
cmd.Connection.Close();
return(returnResult);
}
/// <summary>
/// used to fetch details from database
/// </summary>
private void GetBudgetItem()
{
ITEMBLL objItemBLL = new ITEMBLL();
CDAPBudgetDescrMasterBO objBudget = objItemBLL.GetCDAPBudgetSubItemByID(Convert.ToInt32(ViewState["CDAPBUDGETDESCRID"]));
if (objBudget != null)
{
txtBudgetItem.Text = objBudget.SubCategoryName;
}
objBudget = null;
objItemBLL = null;
}
/// <summary>
/// used to update details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UpdateBudgetItem()
{
ITEMBLL objItemBLL = new ITEMBLL();
CDAPBudgetDescrMasterBO objBudget = new CDAPBudgetDescrMasterBO();
string message = "";
try
{
if (ViewState["CDAPBUDGETDESCRID"] != null)
{
objBudget.SubCategoryID = Convert.ToInt32(ViewState["CDAPBUDGETDESCRID"].ToString());
}
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
objBudget.CategoryID = Convert.ToInt32(ViewState["CATEGORY_ID"]);
objBudget.SubCategoryName = txtBudgetItem.Text.Trim();
objBudget.UpdatedBy = Convert.ToInt32(uID);
message = objItemBLL.UpdateCDAPBudgetSubItem(objBudget);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
}
ClearData();
SetUpdateMode(false);
BindGrid();
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objItemBLL = null;
}
}
/// <summary>
/// To Get All CDAP Budget Sub Items
/// </summary>
/// <param name="categoryID"></param>
/// <returns></returns>
public List <CDAPBudgetDescrMasterBO> GetAllCDAPBudgetSubItems(int categoryID)
{
proc = "USP_GET_ALL_MST_CDAP_SUBCATEG";
cnn = new OracleConnection(con);
CDAPBudgetDescrMasterBO objBudgetBO = null;
List <CDAPBudgetDescrMasterBO> CDAPBudgetDescrList = new List <CDAPBudgetDescrMasterBO>();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CDAP_CATEGORYID_", categoryID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objBudgetBO = new CDAPBudgetDescrMasterBO();
if (!dr.IsDBNull(dr.GetOrdinal("CDAP_SUBCATEGORYID")))
{
objBudgetBO.SubCategoryID = dr.GetInt32(dr.GetOrdinal("CDAP_SUBCATEGORYID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CDAP_SUBCATEGORYNAME")))
{
objBudgetBO.SubCategoryName = dr.GetString(dr.GetOrdinal("CDAP_SUBCATEGORYNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objBudgetBO.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
CDAPBudgetDescrList.Add(objBudgetBO);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(CDAPBudgetDescrList);
}
/// <summary>
/// used to save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveBudgetItem()
{
ITEMBLL objItemBLL = new ITEMBLL();
CDAPBudgetDescrMasterBO objBudget = new CDAPBudgetDescrMasterBO();
string message = "";
string Tribe = string.Empty;
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
objBudget.CategoryID = Convert.ToInt32(ViewState["CATEGORY_ID"]);
objBudget.SubCategoryName = txtBudgetItem.Text.Trim();
objBudget.CreatedBy = Convert.ToInt32(uID);
try
{
message = objItemBLL.AddCDAPBudgetSubItem(objBudget);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
ClearData();
BindGrid();
}
catch (Exception ee)
{
throw ee;
}
finally
{
objItemBLL = null;
}
}
/// <summary>
/// To Update CDAP Budget Sub Item
/// </summary>
/// <param name="objCDAPBudgetMasterBO"></param>
/// <returns></returns>
public string UpdateCDAPBudgetSubItem(CDAPBudgetDescrMasterBO objCDAPBudgetMasterBO)
{
return((new ITEMDAL()).UpdateCDAPBudgetSubItem(objCDAPBudgetMasterBO));
}
