/// <summary>
/// To Update CDAP Budget Master
/// </summary>
/// <param name="objCDAPBudgetMasterBO"></param>
/// <returns></returns>
public string UpdateCDAPBudgetMaster(CDAPBudgetMasterBO objCDAPBudgetMasterBO)
{
cnn = new OracleConnection(con);
string returnResult = "";
proc = "USP_MST_UPD_CDAP_CATEG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("CDAP_CATEGORYID_", objCDAPBudgetMasterBO.CategoryID);
cmd.Parameters.Add("CDAP_CATEGORYNAME_", objCDAPBudgetMasterBO.CategoryName);
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
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetBudgetItemName()
{
CDAPBudgetMasterBO objBudgetItem = (new ITEMBLL()).GetCDAPBudgetItemByID(Convert.ToInt32(ViewState["CATEGORY_ID"]));
if (objBudgetItem != null)
{
Master.PageHeader = "Item Descriptions for " + objBudgetItem.CategoryName;
}
else
{
Master.PageHeader = "CDAP Budget Item Description";
}
}
/// <summary>
/// used to fetch details from database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetBudgetItem()
{
ITEMBLL objItemBLL = new ITEMBLL();
CDAPBudgetMasterBO objBudget = objItemBLL.GetCDAPBudgetItemByID(Convert.ToInt32(ViewState["CDAPBUDGETID"]));
if (objBudget != null)
{
txtBudgetItem.Text = objBudget.CategoryName;
}
objBudget = null;
objItemBLL = null;
}
/// <summary>
/// used to update data into database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UpdateBudgetItem()
{
ITEMBLL objItemBLL = new ITEMBLL();
CDAPBudgetMasterBO objBudget = new CDAPBudgetMasterBO();
string message = "";
try
{
if (ViewState["CDAPBUDGETID"] != null)
{
objBudget.CategoryID = Convert.ToInt32(ViewState["CDAPBUDGETID"].ToString());
}
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
objBudget.CategoryName = txtBudgetItem.Text.Trim();
objBudget.UpdatedBy = Convert.ToInt32(uID);
message = objItemBLL.UpdateCDAPBudgetMaster(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 Items
/// </summary>
/// <returns></returns>
public List <CDAPBudgetMasterBO> GetAllCDAPBudgetItems()
{
proc = "USP_GET_ALL_MST_CDAP_CATEG";
cnn = new OracleConnection(con);
CDAPBudgetMasterBO objBudgetBO = null;
List <CDAPBudgetMasterBO> CDAPBudgetMasterList = new List <CDAPBudgetMasterBO>();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
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 CDAPBudgetMasterBO();
if (!dr.IsDBNull(dr.GetOrdinal("CDAP_CATEGORYID")))
{
objBudgetBO.CategoryID = dr.GetInt32(dr.GetOrdinal("CDAP_CATEGORYID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CDAP_CATEGORYNAME")))
{
objBudgetBO.CategoryName = dr.GetString(dr.GetOrdinal("CDAP_CATEGORYNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objBudgetBO.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
CDAPBudgetMasterList.Add(objBudgetBO);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(CDAPBudgetMasterList);
}
/// <summary>
/// used to save data into database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveBudgetItem()
{
ITEMBLL objItemBLL = new ITEMBLL();
CDAPBudgetMasterBO objBudget = new CDAPBudgetMasterBO();
string message = "";
string Tribe = string.Empty;
string uID = string.Empty;
uID = Session["USER_ID"].ToString();
objBudget.CategoryName = txtBudgetItem.Text.Trim();
objBudget.CreatedBy = Convert.ToInt32(uID);
try
{
message = objItemBLL.AddCDAPBudgetMaster(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 Master
/// </summary>
/// <param name="objCDAPBudgetMasterBO"></param>
/// <returns></returns>
public string UpdateCDAPBudgetMaster(CDAPBudgetMasterBO objCDAPBudgetMasterBO)
{
return((new ITEMDAL()).UpdateCDAPBudgetMaster(objCDAPBudgetMasterBO));
}
/// <summary>
/// To Add CDAP Budget Master
/// </summary>
/// <param name="objCDAPBudgetMasterBO"></param>
/// <returns></returns>
public string AddCDAPBudgetMaster(CDAPBudgetMasterBO objCDAPBudgetMasterBO)
{
return((new ITEMDAL()).AddCDAPBudgetMaster(objCDAPBudgetMasterBO));
}
