public int InsertUpdateProjectBudgetDetail(ProjectBudgetDetailBO objProjectBudgetDetail) { int i = 0; DbCommand cmd = null; cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_PROJECT_BUDGET_DETAIL"); db.AddInParameter(cmd, "V_MODE", DbType.String, objProjectBudgetDetail.Mode); db.AddInParameter(cmd, "V_BUDG_BADFAD_ID", DbType.Decimal, objProjectBudgetDetail.BudgBadfadId); db.AddInParameter(cmd, "V_BADFAD_ID", DbType.Decimal, objProjectBudgetDetail.BadfadId); db.AddInParameter(cmd, "V_FIRST_T_RAKAM", DbType.Decimal, objProjectBudgetDetail.FirstTRakam); db.AddInParameter(cmd, "V_SECOND_T_RAKAM", DbType.Decimal, objProjectBudgetDetail.SecondTRakam); db.AddInParameter(cmd, "V_THIRD_C_RAKAM", DbType.Decimal, objProjectBudgetDetail.ThirdCRakam); db.AddInParameter(cmd, "V_FIRST_P_RAKAM", DbType.Decimal, objProjectBudgetDetail.FirstPRakam); db.AddInParameter(cmd, "V_SECOND_P_RAKAM", DbType.Decimal, objProjectBudgetDetail.SecondPRakam); db.AddInParameter(cmd, "V_THIRD_P_RAKAM", DbType.Decimal, objProjectBudgetDetail.ThirdPRakam); db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objProjectBudgetDetail.FiscalYearId); db.AddInParameter(cmd, "V_S_BH_MAG_GARNE_F", DbType.Decimal, objProjectBudgetDetail.SBhMagGarneF); db.AddInParameter(cmd, "V_S_BH_MAG_GARNE_S", DbType.Decimal, objProjectBudgetDetail.SBhMagGarneS); db.AddInParameter(cmd, "V_S_BH_MAG_GARNE_T", DbType.Decimal, objProjectBudgetDetail.SBhMagGarneT); db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_MAG_F", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaMagF); db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_MAG_S", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaMagS); db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_MAG_T", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaMagT); db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_PRAPTA_F", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaPraptaF); db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_PRAPTA_S", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaPraptaS); db.AddInParameter(cmd, "V_S_BH_HAL_SAMMA_PRAPTA_T", DbType.Decimal, objProjectBudgetDetail.SBhHalSammaPraptaT); return(db.ExecuteNonQuery(cmd)); }
public DataTable PopulateBudgDetail(ProjectBudgetDetailBO objProjectBudgetDetail) { // db = DatabaseFactory.CreateDatabase("connStr"); DataSet ds = null; DataTable dt = null; ds = db.ExecuteDataSet("PKG_PROJECT_BARSIK_KARYEKRAM.PR_POPULATE_BUDGET_BADFAD", objProjectBudgetDetail.ProjectId, objProjectBudgetDetail.FiscalYearId, OracleDbType.RefCursor); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } return(dt); }
protected void PopulateDonarAmountDetails() { ProjectBudgetDetailBO objPBudgBO = new ProjectBudgetDetailBO(); //objProjectBO.BudgetHeadId = ddlBudgetHeadId; objPBudgBO.ProjectId = Session["projectId"].ToInt32();//change after objPBudgBO.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32(); objBarsikService = new BarsikKaryekramService(); objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram(); DataTable dtShrotgatAayojanBadfad = objBarsikService.PopulateBudgDetail(objPBudgBO); dtA = dtShrotgatAayojanBadfad; if (dtShrotgatAayojanBadfad != null && dtShrotgatAayojanBadfad.Rows.Count > 0) { rptAayojanaBadfad.DataSource = dtShrotgatAayojanBadfad; rptAayojanaBadfad.DataBind(); } }
public DataTable PopulateBarsikThekaParamarsa(ProjectBudgetDetailBO objProjectBudgetDetail) { // db = DatabaseFactory.CreateDatabase("connStr"); DataSet ds = null; DataTable dt = null; /*ds = db.ExecuteDataSet("PKG_PROJECT_BARSIK_KARYEKRAM.PR_POPULATE_PARAMARSA_BIBARAN", * objProjectBudgetDetail.ProjectId, objProjectBudgetDetail.FiscalYearId, * OracleDbType.RefCursor);*/ ds = db.ExecuteDataSet("PKG_PROJECT_BARSIK_KARYEKRAM.PR_POPULATE_PARAMARSA_THEKKA", objProjectBudgetDetail.ProjectId, objProjectBudgetDetail.FiscalYearId, OracleDbType.RefCursor); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } return(dt); }
protected void PopulaterThekaParamarsaDetail() { ProjectBudgetDetailBO objPBudgBO = new ProjectBudgetDetailBO(); DataTable dt = null; objPBudgBO.ProjectId = Session["projectId"].ToInt32();//change after objPBudgBO.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32(); objBarsikService = new BarsikKaryekramService(); objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram(); dt = objBarsikService.PopulateBarsikThekaParamarsa(objPBudgBO); if (dt != null && dt.Rows.Count > 0) { txtPSBNo.Text = dt.Rows[0]["SWADESHI"].ToString(); txtPSBRakam.Text = dt.Rows[0]["RAKAM_SWADESHI"].ToString(); txtPSFirstTNo.Text = dt.Rows[0]["P_F_T_SWADESHI_NO"].ToString(); txtPSFirstTRakam.Text = dt.Rows[0]["P_F_T_SWADESHI_RAKAM"].ToString(); txtPSSecondTNo.Text = dt.Rows[0]["P_S_T_SWADESHI_NO"].ToString(); txtPSSSecondTRakam.Text = dt.Rows[0]["P_S_T_SWADESI_RAKAM"].ToString(); txtPSThirdTNo.Text = dt.Rows[0]["P_T_T_SWADESHI_NO"].ToString(); txtPSThirdTRakam.Text = dt.Rows[0]["P_T_T_SWADESHI_RAKAM"].ToString(); txtPBBNo.Text = dt.Rows[0]["BIDESHI"].ToString(); txtPBBRakam.Text = dt.Rows[0]["RAKAM_BIDESHI"].ToString(); txtPBFirstTNo.Text = dt.Rows[0]["P_F_T_BIDESHI_NO"].ToString(); txtPBFirstTRakam.Text = dt.Rows[0]["P_F_T_BIDESHI_RAKAM"].ToString(); txtPBSecondTNo.Text = dt.Rows[0]["P_S_T_BIDESHI_NO"].ToString(); txtPBSecondTRakam.Text = dt.Rows[0]["P_S_T_BIDESHI_RAKAM"].ToString(); txtPBThirdTNo.Text = dt.Rows[0]["P_T_T_BIDESHI_NO"].ToString(); txtPBThirdTRakam.Text = dt.Rows[0]["P_T_T_BIDESHI_RAKAM"].ToString(); txtThekaBNo.Text = dt.Rows[0]["THEKKA_SANKHYA"].ToString(); txtThekaBRakam.Text = dt.Rows[0]["THEKKA_RAKAM"].ToString(); txtThekaFirstTNo.Text = dt.Rows[0]["THEKA_F_T_NO"].ToString(); txtThekaFirstTRakam.Text = dt.Rows[0]["THEKA_F_T_RAKAM"].ToString(); txtThekaSecondTNO.Text = dt.Rows[0]["THEKA_S_T_NO"].ToString(); txtThekaSecondTRakam.Text = dt.Rows[0]["THEKA_S_T_RAKAM"].ToString(); txtThekaThirdTNo.Text = dt.Rows[0]["THEKA_T_T_NO"].ToString(); txtThekaThirdTRakam.Text = dt.Rows[0]["THEKA_T_T_RAKAM"].ToString(); lblModification.Text = dt.Rows[0]["MODIFIED_DATE"].ToDateTime().ToString("D"); lblModifiedBy.Text = dt.Rows[0]["MODIFIED_BY"].ToString(); hidThekaParamarsaId.Value = dt.Rows[0]["BARSIK_THEKA_P_ID"].ToString(); } }
protected void btnSave_Click(object sender, EventArgs e) { ProjectBudgetDetailBO objBudgProject = new ProjectBudgetDetailBO(); DropDownList ddlShrot = new DropDownList(); DropDownList ddlBhuktaniPrakar = new DropDownList(); TextBox txtRakam = new TextBox(); TextBox txtFirstTRakam = new TextBox(); TextBox txtSecondTRakam = new TextBox(); TextBox txtThirdTRakam = new TextBox(); HiddenField hidBadfadId = new HiddenField(); foreach (RepeaterItem rptItem in rptAayojanaBadfad.Items) { int k = 0; ddlShrot = (DropDownList)rptItem.FindControl("ddlShrot"); ddlBhuktaniPrakar = (DropDownList)rptItem.FindControl("ddlBhuktaniPrakar"); txtRakam = (TextBox)rptItem.FindControl("txtRakam"); txtFirstTRakam = (TextBox)rptItem.FindControl("txtFirstTRakam"); txtSecondTRakam = (TextBox)rptItem.FindControl("txtSecondTRakam"); txtThirdTRakam = (TextBox)rptItem.FindControl("txtThirdTRakam"); hidBadfadId = (HiddenField)rptItem.FindControl("hidBadfadId"); objBudgProject.BadfadId = hidBadfadId.Value.ToDecimal(); objBudgProject.FirstTRakam = txtFirstTRakam.Text.ToDecimal(); objBudgProject.SecondTRakam = txtSecondTRakam.Text.ToDecimal(); objBudgProject.ThirdCRakam = txtThirdTRakam.Text.ToDecimal(); objBudgProject.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32(); objBudgProject.Mode = "I"; objBarsikService = new BarsikKaryekramService(); objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram(); objBarsikService.InsertUpdateProjectBudgDetail(objBudgProject); } ProjectBarsikThekaParamarsaBO objThekaParamarsa = new ProjectBarsikThekaParamarsaBO(); //barshikAnya ProjectBarshikAnyaBO objBarshikAnyaBo = new ProjectBarshikAnyaBO(); objBarshikAnyaBo.ProjectId = Session["projectId"].ToInt32(); objBarshikAnyaBo.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objBarshikAnyaBo.FirstRakamAnya = txtAnyaFirst.Text.ToDecimal(); objBarshikAnyaBo.SecondRakamAnya = txtAnyaSecond.Text.ToDecimal(); objBarshikAnyaBo.ThirdRakamAnya = txtAnyaThird.Text.ToDecimal(); objBarshikAnyaBo.RemarksAnya = txtAnyaRemarks.Text; objBarsikService = new BarsikKaryekramService(); objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram(); if (hidBarshikAnyaId.Value == "") { objBarshikAnyaBo.Mode = "I"; } else { objBarshikAnyaBo.Mode = "U"; objBarshikAnyaBo.BarshikAnyaID = hidBarshikAnyaId.Value.ToInt32(); } //barshikBharit BarsikBharitBo objBarsikBharitBo = new BarsikBharitBo(); objBarsikBharitBo.ProjectId = Session["projectId"].ToInt32(); objBarsikBharitBo.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objBarsikBharitBo.BarshikBharitLakshya = txtBarshik.Text.ToDecimal(); objBarsikBharitBo.FirstBharitLakshya = txtFirstBharit.Text.ToDecimal(); objBarsikBharitBo.SecondBharitLakshya = txtSecondBharit.Text.ToDecimal(); objBarsikBharitBo.ThirdBharitLakshya = txtThirdBharit.Text.ToDecimal(); if (hidBarshikBharitId.Value == "") { objBarsikBharitBo.Mode = "I"; } else { objBarsikBharitBo.Mode = "U"; } if (hidThekaParamarsaId.Value == "") { objThekaParamarsa.Mode = "I"; } else { objThekaParamarsa.Mode = "U"; objThekaParamarsa.BarsikThekaPId = hidThekaParamarsaId.Value.ToDecimal(); } //paramarsa swadeshi objThekaParamarsa.PFTSwadeshiNo = txtPSFirstTNo.Text.ToDecimal(); objThekaParamarsa.PFTSwadeshiRakam = txtPSFirstTRakam.Text.ToDecimal(); objThekaParamarsa.PSTSwadeshiNo = txtPSSecondTNo.Text.ToDecimal(); objThekaParamarsa.PSTSwadesiRakam = txtPSSSecondTRakam.Text.ToDecimal(); objThekaParamarsa.PTTSwadeshiNo = txtPSThirdTNo.Text.ToDecimal(); objThekaParamarsa.PTTSwadeshiRakam = txtPSThirdTRakam.Text.ToDecimal(); //pragati objThekaParamarsa.PFPSwadeshiNo = 0; objThekaParamarsa.PFPSwadeshiRakam = 0; objThekaParamarsa.PSPSwadeshiNo = 0; objThekaParamarsa.PSPSwadesiRakam = 0; objThekaParamarsa.PTPSwadeshiNo = 0; objThekaParamarsa.PTPSwadeshiRakam = 0; //end //paramarsadata bideshi objThekaParamarsa.PFTBideshiNo = txtPBFirstTNo.Text.ToDecimal(); objThekaParamarsa.PFTBideshiRakam = txtPBFirstTRakam.Text.ToDecimal(); objThekaParamarsa.PSTBideshiNo = txtPBSecondTNo.Text.ToDecimal(); objThekaParamarsa.PSTBideshiRakam = txtPBSecondTRakam.Text.ToDecimal(); objThekaParamarsa.PTTBideshiNo = txtPBThirdTNo.Text.ToDecimal(); objThekaParamarsa.PTTBideshiRakam = txtPBThirdTRakam.Text.ToDecimal(); //pragati objThekaParamarsa.PFPBideshiNo = 0; objThekaParamarsa.PFPBideshiRakam = 0; objThekaParamarsa.PSPBideshiNo = 0; objThekaParamarsa.PSPBideshiRakam = 0; objThekaParamarsa.PTPBideshiNo = 0; objThekaParamarsa.PTPBideshiRakam = 0; //end // //theka details// objThekaParamarsa.ThekaFTNo = txtThekaFirstTNo.Text.ToDecimal(); objThekaParamarsa.ThekaFTRakam = txtThekaFirstTRakam.Text.ToDecimal(); objThekaParamarsa.ThekaSTNo = txtThekaSecondTNO.Text.ToDecimal(); objThekaParamarsa.ThekaSTRakam = txtThekaSecondTRakam.Text.ToDecimal(); objThekaParamarsa.ThekaTTNo = txtThekaThirdTNo.Text.ToDecimal(); objThekaParamarsa.ThekaTTRakam = txtThekaThirdTRakam.Text.ToDecimal(); //pragati objThekaParamarsa.ThekaFPNo = 0; objThekaParamarsa.ThekaFPRakam = 0; objThekaParamarsa.ThekaSPNo = 0; objThekaParamarsa.ThekaSPRakam = 0; objThekaParamarsa.ThekaTPNo = 0; objThekaParamarsa.ThekaTPRakam = 0; //end objThekaParamarsa.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32(); objThekaParamarsa.ProjectId = Session["projectId"].ToInt32(); objThekaParamarsa.ModifiedBy = Session["username"].ToString(); objThekaParamarsa.ModifiedDate = DateTime.Now; objBarsikService.InsertUpdateProjectBarsikThekaParamarsa(objThekaParamarsa); //upload multiple files ProjectBarsikThekaParamarsaBO objBo = new ProjectBarsikThekaParamarsaBO(); objBarsikService = new BarsikKaryekramService(); objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram(); //insert barshik anya int a = objBarsikService.InsertUpdateBarshikAnya(objBarshikAnyaBo); int b = objBarsikService.InsertUpdateBarshikBharit(objBarsikBharitBo); objBo.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objBo.ProjectId = Session["projectId"].ToInt32(); string allFiles = ""; ///// file upload remains if (FileBarshikUpload.HasFile) // CHECK IF ANY FILE HAS BEEN SELECTED. { HttpFileCollection hfc = Request.Files; for (int f = 0; f <= hfc.Count - 1; f++) { HttpPostedFile hpf = hfc[f]; if (hpf.ContentLength > 0) { string fileName; fileName = DateTime.Now + hpf.FileName; string ext = System.IO.Path.GetExtension(hpf.FileName); var splitseparator = new string[] { ext }; var result = Splitstring(fileName, splitseparator); String source = result[0]; string str = source + ext; str = Regex.Replace(str, @"/", "_"); str = Regex.Replace(str, @":", "_"); str = Regex.Replace(str, @" ", "_"); str = Regex.Replace(str, @",", "_"); String newfolder = Server.MapPath("~") + @"BarshikFiles\"; String path = newfolder + str; hpf.SaveAs(path); allFiles += str + ","; } } objBo.BarshikFileName = allFiles; } else { DataTable BarshikFile = (DataTable)Session["dtBarshikFile"]; if (BarshikFile != null && BarshikFile.Rows.Count > 0) { //update case objBo.BarshikFileName = Session["existingFilename"].ToString(); } else { //insert case objBo.BarshikFileName = ""; } } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); int j = objBarsikService.InsertUpdateBarshikFile(objBo); Response.Redirect(Constants.ConstantAppPath + "/Modules/BarsikKaryekram/BarsikKaryekram.aspx"); /*if (FileBarshik.HasFile) * { * ProjectBarsikThekaParamarsaBO objBo = new ProjectBarsikThekaParamarsaBO(); * objBarsikService = new BarsikKaryekramService(); * objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram(); * //lblImage.Text = DateTime.Now + FileBarshik.FileName; * string ext = System.IO.Path.GetExtension(this.FileBarshik.PostedFile.FileName); * var splitseparator = new string[] { ext }; * var result = Splitstring(DateTime.Now + FileBarshik.FileName, splitseparator); * String source = result[0]; * string str = source + ext; * str = Regex.Replace(str, @"/", "_"); * str = Regex.Replace(str, @":", "_"); * objBo.BarshikFileName = str; * objBo.FiscalYearId = Session["fiscal_year_id"].ToInt32(); * objBo.ProjectId = Session["projectId"].ToInt32(); * UploadFile(FileBarshik, str); * int i=objBarsikService.InsertUpdateBarshikFile(objBo); * * }*/ }
public DataTable PopulateBarsikThekaParamarsa(ProjectBudgetDetailBO objProjectBudgetDetail) { Authentication(); return(objBarsikDal.PopulateBarsikThekaParamarsa(objProjectBudgetDetail)); }
public DataTable PopulateBudgDetail(ProjectBudgetDetailBO objProjectBudgetDetail) { Authentication(); return(objBarsikDal.PopulateBudgDetail(objProjectBudgetDetail)); }
public int InsertUpdateProjectBudgDetail(ProjectBudgetDetailBO objProjectDetail) { Authentication(); return(objBarsikDal.InsertUpdateProjectBudgetDetail(objProjectDetail)); }