public int AddDonar(ComBudgetDonar objComBudgetDonar, int donarId)
{
Authentication();
BudgetDonar objDal = new BudgetDonar();
return(objDal.AddDonar(objComBudgetDonar, donarId));
}
public int AddDonar(ComBudgetDonar objComBudgetDonar, int donarId)
{
int i = 0;
if (donarId == 0)
{
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("pkg_donar.InsertDonar");
db.AddInParameter(cmd, "v_donar_nep_name", DbType.String, objComBudgetDonar.DonarNepName);
db.AddInParameter(cmd, "v_donar_eng_name", DbType.String, objComBudgetDonar.DonarEngName);
db.AddInParameter(cmd, "v_donar_code", DbType.String, objComBudgetDonar.DonarCode);
db.AddInParameter(cmd, "v_donar_type", DbType.Int32, objComBudgetDonar.DonarType);
db.AddInParameter(cmd, "v_is_enable", DbType.Int16, objComBudgetDonar.IsEnable);
db.AddInParameter(cmd, "v_is_locked", DbType.Int16, objComBudgetDonar.IsLocked);
i = db.ExecuteNonQuery(cmd);
}
else
{
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("pkg_donar.UpdateDonar");
db.AddInParameter(cmd, "v_donar_nep_name", DbType.String, objComBudgetDonar.DonarNepName);
db.AddInParameter(cmd, "v_donar_eng_name", DbType.String, objComBudgetDonar.DonarEngName);
db.AddInParameter(cmd, "v_donar_code", DbType.String, objComBudgetDonar.DonarCode);
db.AddInParameter(cmd, "v_donar_type", DbType.Int32, objComBudgetDonar.DonarType);
db.AddInParameter(cmd, "v_donar_id", DbType.Int16, donarId);
db.AddInParameter(cmd, "v_is_enable", DbType.Int16, objComBudgetDonar.IsEnable);
i = db.ExecuteNonQuery(cmd);
}
return(i);
}
protected void btnMapBudgetDonar_Click(object sender, EventArgs e)
{
objComBudgetDonar = new ComBudgetDonar();
int i = 0;
objComBudgetDonar.BudgetDonarMapId = BudgetDonarMapId;
objComBudgetDonar.BudgetHeadId = ddlBudgetHead.SelectedValue.ToInt32();
objComBudgetDonar.DonarId = ddlDonar.SelectedValue.ToInt32();
objComBudgetDonar.PaymentTypeId = ddlPaymentType.SelectedValue.ToInt32();
objComBudgetDonar.FiscalYearId = ddlFiscalYear.SelectedValue.ToInt32();
objComBudgetDonar.IsEnable = (chkIsEnable.Checked) ? 1 : 0;
objComBudgetDonar.IsLocked = 0;
if (BudgetDonarMapId == 0)
{
objComBudgetDonar.Mode = "I";
}
else
{
objComBudgetDonar.Mode = "U";
}
objWebService = new BudgetDonarService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBudgetDonar();
i = objWebService.AddEditMapBudgetDonar(objComBudgetDonar);
if (i > 0)
{
Response.Write("<script>alert(' Budget-Donar mapped successfully!')</script>");
Response.Redirect(Constants.ConstantAppPath + "/Modules/Budget/BudgetToLineItemMap.aspx");
}
else
{
Response.Write("<script>alert('Line Item Detail addition failed!')</script>");
}
}
private void BudgetDonarMapDetails(int budgetDonarMapId)
{
objComBudgetDonar = new ComBudgetDonar();
objComBudgetDonar.BudgetDonarMapId = budgetDonarMapId;
objWebService = new BudgetDonarService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBudgetDonar();
dtPopulateBudgetDonarMapDetails = objWebService.PopulateBudgetDonarMapDetails(objComBudgetDonar);
if (dtPopulateBudgetDonarMapDetails != null && dtPopulateBudgetDonarMapDetails.Rows.Count > 0)
{
ddlBudgetHead.SelectedValue = dtPopulateBudgetDonarMapDetails.Rows[0]["BUDG_HEAD_ID"].ToString();
ddlDonar.SelectedValue = dtPopulateBudgetDonarMapDetails.Rows[0]["DONAR_ID"].ToString();
ddlPaymentType.SelectedValue = dtPopulateBudgetDonarMapDetails.Rows[0]["PAYMENT_TYPE_ID"].ToString();
ddlFiscalYear.SelectedValue = dtPopulateBudgetDonarMapDetails.Rows[0]["FISCAL_YEAR_ID"].ToString();
if ((dtPopulateBudgetDonarMapDetails.Rows[0]["IS_ENABLE"]).ToInt32() == 1)
{
chkIsEnable.Checked = true;
}
else
{
chkIsEnable.Checked = false;
}
}
}
