public int AddEditBudgetHead(ComBudgetHeadBO objBudget)
{
int i = 0;
if (objBudget.BudgetHeadId == 0)
{
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("pkg_budget_head.InsertBudgetHead");
db.AddInParameter(cmd, "v_Budget_Head_nep_name", DbType.String, objBudget.BudgetHeadNepName);
db.AddInParameter(cmd, "v_Budget_Head_eng_name", DbType.String, objBudget.BudgetHeadEngName);
db.AddInParameter(cmd, "v_Budget_code", DbType.String, objBudget.BudgetCode);
db.AddInParameter(cmd, "v_Fiscal_Year_Id", DbType.Int16, objBudget.FiscalYearId);
db.AddInParameter(cmd, "v_ISENABLE", DbType.Int16, objBudget.IsEnable);
db.AddInParameter(cmd, "v_ISLOCKED", DbType.Int16, objBudget.IsLocked);
i = db.ExecuteNonQuery(cmd);
}
else
{
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("pkg_budget_head.UpdateBudgetHead");
db.AddInParameter(cmd, "v_Budget_Head_nep_name", DbType.String, objBudget.BudgetHeadNepName);
db.AddInParameter(cmd, "v_Budget_Head_eng_name", DbType.String, objBudget.BudgetHeadEngName);
db.AddInParameter(cmd, "v_Budget_code", DbType.String, objBudget.BudgetCode);
db.AddInParameter(cmd, "v_Budget_Head_id", DbType.Int16, objBudget.BudgetHeadId);
db.AddInParameter(cmd, "v_Fiscal_Year_Id", DbType.Int16, objBudget.FiscalYearId);
db.AddInParameter(cmd, "v_ISENABLE", DbType.Int16, objBudget.IsEnable);
i = db.ExecuteNonQuery(cmd);
}
return(i);
}
protected void btnAddBudgetHead_Click(object sender, EventArgs e)
{
int i = 0;
objBudgetBo = new ComBudgetHeadBO();
objBudgetBo.BudgetHeadEngName = txtBudgetHeadEnglishName.Text;
objBudgetBo.BudgetHeadNepName = txtBudgetHeadNepaliName.Text;
objBudgetBo.BudgetCode = txtBudgetCode.Text;
objBudgetBo.FiscalYearId = ddlFiscalYear.SelectedValue.ToInt32();
objBudgetBo.BudgetHeadId = Session["budgetHeadId"].ToInt32();
objBudgetBo.IsLocked = 0;
if (chkIsEnable.Checked == true)
{
objBudgetBo.IsEnable = 1;
}
else
{
objBudgetBo.IsEnable = 0;
}
objWebService = new Service1();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthentication();
i = objWebService.AddEditBudgetHead(objBudgetBo);
if (i > 0)
{
Response.Write("<script>alert('Budget Head added successfully!')</script>");
Response.Redirect(Constants.ConstantAppPath + "/Modules/Budget/BudgHeadList1.aspx");
}
else
{
Response.Write("<script>alert('Budget Head addition failed!')</script>");
}
}
public int AddEditBudgetHead(ComBudgetHeadBO objBudget)
{
Base objDal = new Base();
return(objDal.AddEditBudgetHead(objBudget));
}
