protected void ddlBudgetHead_SelectedIndexChanged(object sender, EventArgs e) { rptProblems.DataSource = null; rptProblems.DataBind(); DataTable dtEmpty = new DataTable(); ddlProjects.DataSource = dtEmpty; ddlProjects.DataBind(); btnAddProblems.Visible = false; btnSaveProblem.Visible = false; objProjectBO = new ComProjectBO(); objProjectBO.BudgetHeadId = ddlBudgetHead.SelectedValue.ToInt32(); objProjectBO.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objProjectBO.OfficeId = Session["office_id"].ToInt32(); objProjectBO.Lang = Session["LanguageSetting"].ToString(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtProjectDetail = wbs.PopulateProjectList(objProjectBO); if (dtProjectDetail != null && dtProjectDetail.Rows.Count > 0) { ddlProjects.DataSource = dtProjectDetail; ddlProjects.DataTextField = "PROJECT_NAME"; ddlProjects.DataValueField = "PROJECT_ID"; ddlProjects.DataBind(); ddlProjects.Items.Insert(0, "--आयोजना छान्नुहोस्--"); } }
private void PopulateProjectsByBudgetHead(int budgHeadId) { objProjectBO = new ComProjectBO(); objProjectBO.BudgetHeadId = budgHeadId; objProjectBO.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objProjectBO.OfficeId = Session["office_id"].ToInt32(); objProjectBO.MinistryId = Session["ministry_id"].ToInt32(); objProjectBO.SelectedMinistryId = ddlMinistry.SelectedValue.ToInt32(); objProjectBO.Lang = Session["LanguageSetting"].ToString(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); /*Session["dtProjectDetail"] = wbs.PopulateProjectListForReport(objProjectBO); * DataTable dtProjectDetail = (DataTable)Session["dtProjectDetail"];*/ DataTable dtProjectDetail = wbs.PopulateProjectListForReport(objProjectBO); if (dtProjectDetail != null && dtProjectDetail.Rows.Count > 0) { ddlProject.DataSource = dtProjectDetail; ddlProject.DataTextField = "PROJECT_NAME"; ddlProject.DataValueField = "PROJECT_ID"; ddlProject.DataBind(); ddlProject.Items.Insert(0, "--छान्नुहोस्--"); } }
protected void btnAddRananiti_Click(object sender, EventArgs e) { objProjectBO = new ComProjectBO(); if (Session["rananitiId"].ToInt32() > 0) { objProjectBO.Mode = "U"; objProjectBO.RananitiId = Session["rananitiId"].ToInt32(); } else { objProjectBO.Mode = "I"; } objProjectBO.SubSector = ddlSubSector.SelectedValue.ToInt32(); objProjectBO.RananitiEngName = txtRananitiEnglishName.Text; objProjectBO.RananitiNepName = txtRananitiNepaliName.Text; int i = 0; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.AddEditRananiti(objProjectBO); if (i > 0) { Response.Write("<script>alert('Rananiti is inserted/updated successfully!')</script>"); } else { Response.Write("<script>alert('Rananiti insertion/updation failed!')</script>"); } }
protected void BtnEdit_Command(object sender, CommandEventArgs e) { int projectId = 0; if (e.CommandName == "edit") { projectId = int.Parse(e.CommandArgument.ToString()); SecureQueryString str = new SecureQueryString(); str["id"] = e.CommandArgument.ToString(); Response.Redirect(Constants.ConstantAppPath + "/Modules/RananitiKaryanitiManagement/AddEditRananiti.aspx" + str.EncryptedString); } else if (e.CommandName == "delete") { int i = 0; int rananitiId = 0; rananitiId = int.Parse(e.CommandArgument.ToString()); objProjectBO = new ComProjectBO(); objProjectBO.RananitiId = rananitiId; objProjectBO.Mode = "D"; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.AddEditRananiti(objProjectBO); if (i > 0) { Response.Redirect(Constants.ConstantAppPath + "/Modules/RananitiKaryanitiManagement/ListRananiti.aspx"); } else { Response.Write("<script>alert('Delete failed')</script>"); } } }
protected void lnkVerify_Click(object sender, EventArgs e) { int i = 0; string mode = string.Empty; objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = ddlProject.SelectedValue.ToInt32(); objProjectBO.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objProjectBO.ChaumasikId = ddlTrimester.SelectedValue.ToInt32(); if (Session["role_id"].ToInt32() == 12) { objProjectBO.Mode = mode = "V1"; //verification level 1 } else if (Session["role_id"].ToInt32() == 13) { objProjectBO.Mode = mode = "V2"; //verification level 2 } else if (Session["role_id"].ToInt32() == 14) { objProjectBO.Mode = mode = "V3"; //verification level 3 } else if (Session["role_id"].ToInt32() == 15) { objProjectBO.Mode = mode = "V4"; //verification level 4 } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); int check = 0; check = wbs.CheckLowerLevelReportVerification(objProjectBO); if (check == 1) { wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.AddReportVerification(objProjectBO); if (i > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Report Verified.'); window.location='" + Constants.ConstantAppPath + "/CrystalViewer/ProjectTrans/ProjectUpdateViewer.aspx';", true); } //Response.Redirect(Constants.ConstantAppPath + "/CrystalViewer/ProjectTrans/ProjectUpdateViewer.aspx"); else { ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Verification failed.'); window.location='" + Constants.ConstantAppPath + "/CrystalViewer/ProjectTrans/ProjectUpdateViewer.aspx';", true); //Response.Write("<script>alert('Verification failed')</script>"); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Verification failed. Lower level verification is required.'); window.location='" + Constants.ConstantAppPath + "/CrystalViewer/ProjectTrans/ProjectUpdateViewer.aspx';", true); //Response.Write("<script>alert('Verification failed. Lower level verification is required.')</script>"); } }
//protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e) //{ // //to clear the repeater before dropdown-selected value gets changed // rptBhautikSamagri.DataSource = null; // rptBhautikSamagri.DataBind(); // PopulateAdministrativeDetails(ddlProject.SelectedValue.ToInt32()); //} private void PopulateAdministrativeDetails(int projectId) { DataTable dtBhautikSamagri = null; objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = projectId; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); Session["dt"] = wbs.PopulateAdministrativeDetails(objProjectBO); DataTable dt = (DataTable)Session["dt"]; if (dt != null && dt.Rows.Count > 0) { rbdExistingJanashakti.SelectedValue = dt.Rows[0]["EXISTING_JANASHAKTI"].ToString(); txtThapJanashakti.Text = dt.Rows[0]["THAP_JANASHAKTI"].ToString(); txtJanaShaktiKaifiyat.Text = dt.Rows[0]["THAP_JANASHAKTI_KAIFIYAT"].ToString(); txtMinistryRaaya.Text = dt.Rows[0]["MINISTRY_RAAYA"].ToString(); txtChuttayiyekoRakam.Text = dt.Rows[0]["CHUTTAYIYEKO_RAKAM"].ToString(); txtDaatriBibaran.Text = dt.Rows[0]["DAATRI_BIBARAN"].ToString(); txtNepalSarkarBibaran.Text = dt.Rows[0]["NEPAL_SARKAR_BIBARAN"].ToString(); txtPhaseOutPlan.Text = dt.Rows[0]["PHASE_OUT_PLAN"].ToString(); dtBhautikSamagri = wbs.PopulateBhautikSamagri(objProjectBO); dtA = dtBhautikSamagri; if (dtBhautikSamagri != null && dtBhautikSamagri.Rows.Count > 0) { rptBhautikSamagri.DataSource = dtBhautikSamagri; rptBhautikSamagri.DataBind(); foreach (RepeaterItem rptItem in rptBhautikSamagri.Items) { TextBox txtItem = new TextBox(); DropDownList ddlUnit = new DropDownList(); TextBox txtAnumanitRakam = new TextBox(); TextBox txtQuantity = new TextBox(); TextBox txtSamagriKaifiyat = new TextBox(); txtItem = (TextBox)rptItem.FindControl("txtItemName"); ddlUnit = (DropDownList)rptItem.FindControl("ddlUnit"); txtQuantity = (TextBox)rptItem.FindControl("txtQuantity"); txtAnumanitRakam = (TextBox)rptItem.FindControl("txtAnumanitRakam"); txtSamagriKaifiyat = (TextBox)rptItem.FindControl("txtSamagriKaifiyat"); } } else { dtA.Clear(); DataRow drB = dtA.NewRow(); drB["ITEM_NAME"] = ""; drB["UNIT_ID"] = 0; drB["QUANTITY"] = 0; drB["ANUMANIT_RAKAM"] = 0; drB["SAMAGRI_KAIFIYAT"] = ""; dtA.Rows.Add(drB); rptBhautikSamagri.DataSource = dtA; rptBhautikSamagri.DataBind(); } } }
protected void btnView_Click(object sender, EventArgs e) { lvRananiti.DataSource = null; lvRananiti.DataBind(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtRananitiDetail = wbs.PopulateAllRananitiBySubSectorId(ddlSubSector.SelectedValue.ToInt32(), Session["LanguageSetting"].ToString()); if (dtRananitiDetail != null && dtRananitiDetail.Rows.Count > 0) { lvRananiti.DataSource = dtRananitiDetail; lvRananiti.DataBind(); } }
private void PopulateKaryanitiDetails(int karyanitiId) { ProjectService objWebService = new ProjectService(); DataTable dtKaryanitiDetails = null; objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtKaryanitiDetails = objWebService.PopulateKaryanitiDetails(karyanitiId); if (dtKaryanitiDetails != null && dtKaryanitiDetails.Rows.Count > 0) { ddlRananiti.SelectedValue = dtKaryanitiDetails.Rows[0]["RANANITI_ID"].ToString(); txtKaryanitiEnglishName.Text = dtKaryanitiDetails.Rows[0]["KARYANITI_ENG_NAME"].ToString(); txtKaryanitiNepaliName.Text = dtKaryanitiDetails.Rows[0]["KARYANITI_NEP_NAME"].ToString(); } }
protected void ddlRananiti_SelectedIndexChanged(object sender, EventArgs e) { DataTable dtKaryaniti = null; int rananitiId = ddlRananiti.SelectedValue.ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtKaryaniti = wbs.PopulateAllKaryaniti(rananitiId, Session["LanguageSetting"].ToString()); if (dtKaryaniti != null && dtKaryaniti.Rows.Count > 0) { lvKaryaniti.DataSource = dtKaryaniti; lvKaryaniti.DataBind(); } }
private void PopulateAllRananiti() { DataTable dtRananiti = null; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtRananiti = wbs.PopulateAllRananiti(Session["LanguageSetting"].ToString()); if (dtRananiti != null && dtRananiti.Rows.Count > 0) { ddlRananiti.DataSource = dtRananiti; ddlRananiti.DataValueField = "RANANITI_ID"; ddlRananiti.DataTextField = "RANANITI_NAME"; ddlRananiti.DataBind(); ddlRananiti.Items.Insert(0, "--छान्नुहोस्--"); } }
private void PopulateRananitiDetails(int rananitiId) { ProjectService objWebService = new ProjectService(); DataTable dtRananitiDetails = null; objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtRananitiDetails = objWebService.PopulateRananitiDetails(rananitiId); if (dtRananitiDetails != null && dtRananitiDetails.Rows.Count > 0) { ddlSector.SelectedValue = dtRananitiDetails.Rows[0]["ACTIVITY_SECTOR_ID"].ToString(); PopulateSubSector(ddlSector.SelectedValue.ToInt32()); ddlSubSector.SelectedValue = dtRananitiDetails.Rows[0]["SUB_SECTOR_ID"].ToString(); hidSubSector.Value = ddlSubSector.SelectedValue; txtRananitiEnglishName.Text = dtRananitiDetails.Rows[0]["RANANITI_ENG_NAME"].ToString(); txtRananitiNepaliName.Text = dtRananitiDetails.Rows[0]["RANANITI_NEP_NAME"].ToString(); } }
private void PopulateDataForRepeater() { DataTable dt = null; objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = ddlProjects.SelectedValue.ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dt = wbs.PopulateProjectProblems(objProjectBO); dtA = dt; if (dt != null && dt.Rows.Count > 0) { rptProblems.DataSource = dt; rptProblems.DataBind(); btnSaveProblem.Visible = true; } }
protected void btnSaveProblem_Click(object sender, EventArgs e) { objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = ddlProjects.SelectedValue.ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); wbs.ClearProjectProblems(objProjectBO); DropDownList ddlChaumasik = new DropDownList(); TextBox txtProblems = new TextBox(); TextBox txtReasons = new TextBox(); TextBox txtEfforts = new TextBox(); TextBox txtSuggestions = new TextBox(); CheckBox chkNdac = new CheckBox(); foreach (RepeaterItem rptItem in rptProblems.Items) { int k = 0; ddlChaumasik = (DropDownList)rptItem.FindControl("ddlChaumasik"); txtProblems = (TextBox)rptItem.FindControl("txtProblems"); txtReasons = (TextBox)rptItem.FindControl("txtReasons"); txtEfforts = (TextBox)rptItem.FindControl("txtEfforts"); txtSuggestions = (TextBox)rptItem.FindControl("txtSuggestions"); chkNdac = (CheckBox)rptItem.FindControl("chkNdac"); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = ddlProjects.SelectedValue.ToInt32(); objProjectBO.ChaumasikId = ddlChaumasik.SelectedValue.ToInt32(); objProjectBO.Problems = txtProblems.Text; objProjectBO.Reasons = txtReasons.Text; objProjectBO.Efforts = txtEfforts.Text; objProjectBO.Suggestions = txtSuggestions.Text; if (chkNdac.Checked == true) { objProjectBO.Ndac = 1; } else { objProjectBO.Ndac = 0; } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); k = wbs.SaveProjectProblems(objProjectBO); } }
protected void rptAayojanaBadfad_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { DropDownList dll = (DropDownList)e.Item.FindControl("ddlShrot"); DataTable DtShrot = null; BudgetDonarService objWebService = new BudgetDonarService(); objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBudgetDonar(); DtShrot = objWebService.PopulateAllDonars(Session["LanguageSetting"].ToString()); if (DtShrot != null && DtShrot.Rows.Count > 0) { dll.DataSource = DtShrot; dll.DataTextField = "DONAR_NAME"; dll.DataValueField = "DONAR_ID"; dll.DataBind(); dll.Items.Insert(0, "--छान्नुहोस्--"); } DropDownList ddlBhuktaniPrakar = (DropDownList)e.Item.FindControl("ddlBhuktaniPrakar"); ComProjectBO obj = null; obj = new ComProjectBO(); obj.Lang = Session["LanguageSetting"].ToString(); DataTable DtBhuktaniPrakar = null; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); DtBhuktaniPrakar = wbs.PopulateBhuktaniPrakar(obj); if (DtBhuktaniPrakar != null && DtBhuktaniPrakar.Rows.Count > 0) { ddlBhuktaniPrakar.DataSource = DtBhuktaniPrakar; ddlBhuktaniPrakar.DataTextField = "PAYMENT_TYPE_NAME"; ddlBhuktaniPrakar.DataValueField = "PAYMENT_TYPE_ID"; ddlBhuktaniPrakar.DataBind(); ddlBhuktaniPrakar.Items.Insert(0, "--छान्नुहोस्--"); } DropDownList ddlDonar = new DropDownList(); ddlDonar = (DropDownList)e.Item.FindControl("ddlShrot"); DropDownList ddlPaymentType = new DropDownList(); ddlPaymentType = (DropDownList)e.Item.FindControl("ddlBhuktaniPrakar"); ddlDonar.SelectedValue = dtA.Rows[e.Item.ItemIndex]["DONAR_ID"].ToString(); ddlPaymentType.SelectedValue = dtA.Rows[e.Item.ItemIndex]["PAYMENT_TYPE_ID"].ToString(); } }
private void PopulateProjects(int budgHeadId) { lvProject.DataSource = null; lvProject.DataBind(); objProjectBO = new ComProjectBO(); objProjectBO.BudgetHeadId = budgHeadId; objProjectBO.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objProjectBO.OfficeId = Session["office_id"].ToInt32(); objProjectBO.Lang = Session["LanguageSetting"].ToString(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtProjectDetail = wbs.PopulateProjectList(objProjectBO); if (dtProjectDetail != null && dtProjectDetail.Rows.Count > 0) { lvProject.DataSource = dtProjectDetail; lvProject.DataBind(); } }
private void PopulateDigoBikashLakshya() { ComProjectBO obj = new ComProjectBO(); obj.Lang = Session["LanguageSetting"].ToString(); DataTable dtDigoBksLakshya = null; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtDigoBksLakshya = wbs.PopulateDigoBikashLakshya(obj); if (dtDigoBksLakshya != null && dtDigoBksLakshya.Rows.Count > 0) { ddlDigoBikashLakshya.DataSource = dtDigoBksLakshya; ddlDigoBikashLakshya.DataTextField = "DIGO_LAKSHYA_NAME"; ddlDigoBikashLakshya.DataValueField = "DIGO_LAKSHYA_ID"; ddlDigoBikashLakshya.DataBind(); ddlDigoBikashLakshya.Items.Insert(0, "--छान्नुहोस्--"); } }
private void PopulateDigoBikashGantabya() { ProjectService objWebService = new ProjectService(); ComProjectBO objComProjectBO = new ComProjectBO(); DataTable dtPopulateGantabya = new DataTable(); objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); objComProjectBO.DigoBikashLakshya = ddlDigoBikashLakshya.SelectedValue.ToInt32(); objComProjectBO.Lang = Session["LanguageSetting"].ToString(); dtPopulateGantabya = objWebService.PopulateDigoBikashGantabya(objComProjectBO); if (dtPopulateGantabya != null && dtPopulateGantabya.Rows.Count > 0) { ddlDigoBikashGantabya.DataSource = dtPopulateGantabya; ddlDigoBikashGantabya.DataTextField = "DIGO_GANTABYA_NAME"; ddlDigoBikashGantabya.DataValueField = "DIGO_GANTABYA_ID"; ddlDigoBikashGantabya.DataBind(); ddlDigoBikashGantabya.Items.Insert(0, "--छान्नुहोस्--"); } }
private void PopulateProjectSamastigatReport(ReportDocument repDoc) { objProjectBO = new ComProjectBO(); objProjectBO.MinistryId = ddlMinistry.SelectedValue.ToInt32(); objProjectBO.ChaumasikId = ddlChaumasik.SelectedValue.ToInt32(); objProjectBO.Priority = ddlPriority.SelectedValue.ToInt32(); objProjectBO.FiscalYearId = Session["fiscal_year_id"].ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dt = wbs.PopulateProjectSamastigatReport(objProjectBO); Session["dtPopulateProjectSamastigatReport"] = dt; //objPlanRpt = new PlanListRpt(); objRptFactory = new ReportFactory(); objRptFactory.SetReport(repDoc); objRptServices = new ReportServices(); objRptServices.GetReport(repDoc, RptViewer); repDoc.Database.Tables[0].SetDataSource(dt); cryParameter(repDoc); if (dt != null && dt.Rows.Count > 0) { lnkVerify.Visible = true; RptViewer.ReportSource = repDoc; Session["SamastigatReport"] = repDoc; } else { RptViewer.ReportSource = null; Session["SamastigatReport"] = null; } //chartViewer.ReportSource = objPrjBhautikPragatiGrpRpt; // crystalViewer.Zoom(75); //chartViewer.Zoom(93); }
private void PopulateSahashrabdiBikashSuchak() { ComProjectBO obj = new ComProjectBO(); obj.Lang = Session["LanguageSetting"].ToString(); DataTable DtBikashSuchak = null; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); obj.SahasabdiBikashGantabya = ddlSahasabdiBikashGantabya.SelectedValue.ToInt32(); DtBikashSuchak = wbs.PopulateSahashrabdiBikashSuchak(obj); if (DtBikashSuchak != null && DtBikashSuchak.Rows.Count > 0) { ddlSahasabdiBikashSuchak.DataSource = DtBikashSuchak; ddlSahasabdiBikashSuchak.DataTextField = "SUCHAK_NAME"; ddlSahasabdiBikashSuchak.DataValueField = "SUCHAK_ID"; ddlSahasabdiBikashSuchak.DataBind(); ddlSahasabdiBikashSuchak.Items.Insert(0, "--छान्नुहोस्--"); } }
protected void LoadReport(int prjlId, ReportDocument repDoc) { objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = prjlId; // prjlId.ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); Session["dtProjectDetail"] = wbs.PopulateProjectListRpt(objProjectBO); int fiscalYearId = SessionHelper.SessionFiscalYear.ToInt32(); //Provide parameter values DataTable dtProjectDetail = (DataTable)Session["dtProjectDetail"]; if (dtProjectDetail != null && dtProjectDetail.Rows.Count > 0) { //cryParameter(repDoc); //objPlanRpt = new PlanListRpt(); //this limits the queue lnkVerify.Visible = true; objRptFactory = new ReportFactory(); objRptFactory.SetReport(repDoc); objRptServices = new ReportServices(); objRptServices.GetReport(repDoc, tabviewer); repDoc.Database.Tables[0].SetDataSource(dtProjectDetail); cryParameter(repDoc); tabviewer.ReportSource = repDoc; tabviewer.DataBind(); Session["ProjectUpdateReport"] = repDoc; } else { tabviewer.ReportSource = null; Session["ProjectUpdateReport"] = null; } }
private void PopulateProjectOutput(int projectId, int fiscalYearId) { DataTable dtProjectOutput = null; objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = projectId; objProjectBO.FiscalYearId = fiscalYearId; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtA = dtProjectOutput = wbs.PopulateProjectOutput(objProjectBO); if (dtProjectOutput != null && dtProjectOutput.Rows.Count > 0) { rptOutput.DataSource = dtProjectOutput; rptOutput.DataBind(); lblModification.Text = dtProjectOutput.Rows[0]["MODIFIED_DATE"].ToDateTime().ToString("D"); lblModifiedBy.Text = dtProjectOutput.Rows[0]["MODIFIED_BY"].ToString(); } else { dtA.Clear(); DataRow drB = dtA.NewRow(); drB["OUTPUT_ORDER"] = 0; drB["OUTPUT"] = ""; drB["UNIT_ID"] = 0; drB["YEARLY_TARGET"] = 0; drB["FIRST_QUARTER_TARGET"] = 0; drB["SECOND_QUARTER_TARGET"] = 0; drB["THIRD_QUARTER_TARGET"] = 0; drB["OUTPUT_REMARKS"] = ""; dtA.Rows.Add(drB); rptOutput.DataSource = dtA; rptOutput.DataBind(); } }
protected void btnSaveOutput_Click(object sender, EventArgs e) { int i = 0; objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objProjectBO.ModifiedDate = DateTime.Now; objProjectBO.ModifiedBy = Session["username"].ToString(); //To clear project pratifal wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.ClearProjectPratifal(objProjectBO); TextBox txtOrder = new TextBox(); TextBox txtOutput = new TextBox(); DropDownList ddlUnit = new DropDownList(); TextBox txtYearlyTarget = new TextBox(); TextBox txtFirstQuarterTarget = new TextBox(); TextBox txtSecondQuarterTarget = new TextBox(); TextBox txtThirdQuarterTarget = new TextBox(); TextBox txtOutputRemarks = new TextBox(); int k = 0; foreach (RepeaterItem rptItem in rptOutput.Items) { txtOrder = (TextBox)rptItem.FindControl("txtOrder"); txtOutput = (TextBox)rptItem.FindControl("txtOutput"); txtYearlyTarget = (TextBox)rptItem.FindControl("txtYearlyTarget"); ddlUnit = (DropDownList)rptItem.FindControl("ddlUnit"); txtFirstQuarterTarget = (TextBox)rptItem.FindControl("txtFirstQuarterTarget"); txtSecondQuarterTarget = (TextBox)rptItem.FindControl("txtSecondQuarterTarget"); txtThirdQuarterTarget = (TextBox)rptItem.FindControl("txtThirdQuarterTarget"); txtOutputRemarks = (TextBox)rptItem.FindControl("txtOutputRemarks"); //objProjectBO.Order=txtOrder.Text; objProjectBO.Output = txtOutput.Text; objProjectBO.UnitId = ddlUnit.SelectedValue.ToInt32(); objProjectBO.YearlyTarget = txtYearlyTarget.Text.ToDecimal(); objProjectBO.FirstQuarterTarget = txtFirstQuarterTarget.Text.ToDecimal(); objProjectBO.SecondQuarterTarget = txtSecondQuarterTarget.Text.ToDecimal(); objProjectBO.ThirdQuarterTarget = txtThirdQuarterTarget.Text.ToDecimal(); objProjectBO.OutputRemarks = txtOutputRemarks.Text; objProjectBO.Order = txtOrder.Text.ToInt32(); //if (txtYearlyTarget.Text.ToDecimal() != txtFirstQuarterTarget.Text.ToDecimal() + txtSecondQuarterTarget.Text.ToDecimal() + txtThirdQuarterTarget.Text.ToDecimal()) //{ // Response.Write("alert('तीन वटा चौमासिक लक्ष्यको योग वार्षिक लक्ष्य बराबर हुनुपर्दछ।')"); // txtYearlyTarget.Focus(); //} //else //{ // wbs = new ProjectService(); // wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); // k = wbs.SaveProjectPratifal(objProjectBO); //} wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); k = wbs.SaveProjectPratifal(objProjectBO); } if (k > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('इन्ट्री सफल भएको छ।'); window.location='" + Constants.ConstantAppPath + "/Modules/OutputTargetManagement/AddProjectOutput.aspx" + "';", true); // Response.Redirect(Constants.ConstantAppPath + "/Modules/BarsikKaryekram/ListProjectBarshikKaryakram.aspx"); } else { { ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('इन्ट्री सफल भएन। कृपया पुन: प्रयास गर्नुहोला।'); window.location='" + Constants.ConstantAppPath + "/Modules/OutputTargetManagement/AddProjectOutput.aspx" + "';", true); // Response.Redirect(Constants.ConstantAppPath + "/Modules/BarsikKaryekram/ListProjectBarshikKaryakram.aspx"); } } }
protected void LoadReport(int prjlId, ReportDocument repDoc) { //repDoc = new ReportDocument(); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = prjlId.ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); Session["dtProjectDetail"] = wbs.PopulateProjectListRpt(objProjectBO); DataTable dtProjectDetail = (DataTable)Session["dtProjectDetail"]; if (dtProjectDetail != null && dtProjectDetail.Rows.Count > 0) { lnkVerify.Visible = true; //objPlanRpt = new PlanListRpt(); objRptFactory = new ReportFactory(); objRptFactory.SetReport(repDoc); objRptServices = new ReportServices(); objRptServices.GetReport(repDoc, tabviewer); repDoc.Database.Tables[0].SetDataSource(dtProjectDetail); //cryParameter(repDoc); if (dtProjectDetail != null && dtProjectDetail.Rows.Count > 0) { tabviewer.ReportSource = repDoc; Session["ProjectReport"] = repDoc; } else { tabviewer.ReportSource = null; Session["ProjectReport"] = null; } //tabviewer.ReportSource = repDoc; //chartViewer.ReportSource = objPrjBhautikPragatiGrpRpt; // crystalViewer.Zoom(75); //chartViewer.Zoom(93); } else { //objRptFactory = new ReportFactory(); //objRptFactory.SetReport(repDoc); //objRptServices = new ReportServices(); //objRptServices.GetReport(repDoc, tabviewer); //repDoc.Database.Tables[0].SetDataSource(dtProjectDetail); //cryParameter(repDoc); //tabviewer.ReportSource = repDoc; } }
protected void btnAddAdminDetails_Click(object sender, EventArgs e) { int i = 0; objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.ExistingJanashakti = rbdExistingJanashakti.SelectedValue.ToInt32(); objProjectBO.ThapJanashakti = txtThapJanashakti.Text.ToInt32(); objProjectBO.MinistryRaaya = txtMinistryRaaya.Text; objProjectBO.ChuttayiyekoRakam = txtChuttayiyekoRakam.Text.ToDecimal(); objProjectBO.DaatriBibaran = txtDaatriBibaran.Text; objProjectBO.NepalSarkarBibaran = txtNepalSarkarBibaran.Text; objProjectBO.MantralayaBibaran = txtMantralayaBibaran.Text; objProjectBO.PhaseOutPlan = txtPhaseOutPlan.Text; objProjectBO.ThapJanashaktiKaifiyat = txtJanaShaktiKaifiyat.Text; DataTable dt = (DataTable)Session["dt"]; if (dt != null && dt.Rows.Count > 0) { objProjectBO.Mode = "U"; } else { objProjectBO.Mode = "I"; } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.SaveAdminDetails(objProjectBO); if (i > 0) { int j = 0; //To clear project bhautik samagri objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); wbs.ClearBhautikSamagri(objProjectBO); TextBox txtBhautikSamagri = new TextBox(); DropDownList ddlUnit = new DropDownList(); TextBox txtQuantity = new TextBox(); TextBox txtAnumanitRakam = new TextBox(); TextBox txtSamagriKaifiyat = new TextBox(); foreach (RepeaterItem rptItem in rptBhautikSamagri.Items) { int k = 0; txtBhautikSamagri = (TextBox)rptItem.FindControl("txtItemName"); ddlUnit = (DropDownList)rptItem.FindControl("ddlUnit"); txtQuantity = (TextBox)rptItem.FindControl("txtQuantity"); txtAnumanitRakam = (TextBox)rptItem.FindControl("txtAnumanitRakam"); txtSamagriKaifiyat = (TextBox)rptItem.FindControl("txtSamagriKaifiyat"); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.BhautikSamagri = txtBhautikSamagri.Text; objProjectBO.UnitId = ddlUnit.SelectedValue.ToInt32(); objProjectBO.Quantity = txtQuantity.Text.ToDecimal(); objProjectBO.AnumanitRakam = txtAnumanitRakam.Text.ToDecimal(); objProjectBO.SamagriKaifiyat = txtSamagriKaifiyat.Text; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); k = wbs.SaveBhautikSamagri(objProjectBO); } Response.Write("<script>alert('Project administrative details added successfully!')</script>"); SecureQueryString str = new SecureQueryString(); str["id"] = Session["projectId"].ToString(); Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/AddEditProjectOtherDetails.aspx" + str.EncryptedString); } else { Response.Write("<script>alert('Project other details addition failed!')</script>"); } }
protected void BtnEdit_Command(object sender, CommandEventArgs e) { int projectId = 0; if (e.CommandName == "edit") { projectId = int.Parse(e.CommandArgument.ToString()); SecureQueryString str = new SecureQueryString(); str["id"] = e.CommandArgument.ToString(); Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/AddEditProject.aspx" + str.EncryptedString); } else if (e.CommandName == "delete") { int i = 0; projectId = int.Parse(e.CommandArgument.ToString()); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = projectId; objProjectBO.Mode = "D"; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.AddEditProject(objProjectBO); if (i > 0) { Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/ProjectList.aspx"); } else { Response.Write("<script>alert('Delete failed')</script>"); } } else if (e.CommandName == "lock") { int i = 0; projectId = int.Parse(e.CommandArgument.ToString()); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = projectId; objProjectBO.Mode = "L"; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.AddEditProject(objProjectBO); if (i > 0) { PopulateProjects(ddlBudgetHead.SelectedValue.ToInt32()); } //Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/ProjectList.aspx"); else { Response.Write("<script>alert('Lock failed')</script>"); } } else if (e.CommandName == "unlock") { int i = 0; projectId = int.Parse(e.CommandArgument.ToString()); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = projectId; objProjectBO.Mode = "L"; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.AddEditProject(objProjectBO); if (i > 0) { Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/ProjectList.aspx"); } else { Response.Write("<script>alert('Unlock failed')</script>"); } } else if (e.CommandName == "verify") { int i = 0; string mode = string.Empty; projectId = int.Parse(e.CommandArgument.ToString()); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = projectId; if (Session["role_id"].ToInt32() == 12) { objProjectBO.Mode = mode = "V1"; //verification level 1 } else if (Session["role_id"].ToInt32() == 13) { objProjectBO.Mode = mode = "V2"; //verification level 2 } else if (Session["role_id"].ToInt32() == 14) { objProjectBO.Mode = mode = "V3"; //verification level 3 } else if (Session["role_id"].ToInt32() == 15) { objProjectBO.Mode = mode = "V4"; //verification level 4 } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); int check = 0; check = wbs.CheckLowerLevelVerification(projectId, mode); if (check == 1) { wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.AddEditProject(objProjectBO); if (i > 0) { Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/ProjectList.aspx"); } else { Response.Write("<script>alert('Verification failed')</script>"); } } else { Response.Write("<script>alert('Verification failed. Lower level verification is required.')</script>"); } } else { } }
protected void btnAddEditProject_Click(object sender, EventArgs e) { objProjectBO = new ComProjectBO(); objProjectBO.UserId = Session["user_id"].ToInt32(); objProjectBO.OfficeId = Session["office_id"].ToInt32(); int i = 0; objProjectBO.BudgetHeadId = ddlBudgetHead.SelectedValue.ToInt32(); objProjectBO.AyojanaEngName = txtAyojanaEngName.Text; objProjectBO.AjojanaNepName = txtAyojanaNepName.Text; objProjectBO.AyojanaLakshya = txtAyojanaLakshya.Text; objProjectBO.AyojanaUdeshya = txtAyojanaUdeshya.Text; objProjectBO.AyojanaPratifal = txtAyojanaPratifal.Text; objProjectBO.AyojanaKriyakalap = txtAyojanaKriyakalap.Text; objProjectBO.KaryakramPrakar = rblKaryakramPrakar.SelectedValue.ToInt32(); objProjectBO.SuruMiti = txtSuruMiti.Text; objProjectBO.AyojanaSampannaMiti = txtAyojanaSampannaMiti.Text; objProjectBO.Sector = ddlSector.SelectedValue.ToInt32(); objProjectBO.SubSector = hidSubSector.Value.ToInt32(); objProjectBO.Rananiti = hidRananiti.Value.ToInt32(); objProjectBO.Karyaniti1 = hidKaryaniti1.Value.ToInt32(); objProjectBO.Karyaniti2 = hidKaryaniti2.Value.ToInt32(); objProjectBO.Karyaniti3 = hidKaryaniti3.Value.ToInt32(); if (rbdSahaSrabdiDigo.SelectedValue == "1") { //sahashrabdi selected objProjectBO.SahasrabdiOrDigo = 1; objProjectBO.SahasabdiBikashGantabya = hidSahasabdiBikashGantabya.Value.ToInt32(); objProjectBO.SahasabdiBikashSuchak = hidSahasabdiBikashSuchak.Value.ToInt32(); objProjectBO.SahasabdiBikashLakshya = ddlSahasabdiBikashLakshya.SelectedValue.ToInt32(); /*objProjectBO.DigoBikashGantabya = 0; * objProjectBO.DigoBikashSuchak = 0; * objProjectBO.DigoBikashLakshya = 0;*/ } else { //digo selected objProjectBO.SahasrabdiOrDigo = 2; objProjectBO.DigoBikashGantabya = hidDigoBikashGantavya.Value.ToInt32(); objProjectBO.DigoBikashSuchak = hidDigoBikashSuchak.Value.ToInt32(); objProjectBO.DigoBikashLakshya = ddlDigoBikashLakshya.SelectedValue.ToInt32(); /*objProjectBO.SahasabdiBikashGantabya = 0; * objProjectBO.SahasabdiBikashSuchak = 0; * objProjectBO.SahasabdiBikashLakshya = 0;*/ } objProjectBO.GaribiSankhet = rbdGaribiSankhet.SelectedValue.ToInt32(); objProjectBO.LaingikSankhet = rbdLaingikSankhet.SelectedValue.ToInt32(); objProjectBO.FiscalYearId = Session["fiscal_year_id"].ToInt32(); objProjectBO.ModifiedBy = Session["username"].ToString(); objProjectBO.ModifiedDate = DateTime.Now; if (Session["projectId"].ToInt32() > 0) { objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.Mode = "U"; } else { objProjectBO.Mode = "I"; } string ayojanaKishim = string.Empty; foreach (ListItem it in chkAyojanaKisim.Items) { if (it.Selected) { ayojanaKishim += it.Value + ","; } } objProjectBO.AyojanaKishim = ayojanaKishim; objProjectBO.Priority = rbdMadhyaKharchaYojana.SelectedValue.ToInt32(); objProjectBO.AyojanaLagat = txtAyojanaLagat.Text.ToDecimal(); objProjectBO.KaryanayanNikay = txtKaryanayanNikaya.Text; objProjectBO.JalvayuSanket = rbdJalBayuSanket.SelectedValue.ToInt32(); objProjectBO.YojanaRananitiNo = rbdYojanaRananiti.SelectedValue.ToInt32(); objProjectBO.IsLocked = 0; if (chkEnable.Checked) { objProjectBO.IsEnable = 1; } else { objProjectBO.IsEnable = 0; } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); DataTable dt = null; dt = wbs.GetBudgetOrganizationMapDetails(ddlBudgetHead.SelectedValue.ToInt32()); objProjectBO.MinistryId = dt.Rows[0]["Ministry_Id"].ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); // int i is the project id here i = wbs.AddEditProject(objProjectBO); if (i > 0) { int j = 0; //To clear project sansodhan objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = i; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); j = wbs.ClearProjectSansodhan(objProjectBO); TextBox txtSansodhanDate = new TextBox(); foreach (RepeaterItem rptItem in rptSansodhan.Items) { int k = 0; txtSansodhanDate = (TextBox)rptItem.FindControl("txtSansodhanDate"); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = i; objProjectBO.SansodhanDate = txtSansodhanDate.Text; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); k = wbs.SaveProjectSansodhan(objProjectBO); } Response.Write("<script>alert('Project Details added successfully!')</script>"); SecureQueryString str = new SecureQueryString(); str["id"] = i.ToString(); Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/AddEditProjectCostingTiming.aspx" + str.EncryptedString); } else { Response.Write("<script>alert('Project Details addition failed!')</script>"); } }
protected void btnSaveOthers_Click(object sender, EventArgs e) { int i = 0; objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); //objProjectBO.Swadeshi = txtSwadeshi.Text.ToInt32(); //objProjectBO.Bideshi = txtBideshi.Text.ToInt32(); //objProjectBO.ThekkaSankhya = txtThekkaSankhya.Text.ToInt32(); //objProjectBO.ThekkaRakam = txtThekkaRakam.Text.ToDecimal(); if (chkIsUsable.Checked == true) { objProjectBO.LavanbitMahila = txtLavanbitMahila.Text.ToInt32(); objProjectBO.LavanbitBalBalika = txtLavanbitBalBalika.Text.ToInt32(); objProjectBO.LavanbitJanajati = txtLavanbitJanajati.Text.ToInt32(); objProjectBO.LavanbitDalit = txtLavanbitDalit.Text.ToInt32(); objProjectBO.LavanbitMadheshi = txtLavanbitMadhesi.Text.ToInt32(); objProjectBO.LavanbitMuslim = txtLavanbitMuslim.Text.ToInt32(); objProjectBO.Anya = txtAnya.Text.ToInt32(); objProjectBO.LavanbitMahilaKaifiyat = txtLavanbitMahilaKaifiyat.Text; objProjectBO.LavanbitBalBalikaKaifiyat = txtLavanbitBalKaifiyat.Text; objProjectBO.LavanbitJanajatiKaifiyat = txtLavanbitJanaKaifiyat.Text; objProjectBO.LavanbitDalitKaifiyat = txtLavanbitDalitKaifiyat.Text; objProjectBO.LavanbitMadhesiKaifiyat = txtLavanbitMadhesiKaifiyat.Text; objProjectBO.LavanbitMuslimKaifiyat = txtLavanbitMuslimKaifiyat.Text; objProjectBO.LavanbitAnyaKaifiyat = txtAnyaKaifiyat.Text; objProjectBO.Shramdin = txtShramDin.Text.ToInt32(); objProjectBO.Parimaan = txtParimaan.Text.ToDecimal(); objProjectBO.Yogdan = txtYogdan.Text; } else { objProjectBO.LavanbitMahila = 0; objProjectBO.LavanbitBalBalika = 0; objProjectBO.LavanbitJanajati = 0; objProjectBO.LavanbitDalit = 0; objProjectBO.LavanbitMadheshi = 0; objProjectBO.LavanbitMuslim = 0; objProjectBO.Anya = 0; objProjectBO.LavanbitMahilaKaifiyat = ""; objProjectBO.LavanbitBalBalikaKaifiyat = ""; objProjectBO.LavanbitJanajatiKaifiyat = ""; objProjectBO.LavanbitDalitKaifiyat = ""; objProjectBO.LavanbitMadhesiKaifiyat = ""; objProjectBO.LavanbitMuslimKaifiyat = ""; objProjectBO.LavanbitAnyaKaifiyat = ""; objProjectBO.Shramdin = 0; objProjectBO.Parimaan = 0; objProjectBO.Yogdan = ""; } if (chkIsUsable.Checked == true) { objProjectBO.IsUsable = 1; } else { objProjectBO.IsUsable = 0; } objProjectBO.JaggaPrapti = txtJaggaPrapti.Text.ToDecimal(); objProjectBO.JaggaPraptiUnit = ddlJaggaPraptiUnit.SelectedValue.ToInt32(); DataTable dt = (DataTable)Session["dt"]; if (dt != null && dt.Rows.Count > 0) { objProjectBO.Mode = "U"; } else { objProjectBO.Mode = "I"; } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); i = wbs.SaveOtherDetails(objProjectBO); if (i > 0) { int j = 0; //To clear project paramarsha bibaran objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); j = wbs.ClearParamarshaDetails(objProjectBO); DropDownList ddlFiscalYear = new DropDownList(); TextBox txtRakamSwadeshi = new TextBox(); TextBox txtRakamBideshi = new TextBox(); foreach (RepeaterItem rptItem in rptParamarsaBibaran.Items) { int k = 0; ddlFiscalYear = (DropDownList)rptItem.FindControl("ddlAaba"); txtRakamBideshi = (TextBox)rptItem.FindControl("txtRakamBideshi"); txtRakamSwadeshi = (TextBox)rptItem.FindControl("txtRakamSwadeshi"); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.FiscalYearId = ddlFiscalYear.SelectedValue.ToInt32(); objProjectBO.RakamBideshi = txtRakamBideshi.Text.ToDecimal(); objProjectBO.RakamSwadeshi = txtRakamSwadeshi.Text.ToDecimal(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); k = wbs.SaveParamarshaBibaran(objProjectBO); } int m = 0; //To clear project paramarsha sankhya objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); m = wbs.ClearParamarshaSankhya(objProjectBO); DropDownList ddlFiscalYearPS = new DropDownList(); TextBox txtSwadeshiSankhya = new TextBox(); TextBox txtSwadeshiShramDin = new TextBox(); TextBox txtBideshiSankhya = new TextBox(); TextBox txtBideshiShramDin = new TextBox(); foreach (RepeaterItem rptItem in rptParamarshaSankhya.Items) { int k = 0; ddlFiscalYearPS = (DropDownList)rptItem.FindControl("ddlAaba"); txtSwadeshiSankhya = (TextBox)rptItem.FindControl("txtSwadeshiSankhya"); txtSwadeshiShramDin = (TextBox)rptItem.FindControl("txtSwadeshiShramDin"); txtBideshiSankhya = (TextBox)rptItem.FindControl("txtBideshiSankhya"); txtBideshiShramDin = (TextBox)rptItem.FindControl("txtBideshiShramDin"); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.FiscalYearId = ddlFiscalYearPS.SelectedValue.ToInt32(); objProjectBO.Swadeshi = txtSwadeshiSankhya.Text.ToInt32(); objProjectBO.Bideshi = txtBideshiSankhya.Text.ToInt32(); objProjectBO.SwadeshiShramDin = txtSwadeshiShramDin.Text.ToDecimal(); objProjectBO.BideshiShramDin = txtBideshiShramDin.Text.ToDecimal(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); k = wbs.SaveParamarshaSankhya(objProjectBO); } //To clear project thekka sankhya objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); j = wbs.ClearProjectThekkaSankhya(objProjectBO); DropDownList ddlFiscalYearA = new DropDownList(); TextBox txtThekkaSankhyaA = new TextBox(); TextBox txtThekkaRakamA = new TextBox(); foreach (RepeaterItem rptItem in rptThekkaSankhyaRakam.Items) { int k = 0; ddlFiscalYearA = (DropDownList)rptItem.FindControl("ddlAaba"); txtThekkaSankhyaA = (TextBox)rptItem.FindControl("txtThekkaSankhya"); txtThekkaRakamA = (TextBox)rptItem.FindControl("txtThekkaRakam"); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.FiscalYearId = ddlFiscalYearA.SelectedValue.ToInt32(); objProjectBO.ThekkaSankhya = txtThekkaSankhyaA.Text.ToInt32(); objProjectBO.ThekkaRakam = txtThekkaRakamA.Text.ToDecimal(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); k = wbs.SaveProjectThekkaSankhya(objProjectBO); } //To clear project Aayojana pramukh objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); wbs.ClearAayojanaPramukh(objProjectBO); TextBox txtPramukhStartDate = new TextBox(); TextBox txtPramukhName = new TextBox(); foreach (RepeaterItem rptItem in rptAayojanaPramukh.Items) { txtPramukhStartDate = (TextBox)rptItem.FindControl("txtPramukhStartDate"); txtPramukhName = (TextBox)rptItem.FindControl("txtPramukhName"); objProjectBO = new ComProjectBO(); objProjectBO.ProjectId = Session["projectId"].ToInt32(); objProjectBO.PramukhStartDate = txtPramukhStartDate.Text; objProjectBO.PramukhName = txtPramukhName.Text; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); wbs.SaveAayojanaPramukh(objProjectBO); } Response.Write("<script>alert('Project details added successfully!')</script>"); Response.Redirect(Constants.ConstantAppPath + "/Modules/ProjectManagement/ProjectList.aspx"); } else { Response.Write("<script>alert('Project details addition failed!')</script>"); } }
private void PopulateProjectDetails(int projectId) { DataTable dtProjectSansodhan = null; ComProjectBO obj = new ComProjectBO(); DataTable dtPopulateProjectDetails = null; obj.ProjectId = projectId; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtPopulateProjectDetails = wbs.PopulateProjectDetails(obj); if (dtPopulateProjectDetails != null && dtPopulateProjectDetails.Rows.Count > 0) { ddlBudgetHead.SelectedValue = dtPopulateProjectDetails.Rows[0]["BUDGET_HEAD_ID"].ToString(); txtAyojanaNepName.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_NEP_NAME"].ToString(); txtAyojanaEngName.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_ENG_NAME"].ToString(); txtAyojanaLakshya.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_LAKSHYA"].ToString(); txtAyojanaUdeshya.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_UDESHYA"].ToString(); txtAyojanaPratifal.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_PRATIFAL"].ToString(); txtAyojanaKriyakalap.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_MAIN_ACTIVITY"].ToString(); rblKaryakramPrakar.SelectedValue = dtPopulateProjectDetails.Rows[0]["PROJECT_PROGRAM_TYPE"].ToString(); txtSuruMiti.Text = dtPopulateProjectDetails.Rows[0]["SURU_MITI"].ToString(); txtAyojanaSampannaMiti.Text = dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI"].ToString(); rbdJalBayuSanket.SelectedValue = dtPopulateProjectDetails.Rows[0]["JALVAYU_SANKET"].ToString(); rbdYojanaRananiti.SelectedValue = dtPopulateProjectDetails.Rows[0]["YOJANA_RANANITI_NO"].ToString(); lblModification.Text = dtPopulateProjectDetails.Rows[0]["MODIFIED_DATE"].ToDateTime().ToString("D"); lblModifiedBy.Text = dtPopulateProjectDetails.Rows[0]["MODIFIED_BY"].ToString(); /* txtAyojanaSampannaMitiPratham.Text =dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI1"].ToString(); * txtAyojanaSampannaMitiDoshro.Text =dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI2"].ToString(); * txtAyojanaSampannaMitiTeshro.Text =dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI3"].ToString();*/ ddlSector.SelectedValue = dtPopulateProjectDetails.Rows[0]["SECTOR_ID"].ToString(); Session["project_ministry_id"] = dtPopulateProjectDetails.Rows[0]["MINISTRY_ID"].ToInt32(); SectorService objWebService = new SectorService(); ComSubSector objComSubSector = new ComSubSector(); DataTable dtPopulateSubSector = null; objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector(); objComSubSector.SectorId = dtPopulateProjectDetails.Rows[0]["SECTOR_ID"].ToInt32(); objComSubSector.Lang = Session["LanguageSetting"].ToString(); dtPopulateSubSector = objWebService.PopulateSubSectorsBySectorId(objComSubSector); if (dtPopulateSubSector != null && dtPopulateSubSector.Rows.Count > 0) { ddlSubSector.DataSource = dtPopulateSubSector; ddlSubSector.DataTextField = "SUB_SECTOR_NAME"; ddlSubSector.DataValueField = "ACTIVITY_SUB_SECTOR_ID"; ddlSubSector.DataBind(); ddlSubSector.Items.Insert(0, "छान्नुहोस्"); } hidSubSector.Value = ddlSubSector.SelectedValue = dtPopulateProjectDetails.Rows[0]["SUB_SECTOR_ID"].ToString(); ProjectService objPs = new ProjectService(); EntitySubSector objCss = new EntitySubSector(); DataTable dtPopulateRananiti = null; objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); objCss.SubSectorId = ddlSubSector.SelectedValue.ToInt32(); objCss.Lang = Session["LanguageSetting"].ToString(); dtPopulateRananiti = objPs.PopulateRananitiBySubSectorId(objCss); if (dtPopulateRananiti != null && dtPopulateRananiti.Rows.Count > 0) { ddlRananiti.DataSource = dtPopulateRananiti; ddlRananiti.DataTextField = "RANANITI_NAME"; ddlRananiti.DataValueField = "RANANITI_ID"; ddlRananiti.DataBind(); ddlRananiti.Items.Insert(0, "छान्नुहोस्"); } hidRananiti.Value = ddlRananiti.SelectedValue = dtPopulateProjectDetails.Rows[0]["RANANITI_ID"].ToString(); objPs = new ProjectService(); ComProjectBO objComProjectBO = new ComProjectBO(); DataTable dtPopulateKaryaniti = new DataTable(); objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); objComProjectBO.Rananiti = ddlRananiti.SelectedValue.ToInt32(); objComProjectBO.Lang = Session["LanguageSetting"].ToString(); dtPopulateKaryaniti = objPs.PopulateKaryanitiByRananitiId(objComProjectBO); if (dtPopulateKaryaniti != null && dtPopulateKaryaniti.Rows.Count > 0) { ddlKaryaniti1.DataSource = dtPopulateKaryaniti; ddlKaryaniti1.DataTextField = "KARYANITI_NAME"; ddlKaryaniti1.DataValueField = "KARYANITI_ID"; ddlKaryaniti1.DataBind(); ddlKaryaniti1.Items.Insert(0, "छान्नुहोस्"); ddlKaryaniti2.DataSource = dtPopulateKaryaniti; ddlKaryaniti2.DataTextField = "KARYANITI_NAME"; ddlKaryaniti2.DataValueField = "KARYANITI_ID"; ddlKaryaniti2.DataBind(); ddlKaryaniti2.Items.Insert(0, "छान्नुहोस्"); ddlKaryaniti3.DataSource = dtPopulateKaryaniti; ddlKaryaniti3.DataTextField = "KARYANITI_NAME"; ddlKaryaniti3.DataValueField = "KARYANITI_ID"; ddlKaryaniti3.DataBind(); ddlKaryaniti3.Items.Insert(0, "छान्नुहोस्"); } hidKaryaniti1.Value = ddlKaryaniti1.SelectedValue = dtPopulateProjectDetails.Rows[0]["KARYANITI_ID1"].ToString(); hidKaryaniti2.Value = ddlKaryaniti2.SelectedValue = dtPopulateProjectDetails.Rows[0]["KARYANITI_ID2"].ToString(); hidKaryaniti3.Value = ddlKaryaniti3.SelectedValue = dtPopulateProjectDetails.Rows[0]["KARYANITI_ID3"].ToString(); //added later if (dtPopulateProjectDetails.Rows[0]["SAHASRABDI_OR_DIGO"].ToInt32() == 1) { rbdSahaSrabdiDigo.SelectedValue = "1"; /*sahaSrabdi1.Visible = true; * sahaSrabdi2.Visible = true; * sahaSrabdi3.Visible = true; * digo1.Visible = false; * digo2.Visible = false; * digo3.Visible = false;*/ } else { rbdSahaSrabdiDigo.SelectedValue = "2"; /*sahaSrabdi1.Visible = false; * sahaSrabdi2.Visible = false; * sahaSrabdi3.Visible = false; * digo1.Visible = true; * digo2.Visible = true; * digo3.Visible = true;*/ } ddlSahasabdiBikashLakshya.SelectedValue = dtPopulateProjectDetails.Rows[0]["SAHA_BIKASH_LAKSHYA"].ToString(); ddlDigoBikashLakshya.SelectedValue = dtPopulateProjectDetails.Rows[0]["DIGO_BIKASH_LAKSHYA"].ToString(); if (dtPopulateProjectDetails.Rows[0]["SAHASRABDI_OR_DIGO"].ToInt32() == 1) { PopulateSahashrabdiBikashGantabya(); } else { PopulateDigoBikashGantabya(); } /* objPs = new ProjectService(); * objComProjectBO = new ComProjectBO(); * DataTable dtPopulateGantabya = new DataTable(); * DataTable dtPopulateDigoGantabya = new DataTable(); * * objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); * objComProjectBO.SahasabdiBikashLakshya = ddlSahasabdiBikashLakshya.SelectedValue.ToInt32(); * objComProjectBO.Lang = Session["LanguageSetting"].ToString(); * objComProjectBO.DigoBikashLakshya = ddlDigoBikashLakshya.SelectedValue.ToInt32(); * dtPopulateGantabya = objPs.PopulateSahashrabdiBikashGantabya(objComProjectBO); * dtPopulateDigoGantabya = objPs.PopulateDigoBikashGantabya(objComProjectBO); * * if (dtPopulateGantabya != null && dtPopulateGantabya.Rows.Count > 0) * { * ddlSahasabdiBikashGantabya.DataSource = dtPopulateGantabya; * ddlSahasabdiBikashGantabya.DataTextField = "GANTABYA_NAME"; * ddlSahasabdiBikashGantabya.DataValueField = "GANTABYA_ID"; * ddlSahasabdiBikashGantabya.DataBind(); * ddlSahasabdiBikashGantabya.Items.Insert(0, "छान्नुहोस्"); * * }*/ hidSahasabdiBikashGantabya.Value = ddlSahasabdiBikashGantabya.SelectedValue = dtPopulateProjectDetails.Rows[0]["SAHA_BIKASH_GANTABYA"].ToString(); /*if (dtPopulateDigoGantabya != null && dtPopulateDigoGantabya.Rows.Count > 0) * { * ddlDigoBikashGantabya.DataSource = dtPopulateDigoGantabya; * ddlDigoBikashGantabya.DataTextField = "DIGO_GANTABYA_NAME"; * ddlDigoBikashGantabya.DataValueField = "DIGO_GANTABYA_ID"; * ddlDigoBikashGantabya.DataBind(); * ddlDigoBikashGantabya.Items.Insert(0, "छान्नुहोस्"); * }*/ hidDigoBikashGantavya.Value = ddlDigoBikashGantabya.SelectedValue = dtPopulateProjectDetails.Rows[0]["DIGO_BIKASH_GANTABYA"].ToString(); if (dtPopulateProjectDetails.Rows[0]["SAHASRABDI_OR_DIGO"].ToInt32() == 1) { PopulateSahashrabdiBikashSuchak(); } else { PopulateDigoBikashSuchak(); } /*objPs = new ProjectService(); * objComProjectBO = new ComProjectBO(); * DataTable dtPopulateSuchak = new DataTable(); * DataTable dtPopulateDigoSuchak = new DataTable(); * objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); * objComProjectBO.SahasabdiBikashGantabya = ddlSahasabdiBikashGantabya.SelectedValue.ToInt32(); * objComProjectBO.Lang = Session["LanguageSetting"].ToString(); * objComProjectBO.DigoBikashGantabya = ddlDigoBikashGantabya.SelectedValue.ToInt32(); * dtPopulateSuchak = objPs.PopulateSahashrabdiBikashSuchak(objComProjectBO); * dtPopulateDigoSuchak = objPs.PopulateDigoBikashSuchak(objComProjectBO); * if (dtPopulateSuchak != null && dtPopulateSuchak.Rows.Count > 0) * { * ddlSahasabdiBikashSuchak.DataSource = dtPopulateSuchak; * ddlSahasabdiBikashSuchak.DataTextField = "SUCHAK_NAME"; * ddlSahasabdiBikashSuchak.DataValueField = "SUCHAK_ID"; * ddlSahasabdiBikashSuchak.DataBind(); * ddlSahasabdiBikashSuchak.Items.Insert(0, "छान्नुहोस्"); * } * * if (dtPopulateDigoSuchak != null && dtPopulateDigoSuchak.Rows.Count > 0) * { * ddlDigoBikashSuchak.DataSource = dtPopulateDigoSuchak; * ddlDigoBikashSuchak.DataTextField = "DIGO_SUCHAK_NAME"; * ddlDigoBikashSuchak.DataValueField = "DIGO_SUCHAK_ID"; * ddlDigoBikashSuchak.DataBind(); * ddlDigoBikashSuchak.Items.Insert(0, "छान्नुहोस्"); * }*/ hidSahasabdiBikashSuchak.Value = ddlSahasabdiBikashSuchak.SelectedValue = dtPopulateProjectDetails.Rows[0]["SAHA_BIKASH_SUCHAK"].ToString(); hidDigoBikashSuchak.Value = ddlDigoBikashSuchak.SelectedValue = dtPopulateProjectDetails.Rows[0]["DIGO_BIKASH_SUCHAK"].ToString(); rbdGaribiSankhet.SelectedValue = dtPopulateProjectDetails.Rows[0]["GARIBI_SANKET"].ToString(); rbdLaingikSankhet.SelectedValue = dtPopulateProjectDetails.Rows[0]["LAINGIK_SANKET"].ToString(); string AayojanaKisim = dtPopulateProjectDetails.Rows[0]["AAYOJANA_KISIM"].ToString(); List <string> AayojanaType = AayojanaKisim.Split(new char[] { ',' }).ToList <string>(); for (int i = 0; i < chkAyojanaKisim.Items.Count; i++) { for (int j = 0; j < AayojanaType.Count; j++) { if (chkAyojanaKisim.Items[i].Value == AayojanaType[j]) { chkAyojanaKisim.Items[i].Selected = true; break; } } } rbdMadhyaKharchaYojana.SelectedValue = dtPopulateProjectDetails.Rows[0]["PRIORITY"].ToString(); txtKaryanayanNikaya.Text = dtPopulateProjectDetails.Rows[0]["NIKAAYA"].ToString(); txtAyojanaLagat.Text = dtPopulateProjectDetails.Rows[0]["KUL_LAAGAT"].ToString(); if (dtPopulateProjectDetails.Rows[0]["IS_ENABLE"].ToInt32() == 1) { chkEnable.Checked = true; } else { chkEnable.Checked = false; } obj = new ComProjectBO(); obj.ProjectId = projectId; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtProjectSansodhan = wbs.PopulateProjectSansodhan(obj); dtA = dtProjectSansodhan; if (dtProjectSansodhan != null && dtProjectSansodhan.Rows.Count > 0) { rptSansodhan.DataSource = dtProjectSansodhan; rptSansodhan.DataBind(); foreach (RepeaterItem rptItem in rptSansodhan.Items) { TextBox txtSansodhanDate = new TextBox(); txtSansodhanDate = (TextBox)rptItem.FindControl("txtSansodhanDate"); } } else { dtA.Clear(); DataRow drB = dtA.NewRow(); drB["SANSODHAN_DATE"] = ""; dtA.Rows.Add(drB); rptSansodhan.DataSource = dtA; rptSansodhan.DataBind(); } } }
/*protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e) * { * rptParamarsaBibaran.DataSource = null; * rptParamarsaBibaran.DataBind(); * PopulateOtherDetails(ddlBudgetHead.SelectedValue.ToInt32(), ddlProject.SelectedValue.ToInt32()); * }*/ private void PopulateOtherDetails(int projectId) { DataTable dtParamasrhaBibaran = null; objProjectBO = new ComProjectBO(); //objProjectBO.BudgetHeadId = ddlBudgetHeadId; objProjectBO.ProjectId = projectId; wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); Session["dt"] = wbs.PopulateOtherDetails(objProjectBO); DataTable dt = (DataTable)Session["dt"]; if (dt != null && dt.Rows.Count > 0) { //txtSwadeshi.Text = dt.Rows[0]["SWADESHI"].ToString(); //txtBideshi.Text = dt.Rows[0]["BIDESHI"].ToString(); //txtThekkaSankhya.Text = dt.Rows[0]["THEKKA_SANKHYA"].ToString(); //txtThekkaRakam.Text = dt.Rows[0]["THEKKA_RAKAM"].ToString(); txtLavanbitMahila.Text = dt.Rows[0]["LAVANBIT_MAHILA"].ToString(); txtLavanbitBalBalika.Text = dt.Rows[0]["LAVANBIT_BALBALIKA"].ToString(); txtLavanbitDalit.Text = dt.Rows[0]["LAVANBIT_DALIT"].ToString(); txtLavanbitMadhesi.Text = dt.Rows[0]["LAVANBIT_MADHESI"].ToString(); txtLavanbitJanajati.Text = dt.Rows[0]["LAVANBIT_JANAJATI"].ToString(); txtLavanbitMuslim.Text = dt.Rows[0]["LAVANBIT_MUSLIM"].ToString(); txtAnya.Text = dt.Rows[0]["ANYA"].ToString(); if (dt.Rows[0]["IS_USABLE"].ToString() == "1") { chkIsUsable.Checked = true; } else { chkIsUsable.Checked = false; } txtLavanbitMahilaKaifiyat.Text = dt.Rows[0]["LAVANBIT_MAHILA_KAIFIYAT"].ToString(); txtLavanbitBalKaifiyat.Text = dt.Rows[0]["LAVANBIT_BALBALIKA_KAIFIYAT"].ToString(); txtLavanbitDalitKaifiyat.Text = dt.Rows[0]["LAVANBIT_DALIT_KAIFIYAT"].ToString(); txtLavanbitMadhesiKaifiyat.Text = dt.Rows[0]["LAVANBIT_JANAJATI_KAIFIYAT"].ToString(); txtLavanbitJanaKaifiyat.Text = dt.Rows[0]["LAVANBIT_MADHESI_KAIFIYAT"].ToString(); txtLavanbitMuslimKaifiyat.Text = dt.Rows[0]["LAVANBIT_MUSLIM_KAIFIYAT"].ToString(); txtAnyaKaifiyat.Text = dt.Rows[0]["ANYA_KAIFIYAT"].ToString(); txtShramDin.Text = dt.Rows[0]["SHRAMDIN"].ToString(); txtParimaan.Text = dt.Rows[0]["PARIMAAN"].ToString(); txtYogdan.Text = dt.Rows[0]["YOGDAN"].ToString(); txtJaggaPrapti.Text = dt.Rows[0]["JAGGA_PRAPTI"].ToString(); ddlJaggaPraptiUnit.SelectedValue = dt.Rows[0]["JAGGA_PRAPTI_UNIT"].ToString(); dtParamarsaBibaran = wbs.PopulateParamarshaBibaran(objProjectBO); dtA = dtParamarsaBibaran; if (dtParamarsaBibaran != null && dtParamarsaBibaran.Rows.Count > 0) { rptParamarsaBibaran.DataSource = dtParamarsaBibaran; rptParamarsaBibaran.DataBind(); foreach (RepeaterItem rptItem in rptParamarsaBibaran.Items) { DropDownList ddlFiscalYear = new DropDownList(); TextBox txtRakamSwadeshi = new TextBox(); TextBox txtRakamBideshi = new TextBox(); ddlFiscalYear = (DropDownList)rptItem.FindControl("ddlAaba"); txtRakamBideshi = (TextBox)rptItem.FindControl("txtRakamBideshi"); txtRakamSwadeshi = (TextBox)rptItem.FindControl("txtRakamSwadeshi"); } } else { dtA.Clear(); DataRow drB = dtA.NewRow(); drB["FISCAL_YEAR_ID"] = 0; drB["RAKAM_SWADESHI"] = 0.0; drB["RAKAM_BIDESHI"] = 0.0; dtA.Rows.Add(drB); rptParamarsaBibaran.DataSource = dtA; rptParamarsaBibaran.DataBind(); } dtParamarshaSankhya = wbs.PopulateParamarshaSankhya(objProjectBO); dtAPS = dtParamarshaSankhya; if (dtParamarshaSankhya != null && dtParamarshaSankhya.Rows.Count > 0) { rptParamarshaSankhya.DataSource = dtParamarshaSankhya; rptParamarshaSankhya.DataBind(); foreach (RepeaterItem rptItem in rptParamarshaSankhya.Items) { DropDownList ddlFiscalYear = new DropDownList(); TextBox txtSwadeshiSankhya = new TextBox(); TextBox txtBideshiSankhya = new TextBox(); ddlFiscalYear = (DropDownList)rptItem.FindControl("ddlAaba"); txtSwadeshiSankhya = (TextBox)rptItem.FindControl("txtSwadeshiSankhya"); txtBideshiSankhya = (TextBox)rptItem.FindControl("txtBideshiSankhya"); } } else { dtAPS.Clear(); DataRow drB = dtAPS.NewRow(); drB["FISCAL_YEAR_ID"] = 0; drB["SWADESHI"] = 0; drB["BIDESHI"] = 0; drB["SWADESHI_SHRAM_DIN"] = 0; drB["BIDESHI_SHRAM_DIN"] = 0; dtAPS.Rows.Add(drB); rptParamarshaSankhya.DataSource = dtAPS; rptParamarshaSankhya.DataBind(); } dtThekkaSankhyaRakam = wbs.PopulateThekkaSankhyaRakam(objProjectBO); dtAT = dtThekkaSankhyaRakam; if (dtThekkaSankhyaRakam != null && dtThekkaSankhyaRakam.Rows.Count > 0) { rptThekkaSankhyaRakam.DataSource = dtThekkaSankhyaRakam; rptThekkaSankhyaRakam.DataBind(); foreach (RepeaterItem rptItem in rptThekkaSankhyaRakam.Items) { DropDownList ddlFiscalYear = new DropDownList(); TextBox txtThekkaSankhyaA = new TextBox(); TextBox txtThekkaRakamA = new TextBox(); ddlFiscalYear = (DropDownList)rptItem.FindControl("ddlAaba"); txtThekkaSankhyaA = (TextBox)rptItem.FindControl("txtThekkaSankhya"); txtThekkaRakamA = (TextBox)rptItem.FindControl("txtThekkaRakam"); } } else { dtAT.Clear(); DataRow drB = dtAT.NewRow(); drB["FISCAL_YEAR_ID"] = 0; drB["THEKKA_SANKHYA"] = 0; drB["THEKKA_RAKAM"] = 0; dtAT.Rows.Add(drB); rptThekkaSankhyaRakam.DataSource = dtAT; rptThekkaSankhyaRakam.DataBind(); } wbs = new ProjectService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject(); dtAayojanaPramukh = wbs.PopulateAayojanaPramukh(objProjectBO); dtAP = dtAayojanaPramukh; if (dtAayojanaPramukh != null && dtAayojanaPramukh.Rows.Count > 0) { rptAayojanaPramukh.DataSource = dtAayojanaPramukh; rptAayojanaPramukh.DataBind(); foreach (RepeaterItem rptItem in rptAayojanaPramukh.Items) { TextBox txtPramukhStartDate = new TextBox(); TextBox txtPramukhName = new TextBox(); txtPramukhStartDate = (TextBox)rptItem.FindControl("txtPramukhStartDate"); txtPramukhName = (TextBox)rptItem.FindControl("txtPramukhName"); } } else { dtAP.Clear(); DataRow drB = dtAP.NewRow(); drB["PRAMUKH_START_DATE"] = ""; drB["PRAMUKH_NAME"] = ""; dtAP.Rows.Add(drB); rptAayojanaPramukh.DataSource = dtAP; rptAayojanaPramukh.DataBind(); } } }
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); * * }*/ }