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