protected void GetFileDetails(object sender, EventArgs e) { string tracker_id = (sender as LinkButton).CommandArgument; string usr_id = string.Empty; DataTable dt = DataEntryTracker.ReturnFileDetails(tracker_id); if (dt.Rows.Count > 0) { DataRow dtrow = dt.Rows[0]; cboPartner.SelectedValue = dtrow["prt_id"].ToString(); cboDistrict.SelectedValue = dtrow["dst_id"].ToString(); cboRegion.SelectedValue = dtrow["rgn_id"].ToString(); txtCreateDateFrom.Text = dtrow["tracker_date_from"].ToString(); txtCreateDateTo.Text = dtrow["tracker_date_to"].ToString(); DataEntryTracker.tracker_id = dtrow["tracker_id"].ToString(); usr_id = dtrow["usr_id"].ToString(); if (Session[utilSOCYWeb.cSVUserID].ToString().Equals(usr_id)) { btnupload.Enabled = true; } else { btnupload.Enabled = false; } } }
protected void LoadTrackerList() { dt = DataEntryTracker.LoadTrackerLists(); if (dt.Rows.Count != 0) { gdvDataEntry.DataSource = dt; gdvDataEntry.DataBind(); } }
protected void GetDataEntryTrackerList() { DataTable dt = DataEntryTracker.ReturnDataEntryTrackerList(Session[utilSOCYWeb.cSVUserID].ToString()); if (dt.Rows.Count > 0) { gdvDataEntry.DataSource = dt; gdvDataEntry.DataBind(); } }
protected void LoadDistricts() { DataTable dt = DataEntryTracker.ReturnDistrictList(); if (dt.Rows.Count > 0) { DataRow dtEmptyRow = dt.NewRow(); dtEmptyRow["dst_id"] = "-1"; dtEmptyRow["dst_name"] = "Select District"; dt.Rows.InsertAt(dtEmptyRow, 0); cbo_district.DataSource = dt; cbo_district.DataValueField = "dst_id"; cbo_district.DataTextField = "dst_name"; cbo_district.DataBind(); } }
protected void LoadReport(string tracker_id) { ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("~/cr_DataEntryTracker.rpt")); foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in crystalReport.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } DataSet ds = DataEntryTracker._ReturnDataEntryReport("weekly_tracker_report", tracker_id); crystalReport.SetDataSource(ds); crystalReport.SetParameterValue("@QueryType", "weekly_tracker_report"); CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None; CrystalReportViewer1.ReportSource = crystalReport; }
protected void btnsave_Click(object sender, EventArgs e) { string tracker_id = string.Empty; if (Request.QueryString["Token_id"] != null) { tracker_id = Request.QueryString["Token_id"].ToString(); } else { tracker_id = string.Empty; } if (ValidateInput() == false) { string script = "alert(\"Fill in all required values!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } else { DataEntryTracker.Return_previous_tracker_total_tools_received(cbo_district.SelectedValue.ToString(), tracker_id); DataEntryTracker.Return_Tools_entered(cbo_district.SelectedValue.ToString()); save_tracker(); #region Update manual Tables DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_linkage_total_entered", DataEntryTracker.t_linkage_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_youth_savings_total_entered", DataEntryTracker.t_youth_savings_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_appre_progress_total_entered", DataEntryTracker.t_appre_progress_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_training_inventory_total_entered", DataEntryTracker.t_training_inventory_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_youth_ass_toolkit_total_entered", DataEntryTracker.t_youth_ass_toolkit_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_reintergration_total_entered", DataEntryTracker.t_reintergration_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_dreams_registration_total_entered", DataEntryTracker.t_dreams_registration_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_hct_total_entered", DataEntryTracker.t_hct_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_dreams_partner_total_entered", DataEntryTracker.t_dreams_partner_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_sunovuyo_total_entered", DataEntryTracker.t_sunovuyo_total_entered); DataEntryTracker.Update_manual_tools(cbo_district.SelectedValue.ToString(), "t_dreams_stepping_stones_total_entered", DataEntryTracker.t_dreams_stepping_stones_total_entered); #endregion Update manual Tables } }
protected bool ValidateDuplicate() { int count = 0; bool isValid = false; DataEntryTracker.tracker_date_from = Convert.ToDateTime(txtCreateDateFrom.Text).ToString("yyyy-MM-dd"); DataEntryTracker.tracker_date_to = Convert.ToDateTime(txtCreateDateTo.Text).ToString("yyyy-MM-dd"); DataEntryTracker.prt_id = cboPartner.SelectedValue.ToString(); DataEntryTracker.dst_id = cboDistrict.SelectedValue.ToString(); count = DataEntryTracker.ValidateDuplicate(); if (count > 0) { isValid = false; } else { isValid = true; } return(isValid); }
protected void LoadBushenyiTrackerReport(string tracker_id) { cr_DataEntryTracker objRptMain = new cr_DataEntryTracker(); ReportDocument objSubRpt = new ReportDocument(); objSubRpt.Load(Server.MapPath("~/Bushenyi_sub_report.rpt")); //foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objSubRpt.Database.Tables) //{ // Set_Report_logons.SetTableLogin(tbCurrent); //} foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in objRptMain.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } foreach (ReportDocument subreport in objRptMain.Subreports) { foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in subreport.Database.Tables) { Set_Report_logons.SetTableLogin(CrTable); } } DataSet ds = DataEntryTracker._ReturnDataEntryReport("Data_entry_weekly_tracker_report", tracker_id); objSubRpt = objRptMain.OpenSubreport("Bushenyi_sub_report.rpt"); objSubRpt.SetDataSource(ds); //objRptMain.SetParameterValue("@QueryType", "weekly_tracker_report"); objRptMain.SetParameterValue("@QueryType", "Data_entry_weekly_tracker_report", objRptMain.Subreports[0].Name.ToString()); objRptMain.SetParameterValue("@Tracker_id", tracker_id, objRptMain.Subreports[0].Name.ToString()); CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None; objRptMain.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "Tracker"); CrystalReportViewer1.ReportSource = objRptMain; }
protected void save_tracker() { string tracker_id = string.Empty; if (Request.QueryString["Token_id"] != null) { tracker_id = Request.QueryString["Token_id"].ToString(); } else { tracker_id = string.Empty; } #region set variables #region Globals DataEntryTracker.dst_id = cbo_district.SelectedValue.ToString(); DataEntryTracker.usr_id_create = Session[utilSOCYWeb.cSVUserID].ToString(); DataEntryTracker.tracker_date = DateTime.Today; DataEntryTracker.t_comments = txt_comment.Text; #endregion Globals #region total_received DataEntryTracker.t_ipt_total_received = txt_ipt.Text != string.Empty ? Convert.ToInt32(txt_ipt.Text) :0; DataEntryTracker.t_hat_total_received = txt_hat.Text != string.Empty ? Convert.ToInt32(txt_hat.Text) : 0; DataEntryTracker.t_hip_total_received = txt_hip.Text != string.Empty ? Convert.ToInt32(txt_hip.Text) : 0; DataEntryTracker.t_hv_total_received = txt_home_visit.Text != string.Empty ? Convert.ToInt32(txt_home_visit.Text) : 0; DataEntryTracker.t_rat_total_received = txt_rat.Text != string.Empty ? Convert.ToInt32(txt_rat.Text) : 0; DataEntryTracker.t_linkage_total_received = txt_linkages.Text != string.Empty ? Convert.ToInt32(txt_linkages.Text) : 0; DataEntryTracker.t_refferal_total_received = txt_referal.Text != string.Empty ? Convert.ToInt32(txt_referal.Text) : 0; DataEntryTracker.t_edu_subsidy_total_received = txt_edu_subsidy.Text != string.Empty ? Convert.ToInt32(txt_edu_subsidy.Text) :0; DataEntryTracker.t_cTraining_SILC_total_received = txt_comm_SILC.Text != string.Empty ? Convert.ToInt32(txt_comm_SILC.Text) :0; DataEntryTracker.t_cTraining_youth_total_received = txt_comm_youth.Text != string.Empty ? Convert.ToInt32(txt_comm_youth.Text) : 0; DataEntryTracker.t_youth_savings_total_received = txt_youth_saving.Text != string.Empty ? Convert.ToInt32(txt_youth_saving.Text) : 0; DataEntryTracker.t_appre_progress_total_received = txt_app_progress.Text != string.Empty ?Convert.ToInt32(txt_app_progress.Text) : 0; DataEntryTracker.t_training_inventory_total_received = txt_training_inventory.Text != string.Empty ? Convert.ToInt32(txt_training_inventory.Text) : 0; DataEntryTracker.t_appre_skill_aqui_total_received = txt_skill_aquisition.Text != string.Empty ?Convert.ToInt32(txt_skill_aquisition.Text) : 0; DataEntryTracker.t_training_comple_total_received = txt_training_completion.Text != string.Empty ? Convert.ToInt32(txt_training_completion.Text) : 0; DataEntryTracker.t_youth_ass_toolkit_total_received = txt_ass_awarding_tool_kit.Text != string.Empty ? Convert.ToInt32(txt_ass_awarding_tool_kit.Text) : 0; DataEntryTracker.t_youth_tracer_total_received = txt_youth_tracer.Text != string.Empty ? Convert.ToInt32(txt_youth_tracer.Text) : 0; DataEntryTracker.t_dovcc_total_received = txt_dovcc.Text != string.Empty ? Convert.ToInt32(txt_dovcc.Text) : 0; DataEntryTracker.t_sovcc_total_received = txt_sovcc.Text != string.Empty ? Convert.ToInt32(txt_sovcc.Text) : 0; DataEntryTracker.t_cbsd_resource_alloc_total_received = txt_cbsd_resource.Text != string.Empty ? Convert.ToInt32(txt_cbsd_resource.Text) : 0; DataEntryTracker.t_cbsd_staff_appra_total_received = txt_staff_appraisal.Text != string.Empty ? Convert.ToInt32(txt_staff_appraisal.Text) : 0; DataEntryTracker.t_reintergration_total_received = txt_reintergration.Text != string.Empty ? Convert.ToInt32(txt_reintergration.Text) : 0; DataEntryTracker.t_dreams_registration_total_received = txt_dreams_registration.Text != string.Empty ? Convert.ToInt32(txt_dreams_registration.Text) : 0; DataEntryTracker.t_hct_total_received = txt_hct_registration.Text != string.Empty ? Convert.ToInt32(txt_hct_registration.Text) : 0; DataEntryTracker.t_dreams_partner_total_received = txt_dreams_partner.Text != string.Empty ? Convert.ToInt32(txt_dreams_partner.Text) : 0; DataEntryTracker.t_sunovuyo_total_received = txt_sinovuyo.Text != string.Empty ? Convert.ToInt32(txt_sinovuyo.Text) : 0; DataEntryTracker.t_dreams_stepping_stones_total_received = txt_stepping_stones.Text != string.Empty ? Convert.ToInt32(txt_stepping_stones.Text) : 0; DataEntryTracker.t_dreams_screening_total_received = txt_dreams_screening.Text != string.Empty ? Convert.ToInt32(txt_dreams_screening.Text) : 0; DataEntryTracker.t_dreams_sasa_total_received = txt_sasa_session.Text != string.Empty ? Convert.ToInt32(txt_sasa_session.Text) : 0; DataEntryTracker.t_viral_load_total_received = txt_viral_load.Text != string.Empty ? Convert.ToInt32(txt_viral_load.Text) : 0; #endregion total_received #region total_entered DataEntryTracker.t_ipt_total_entered = txt_ipt_entered.Text != string.Empty ? Convert.ToInt32(txt_ipt_entered.Text) : 0; DataEntryTracker.t_hat_total_entered = txt_hat_entered.Text != string.Empty ? Convert.ToInt32(txt_hat_entered.Text) : 0; DataEntryTracker.t_hip_total_entered = txt_hip_entered.Text != string.Empty ? Convert.ToInt32(txt_hip_entered.Text) : 0; DataEntryTracker.t_hv_total_entered = txt_home_visit_entered.Text != string.Empty ? Convert.ToInt32(txt_home_visit_entered.Text) : 0; DataEntryTracker.t_rat_total_entered = txt_rat_entered.Text != string.Empty ? Convert.ToInt32(txt_rat_entered.Text) : 0; DataEntryTracker.t_linkage_total_entered = txt_linkages_entered.Text != string.Empty ? Convert.ToInt32(txt_linkages_entered.Text) : 0; DataEntryTracker.t_refferal_total_entered = txt_referal_entered.Text != string.Empty ? Convert.ToInt32(txt_referal_entered.Text) : 0; DataEntryTracker.t_edu_subsidy_total_entered = txt_edu_subsidy_entered.Text != string.Empty ? Convert.ToInt32(txt_edu_subsidy_entered.Text) : 0; DataEntryTracker.t_cTraining_SILC_total_entered = txt_comm_SILC_entered.Text != string.Empty ? Convert.ToInt32(txt_comm_SILC_entered.Text) : 0; DataEntryTracker.t_cTraining_youth_total_entered = txt_comm_youth_entered.Text != string.Empty ? Convert.ToInt32(txt_comm_youth_entered.Text) : 0; DataEntryTracker.t_youth_savings_total_entered = txt_youth_saving_entered.Text != string.Empty ? Convert.ToInt32(txt_youth_saving_entered.Text) : 0; DataEntryTracker.t_appre_progress_total_entered = txt_app_progress_entered.Text != string.Empty ? Convert.ToInt32(txt_app_progress_entered.Text) : 0; DataEntryTracker.t_training_inventory_total_entered = txt_training_inventory_entered.Text != string.Empty ? Convert.ToInt32(txt_training_inventory_entered.Text) : 0; DataEntryTracker.t_appre_skill_aqui_total_entered = txt_skill_aquisition_entered.Text != string.Empty ? Convert.ToInt32(txt_skill_aquisition_entered.Text) : 0; DataEntryTracker.t_training_comple_total_entered = txt_training_completion.Text != string.Empty ? Convert.ToInt32(txt_training_completion.Text) : 0; DataEntryTracker.t_youth_ass_toolkit_total_entered = txt_ass_awarding_tool_kit_entered.Text != string.Empty ? Convert.ToInt32(txt_ass_awarding_tool_kit_entered.Text) : 0; DataEntryTracker.t_youth_tracer_total_entered = txt_youth_tracer_entered.Text != string.Empty ? Convert.ToInt32(txt_youth_tracer_entered.Text) : 0; DataEntryTracker.t_dovcc_total_entered = txt_dovcc_entered.Text != string.Empty ? Convert.ToInt32(txt_dovcc_entered.Text) : 0; DataEntryTracker.t_sovcc_total_entered = txt_sovcc_entered.Text != string.Empty ? Convert.ToInt32(txt_sovcc_entered.Text) : 0; DataEntryTracker.t_cbsd_resource_alloc_total_entered = txt_cbsd_resource_entered.Text != string.Empty ? Convert.ToInt32(txt_cbsd_resource_entered.Text) : 0; DataEntryTracker.t_cbsd_staff_appra_total_entered = txt_staff_appraisal_entered.Text != string.Empty ? Convert.ToInt32(txt_staff_appraisal_entered.Text) : 0; DataEntryTracker.t_dreams_registration_total_entered = txt_dreams_registration_entered.Text != string.Empty ? Convert.ToInt32(txt_dreams_registration_entered.Text) : 0; DataEntryTracker.t_hct_total_entered = txt_hct_registration_entered.Text != string.Empty ? Convert.ToInt32(txt_hct_registration_entered.Text) : 0; DataEntryTracker.t_dreams_partner_total_entered = txt_dreams_partner_entered.Text != string.Empty ? Convert.ToInt32(txt_dreams_partner_entered.Text) : 0; DataEntryTracker.t_sunovuyo_total_entered = txt_sinovuyo_entered.Text != string.Empty ? Convert.ToInt32(txt_sinovuyo_entered.Text) : 0; DataEntryTracker.t_dreams_stepping_stones_total_entered = txt_stepping_stones_entered.Text != string.Empty ? Convert.ToInt32(txt_stepping_stones_entered.Text) : 0; DataEntryTracker.t_dreams_screening_total_entered = txt_dreams_screening_entered.Text != string.Empty ? Convert.ToInt32(txt_dreams_screening_entered.Text) : 0; DataEntryTracker.t_dreams_sasa_total_entered = txt_sasa_session_entered.Text != string.Empty ? Convert.ToInt32(txt_sasa_session_entered.Text) : 0; DataEntryTracker.t_viral_load_total_entered = txt_viral_load_entered.Text != string.Empty ? Convert.ToInt32(txt_viral_load_entered.Text) : 0; #endregion total_entered #region percent_entered DataEntryTracker.t_ipt_percent_entered = DataEntryTracker.t_ipt_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_ipt_total_entered / (decimal)DataEntryTracker.t_ipt_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_hat_percent_entered = DataEntryTracker.t_hat_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_hat_total_entered / DataEntryTracker.t_hat_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_hip_percent_entered = DataEntryTracker.t_hip_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_hip_total_entered / DataEntryTracker.t_hip_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_hv_percent_entered = DataEntryTracker.t_hv_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_hv_total_entered / DataEntryTracker.t_hv_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_rat_percent_entered = DataEntryTracker.t_rat_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_rat_total_entered / DataEntryTracker.t_rat_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_linkage_percent_entered = DataEntryTracker.t_linkage_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_linkage_total_entered / DataEntryTracker.t_linkage_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_refferal_percent_entered = DataEntryTracker.t_refferal_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_refferal_total_entered / DataEntryTracker.t_refferal_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_edu_subsidy_percent_entered = DataEntryTracker.t_edu_subsidy_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_edu_subsidy_total_entered / DataEntryTracker.t_edu_subsidy_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_cTraining_SILC_percent_entered = DataEntryTracker.t_cTraining_SILC_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_cTraining_SILC_total_entered / DataEntryTracker.t_cTraining_SILC_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_cTraining_youth_percent_entered = DataEntryTracker.t_cTraining_youth_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_cTraining_youth_total_entered / DataEntryTracker.t_cTraining_youth_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_youth_savings_percent_entered = DataEntryTracker.t_youth_savings_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_youth_savings_total_entered / DataEntryTracker.t_youth_savings_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_appre_progress_percent_entered = DataEntryTracker.t_appre_progress_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_appre_progress_total_entered / DataEntryTracker.t_appre_progress_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_training_inventory_percent_entered = DataEntryTracker.t_training_inventory_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_training_inventory_total_entered / DataEntryTracker.t_training_inventory_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_appre_skill_aqui_percent_entered = DataEntryTracker.t_appre_skill_aqui_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_appre_skill_aqui_total_entered / DataEntryTracker.t_appre_skill_aqui_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_training_comple_percent_entered = DataEntryTracker.t_training_comple_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_training_comple_total_entered / DataEntryTracker.t_training_comple_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_youth_ass_toolkit_percent_entered = DataEntryTracker.t_youth_ass_toolkit_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_youth_ass_toolkit_total_entered / DataEntryTracker.t_youth_ass_toolkit_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_youth_tracer_percent_entered = DataEntryTracker.t_youth_tracer_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_youth_tracer_total_entered / DataEntryTracker.t_youth_tracer_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_dovcc_percent_entered = DataEntryTracker.t_dovcc_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_dovcc_total_entered / DataEntryTracker.t_dovcc_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_sovcc_percent_entered = DataEntryTracker.t_sovcc_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_sovcc_total_entered / DataEntryTracker.t_sovcc_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_cbsd_resource_alloc_percent_entered = DataEntryTracker.t_cbsd_resource_alloc_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_cbsd_resource_alloc_total_entered / DataEntryTracker.t_cbsd_resource_alloc_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_cbsd_staff_appra_percent_entered = DataEntryTracker.t_cbsd_staff_appra_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_cbsd_staff_appra_total_entered / DataEntryTracker.t_cbsd_staff_appra_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_reintergration_percent_entered = DataEntryTracker.t_reintergration_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_reintergration_total_entered / DataEntryTracker.t_reintergration_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_dreams_registration_percent_entered = DataEntryTracker.t_dreams_registration_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_dreams_registration_total_entered / DataEntryTracker.t_dreams_registration_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_hct_percent_entered = DataEntryTracker.t_hct_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_hct_total_entered / DataEntryTracker.t_hct_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_dreams_partner_percent_entered = DataEntryTracker.t_dreams_partner_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_dreams_partner_total_entered / DataEntryTracker.t_dreams_partner_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_sunovuyo_percent_entered = DataEntryTracker.t_sunovuyo_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_sunovuyo_total_entered / DataEntryTracker.t_sunovuyo_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_dreams_stepping_stones_percent_entered = DataEntryTracker.t_dreams_stepping_stones_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_dreams_stepping_stones_total_entered / DataEntryTracker.t_dreams_stepping_stones_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_dreams_screening_percent_entered = DataEntryTracker.t_dreams_screening_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_dreams_screening_total_entered / DataEntryTracker.t_dreams_screening_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_dreams_sasa_percent_entered = DataEntryTracker.t_dreams_sasa_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_dreams_sasa_total_entered / DataEntryTracker.t_dreams_sasa_total_received) * 100), 2).ToString() : string.Empty; DataEntryTracker.t_viral_load_percent_entered = DataEntryTracker.t_viral_load_total_received != 0 ? Math.Round((((decimal)DataEntryTracker.t_viral_load_total_entered / DataEntryTracker.t_viral_load_total_received) * 100), 2).ToString() : string.Empty; #endregion percent_entered #endregion set variables if (Request.QueryString["Token_id"] == null) { int count = DataEntryTracker.Check_if_tracker_exists(cbo_district.SelectedValue.ToString(), Convert.ToDateTime(txt_date.Text)); if (count > 0) { string script = "alert(\"Tracker for this date already uploaded!\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } else { DataEntryTracker.save_data_entry_tracker(tracker_id); } } else { string tracker_inserted_id = DataEntryTracker.save_data_entry_tracker(tracker_id); } }
protected void ReturnTrackerDetails(string tracker_id) { DataTable dt = DataEntryTracker.LoadTrackerDetails(tracker_id); if (dt.Rows.Count > 0) { DataRow dtRow = dt.Rows[0]; cbo_district.SelectedValue = dtRow["dst_id"].ToString(); txt_date.Text = Convert.ToDateTime(dtRow["tracker_date"]).ToString(); txt_ipt.Text = Convert.ToInt32(dtRow["t_ipt_total_received"].ToString()).ToString(); txt_ipt_entered.Text = Convert.ToInt32(dtRow["t_ipt_total_entered"].ToString()).ToString(); txt_hat.Text = Convert.ToInt32(dtRow["t_hat_total_received"].ToString()).ToString(); txt_hat_entered.Text = Convert.ToInt32(dtRow["t_hat_total_entered"].ToString()).ToString(); txt_hip.Text = Convert.ToInt32(dtRow["t_hip_total_received"].ToString()).ToString(); txt_hip_entered.Text = Convert.ToInt32(dtRow["t_hip_total_entered"].ToString()).ToString(); txt_home_visit.Text = Convert.ToInt32(dtRow["t_hv_total_received"].ToString()).ToString(); txt_home_visit_entered.Text = Convert.ToInt32(dtRow["t_hv_total_entered"].ToString()).ToString(); txt_rat.Text = Convert.ToInt32(dtRow["t_rat_total_received"].ToString()).ToString(); txt_rat_entered.Text = Convert.ToInt32(dtRow["t_rat_total_entered"].ToString()).ToString(); txt_linkages.Text = Convert.ToInt32(dtRow["t_linkage_total_received"].ToString()).ToString(); txt_linkages_entered.Text = Convert.ToInt32(dtRow["t_linkage_total_entered"].ToString()).ToString(); txt_referal.Text = Convert.ToInt32(dtRow["t_refferal_total_received"].ToString()).ToString(); txt_referal_entered.Text = Convert.ToInt32(dtRow["t_refferal_total_entered"].ToString()).ToString(); txt_edu_subsidy.Text = Convert.ToInt32(dtRow["t_edu_subsidy_total_received"].ToString()).ToString(); txt_edu_subsidy_entered.Text = Convert.ToInt32(dtRow["t_edu_subsidy_total_entered"].ToString()).ToString(); txt_comm_SILC.Text = Convert.ToInt32(dtRow["t_cTraining_SILC_total_received"].ToString()).ToString(); txt_comm_SILC_entered.Text = Convert.ToInt32(dtRow["t_cTraining_SILC_total_entered"].ToString()).ToString(); txt_comm_youth.Text = Convert.ToInt32(dtRow["t_cTraining_youth_total_received"].ToString()).ToString(); txt_comm_youth_entered.Text = Convert.ToInt32(dtRow["t_cTraining_youth_total_entered"].ToString()).ToString(); txt_youth_saving.Text = Convert.ToInt32(dtRow["t_youth_savings_total_received"].ToString()).ToString(); txt_youth_saving_entered.Text = Convert.ToInt32(dtRow["t_youth_savings_total_entered"].ToString()).ToString(); txt_app_progress.Text = Convert.ToInt32(dtRow["t_appre_progress_total_received"].ToString()).ToString(); txt_app_progress_entered.Text = Convert.ToInt32(dtRow["t_appre_progress_total_entered"].ToString()).ToString(); txt_training_inventory.Text = Convert.ToInt32(dtRow["t_training_inventory_total_received"].ToString()).ToString(); txt_training_inventory_entered.Text = Convert.ToInt32(dtRow["t_training_inventory_total_entered"].ToString()).ToString(); txt_skill_aquisition.Text = Convert.ToInt32(dtRow["t_appre_skill_aqui_total_received"].ToString()).ToString(); txt_skill_aquisition_entered.Text = Convert.ToInt32(dtRow["t_appre_skill_aqui_total_entered"].ToString()).ToString(); txt_training_completion.Text = Convert.ToInt32(dtRow["t_training_comple_total_received"].ToString()).ToString(); txt_training_completion_entered.Text = Convert.ToInt32(dtRow["t_training_comple_total_entered"].ToString()).ToString(); txt_ass_awarding_tool_kit.Text = Convert.ToInt32(dtRow["t_youth_ass_toolkit_total_received"].ToString()).ToString(); txt_ass_awarding_tool_kit_entered.Text = Convert.ToInt32(dtRow["t_youth_ass_toolkit_total_entered"].ToString()).ToString(); txt_youth_tracer.Text = Convert.ToInt32(dtRow["t_youth_tracer_total_received"].ToString()).ToString(); txt_youth_tracer_entered.Text = Convert.ToInt32(dtRow["t_youth_tracer_total_entered"].ToString()).ToString(); txt_dovcc.Text = Convert.ToInt32(dtRow["t_dovcc_total_received"].ToString()).ToString(); txt_dovcc_entered.Text = Convert.ToInt32(dtRow["t_dovcc_total_entered"].ToString()).ToString(); txt_sovcc.Text = Convert.ToInt32(dtRow["t_sovcc_total_received"].ToString()).ToString(); txt_sovcc_entered.Text = Convert.ToInt32(dtRow["t_sovcc_total_entered"].ToString()).ToString(); txt_cbsd_resource.Text = Convert.ToInt32(dtRow["t_cbsd_resource_alloc_total_received"].ToString()).ToString(); txt_cbsd_resource_entered.Text = Convert.ToInt32(dtRow["t_cbsd_resource_alloc_total_entered"].ToString()).ToString(); txt_staff_appraisal.Text = Convert.ToInt32(dtRow["t_cbsd_staff_appra_total_received"].ToString()).ToString(); txt_staff_appraisal_entered.Text = Convert.ToInt32(dtRow["t_cbsd_staff_appra_total_entered"].ToString()).ToString(); txt_reintergration.Text = Convert.ToInt32(dtRow["t_reintergration_total_received"].ToString()).ToString(); txt_reintergration_entered.Text = Convert.ToInt32(dtRow["t_reintergration_total_entered"].ToString()).ToString(); txt_dreams_registration.Text = Convert.ToInt32(dtRow["t_dreams_registration_total_received"].ToString()).ToString(); txt_dreams_registration_entered.Text = Convert.ToInt32(dtRow["t_dreams_registration_total_entered"].ToString()).ToString(); txt_hct_registration.Text = Convert.ToInt32(dtRow["t_hct_total_received"].ToString()).ToString(); txt_hct_registration_entered.Text = Convert.ToInt32(dtRow["t_hct_total_entered"].ToString()).ToString(); txt_dreams_partner.Text = Convert.ToInt32(dtRow["t_dreams_partner_total_received"].ToString()).ToString(); txt_dreams_partner_entered.Text = Convert.ToInt32(dtRow["t_dreams_partner_total_entered"].ToString()).ToString(); txt_sinovuyo.Text = Convert.ToInt32(dtRow["t_sunovuyo_total_received"].ToString()).ToString(); txt_sinovuyo_entered.Text = Convert.ToInt32(dtRow["t_sunovuyo_total_entered"].ToString()).ToString(); txt_stepping_stones.Text = Convert.ToInt32(dtRow["t_dreams_stepping_stones_total_received"].ToString()).ToString(); txt_stepping_stones_entered.Text = Convert.ToInt32(dtRow["t_dreams_stepping_stones_total_entered"].ToString()).ToString(); txt_dreams_screening.Text = Convert.ToInt32(dtRow["t_dreams_screening_total_received"].ToString()).ToString(); txt_dreams_screening_entered.Text = Convert.ToInt32(dtRow["t_dreams_screening_total_entered"].ToString()).ToString(); txt_sasa_session.Text = Convert.ToInt32(dtRow["t_dreams_sasa_total_received"].ToString()).ToString(); txt_sasa_session_entered.Text = Convert.ToInt32(dtRow["t_dreams_sasa_total_entered"].ToString()).ToString(); txt_viral_load.Text = Convert.ToInt32(dtRow["t_viral_load_total_received"].ToString()).ToString(); txt_viral_load_entered.Text = Convert.ToInt32(dtRow["t_viral_load_total_entered"].ToString()).ToString(); } }