protected void LoadReport(int prjlId, ReportDocument repDoc)
{
objBarsikService = new BarsikKaryekramService();
ProjectOutputTBarsikBO objProjectOutBarsik = new ProjectOutputTBarsikBO();
objProjectOutBarsik.Lang = SessionHelper.SessionLanguageSetting;
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
objProjectOutBarsik.ProjectId = prjlId;
objProjectOutBarsik.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
objProjectOutBarsik.ChaumasikId = ddlChaumasik.SelectedValue.ToInt32();
//Session["dtProjectPratifal"] = objBarsikService.PopulateProjectProgress(objProjectOutBarsik);
DataTable dtProjectPratifal = (DataTable)Session["dtProjectPratifal"];
Session["dtPopulateProjectPratifalReport"] = dtProjectPratifal;
objRptFactory = new ReportFactory();
objRptFactory.SetReport(repDoc);
objRptServices = new ReportServices();
objRptServices.GetReport(repDoc, RptViewer);
/*repDoc.Database.Tables[0].SetDataSource(dtProjectNatija);*/
repDoc.Database.Tables[0].SetDataSource(dtProjectPratifal);
if (dtProjectPratifal != null && dtProjectPratifal.Rows.Count > 0)
{
RptViewer.ReportSource = repDoc;
Session["PratifalReport"] = repDoc;
}
else
{
RptViewer.ReportSource = null;
Session["PratifalReport"] = null;
}
}
public DataTable PopulateProjectProgressRpt(ProjectOutputTBarsikBO obj)
{
DbCommand cmd = db.GetStoredProcCommand("PR_POPULATE_PROGRESS_RPT", obj.ProjectId, obj.FiscalYearId, obj.ChaumasikId, OracleDbType.RefCursor);
DataSet ds = null;
DataTable dt = null;
ds = db.ExecuteDataSet(cmd);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
public DataTable PopulateProjectTargetsBarsikRpt(ProjectOutputTBarsikBO objOutputTarget)
{
DbCommand cmd = db.GetStoredProcCommand("PR_POPULATE_TARGET_BARSIK_RPT",
objOutputTarget.Lang, objOutputTarget.ProjectId, objOutputTarget.FiscalYearId, objOutputTarget.ChaumasikId, OracleDbType.RefCursor);
DataSet ds = null;
DataTable dt = null;
ds = db.ExecuteDataSet(cmd);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
protected void GrdTarget_RowCommand(object sender, GridViewCommandEventArgs e)
{
int i = 0;
ProjectOutputTBarsikBO objProjectOutBarsik = new ProjectOutputTBarsikBO();
if (e.CommandName == "edit")
{
GridViewRow gvr = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
int RowIndex = gvr.RowIndex;
objProjectOutBarsik.PTargetId =
((HiddenField)grdTarget.Rows[RowIndex].FindControl("hidPTargetId")).Value.ToDecimal();
objProjectOutBarsik.PTargetBId = e.CommandArgument.ToString().ToDecimal();
objProjectOutBarsik.PTargetFirstP = ((TextBox)grdTarget.Rows[RowIndex].FindControl("txtFirstYearTarget")).Text;
objProjectOutBarsik.PTargetSecondP = ((TextBox)grdTarget.Rows[RowIndex].FindControl("txtSecondYearTarget")).Text;
objProjectOutBarsik.PTargetThirdP = ((TextBox)grdTarget.Rows[RowIndex].FindControl("txtThirdYearTarget")).Text;
objProjectOutBarsik.ProjectId = Session["projectId"].ToInt32();
objProjectOutBarsik.FiscalYearId = SessionHelper.SessionFiscalYear.ToDecimal();
if (objProjectOutBarsik.PTargetBId != 0)
{
if (ddlChaumarsik.SelectedValue == "1")
{
objProjectOutBarsik.Mode = "UF";
}
else if (ddlChaumarsik.SelectedValue == "2")
{
objProjectOutBarsik.Mode = "US";
}
else
{
objProjectOutBarsik.Mode = "UT";
}
}
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
i = objBarsikService.InsertUpdateProjectOutputTBarsik(objProjectOutBarsik);
if (i > 0)
{
Response.Write("<script>alert('Target successfully recorded.') </script>");
Response.Redirect(Constants.ConstantAppPath + "/Modules/BarsikKaryekram/ListProjectNatijaPragati.aspx");
}
else
{
Response.Write("<script>alert('Target not recorded.') </script>");
}
}
}
protected void GrdTarget_RowCommand(object sender, GridViewCommandEventArgs e)
{
int i = 0;
ProjectOutputTBarsikBO objProjectOutBarsik = new ProjectOutputTBarsikBO();
if (e.CommandName == "edit")
{
GridViewRow gvr = (GridViewRow)(((Button)e.CommandSource).NamingContainer);//
int RowIndex = gvr.RowIndex;
/*objProjectOutBarsik.PTargetId =
* ((HiddenField)grdTarget.Rows[RowIndex].FindControl("hidProjectOutputId")).Value.ToDecimal();*/
objProjectOutBarsik.ProjectOutputId = e.CommandArgument.ToString().ToInt32();
objProjectOutBarsik.PTargetFirstP = ((TextBox)grdTarget.Rows[RowIndex].FindControl("txtFirstQuarterProgress")).Text;
objProjectOutBarsik.PTargetSecondP = ((TextBox)grdTarget.Rows[RowIndex].FindControl("txtSecondQuarterProgress")).Text;
objProjectOutBarsik.PTargetThirdP = ((TextBox)grdTarget.Rows[RowIndex].FindControl("txtThirdQuarterProgress")).Text;
objProjectOutBarsik.ProjectId = Session["projectId"].ToInt32();
objProjectOutBarsik.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
objProjectOutBarsik.ModifiedBy = Session["username"].ToString();
objProjectOutBarsik.ModifiedDate = DateTime.Now;
if (ddlChaumasik.SelectedValue == "1")
{
objProjectOutBarsik.Mode = "UF";
}
else if (ddlChaumasik.SelectedValue == "2")
{
objProjectOutBarsik.Mode = "US";
}
else
{
objProjectOutBarsik.Mode = "UT";
}
objBarsikService = new BarsikKaryekramService();
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
i = objBarsikService.InsertUpdateProjectOutputProgress(objProjectOutBarsik);
if (i > 0)
{
Response.Write("<script>alert('Target successfully recorded.') </script>");
Response.Redirect(Constants.ConstantAppPath + "/Modules/OutputTargetManagement/AddProjectOutputProgress.aspx");
//PopulateProgress();
}
else
{
Response.Write("<script>alert('Target not recorded.') </script>");
}
}
}
public int InsertUpdateProjectOutputProgress(ProjectOutputTBarsikBO objProjectOutputTBarsik)
{
int i = 0;
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_PROJECT_OUTPUT_PROGRESS");
db.AddInParameter(cmd, "V_MODE", DbType.String, objProjectOutputTBarsik.Mode);
db.AddInParameter(cmd, "V_PROJECT_OUTPUT_ID", DbType.Int32, objProjectOutputTBarsik.ProjectOutputId);
db.AddInParameter(cmd, "V_P_TARGET_FIRST_P", DbType.String, objProjectOutputTBarsik.PTargetFirstP);
db.AddInParameter(cmd, "V_P_TARGET_SECOND_P", DbType.String, objProjectOutputTBarsik.PTargetSecondP);
db.AddInParameter(cmd, "V_P_TARGET_THIRD_P", DbType.String, objProjectOutputTBarsik.PTargetThirdP);
db.AddInParameter(cmd, "V_PROJECT_ID", DbType.Decimal, objProjectOutputTBarsik.ProjectId);
db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objProjectOutputTBarsik.FiscalYearId);
db.AddInParameter(cmd, "V_OP_MODIFIED_BY", DbType.String, objProjectOutputTBarsik.ModifiedBy);
db.AddInParameter(cmd, "V_OP_MODIFIED_DATE", DbType.DateTime, objProjectOutputTBarsik.ModifiedDate);
return(db.ExecuteNonQuery(cmd));
}
private void PopulateAllProgress()
{
objBarsikService = new BarsikKaryekramService();
ProjectOutputTBarsikBO objProjectOutBarsik = new ProjectOutputTBarsikBO();
objProjectOutBarsik.Lang = SessionHelper.SessionLanguageSetting;
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
objProjectOutBarsik.ProjectId = Session["projectId"].ToInt32();
objProjectOutBarsik.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
//objProjectOutBarsik.ChaumasikId = SessionHelper.SessionFiscalYear.ToInt32();
Session["dtProgress"] = objBarsikService.PopulateProjectProgress(objProjectOutBarsik);
DataTable dtProgress = (DataTable)Session["dtProgress"];
if (dtProgress != null && dtProgress.Rows.Count > 0)
{
grdTarget.DataSource = dtProgress;
grdTarget.DataBind();
lblModification.Text = dtProgress.Rows[0]["OP_MODIFIED_DATE"].ToDateTime().ToString("D");
lblModifiedBy.Text = dtProgress.Rows[0]["OP_MODIFIED_BY"].ToString();
}
}
private void PopulateAllTargets()
{
objBarsikService = new BarsikKaryekramService();
ProjectOutputTBarsikBO objProjectOutBarsik = new ProjectOutputTBarsikBO();
objProjectOutBarsik.Lang = SessionHelper.SessionLanguageSetting;
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
objProjectOutBarsik.ProjectId = Session["projectId"].ToInt32();
objProjectOutBarsik.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
Session["dtTarget"] = objBarsikService.PopulateProjectTargetsBarsik(objProjectOutBarsik);
DataTable dtTarget = (DataTable)Session["dtTarget"];
if (dtTarget != null && dtTarget.Rows.Count > 0)
{
grdTarget.DataSource = dtTarget;
grdTarget.DataBind();
Session["TargetData"] = dtTarget;
}
else
{
}
}
public int InsertUpdateProjectOutputTBarsik(ProjectOutputTBarsikBO objProjectOutputTBarsik)
{
int i = 0;
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_PROJECT_BARSIK_KARYEKRAM.PR_PROJECT_OUTPUT_T_BARSIK");
db.AddInParameter(cmd, "V_MODE", DbType.String, objProjectOutputTBarsik.Mode);
db.AddInParameter(cmd, "V_P_TARGET_B_ID", DbType.Decimal, objProjectOutputTBarsik.PTargetBId);
db.AddInParameter(cmd, "V_P_TARGET_FIRST_C", DbType.String, objProjectOutputTBarsik.PTargetFirstC);
db.AddInParameter(cmd, "V_P_TARGET_SECOND_C", DbType.String, objProjectOutputTBarsik.PTargetSecondC);
db.AddInParameter(cmd, "V_P_TARGET_THIRD_C", DbType.String, objProjectOutputTBarsik.PTargetThirdC);
db.AddInParameter(cmd, "V_P_TARGET_FIRST_P", DbType.String, objProjectOutputTBarsik.PTargetFirstP);
db.AddInParameter(cmd, "V_P_TARGET_SECOND_P", DbType.String, objProjectOutputTBarsik.PTargetSecondP);
db.AddInParameter(cmd, "V_P_TARGET_THIRD_P", DbType.String, objProjectOutputTBarsik.PTargetThirdP);
db.AddInParameter(cmd, "V_P_TARGET_ID", DbType.Decimal, objProjectOutputTBarsik.PTargetId);
db.AddInParameter(cmd, "V_ENTRY_DATE", DbType.String, objProjectOutputTBarsik.EntryDate);
db.AddInParameter(cmd, "V_ISENABLE", DbType.Decimal, objProjectOutputTBarsik.Isenable);
db.AddInParameter(cmd, "V_ISLOCKED", DbType.Decimal, objProjectOutputTBarsik.Islocked);
db.AddInParameter(cmd, "V_PROJECT_ID", DbType.Decimal, objProjectOutputTBarsik.ProjectId);
db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objProjectOutputTBarsik.FiscalYearId);
return(db.ExecuteNonQuery(cmd));
}
protected void LoadReport(int prjlId, ReportDocument repDoc)
{
//repDoc = new ReportDocument();
objBarsikService = new BarsikKaryekramService();
ProjectOutputTBarsikBO objProjectOutBarsik = new ProjectOutputTBarsikBO();
objProjectOutBarsik.Lang = SessionHelper.SessionLanguageSetting;
objBarsikService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationBarsikKaryekram();
objProjectOutBarsik.ProjectId = prjlId;
objProjectOutBarsik.FiscalYearId = SessionHelper.SessionFiscalYear.ToInt32();
objProjectOutBarsik.ChaumasikId = ddlChaumasik.SelectedValue.ToInt32();
/*Session["dtProjectNatija"] = objBarsikService.PopulateProjectTargetsBarsikRpt(objProjectOutBarsik);
* DataTable dtProjectNatija = (DataTable) Session["dtProjectNatija"];
*
* Session["dtPopulateProjectNatijaReport"] = dtProjectNatija;*/
Session["dtProjectPratifal"] = objBarsikService.PopulateProjectProgress(objProjectOutBarsik);
DataTable dtProjectPratifal = (DataTable)Session["dtProjectPratifal"];
Session["dtPopulateProjectPratifalReport"] = dtProjectPratifal;
objRptFactory = new ReportFactory();
objRptFactory.SetReport(repDoc);
objRptServices = new ReportServices();
objRptServices.GetReport(repDoc, RptViewer);
/*repDoc.Database.Tables[0].SetDataSource(dtProjectNatija);*/
repDoc.Database.Tables[0].SetDataSource(dtProjectPratifal);
//cryParameter(repDoc);
// RptViewer.ReportSource = repDoc;
//chartViewer.ReportSource = objPrjBhautikPragatiGrpRpt;
/*if (dtProjectNatija != null && dtProjectNatija.Rows.Count > 0)
* {
* RptViewer.ReportSource = repDoc;
* Session["NatijaReport"] = repDoc;
* }
* else
* {
* RptViewer.ReportSource = null;
* Session["NatijaReport"] = null;
* }*/
if (dtProjectPratifal != null && dtProjectPratifal.Rows.Count > 0)
{
RptViewer.ReportSource = repDoc;
Session["PratifalReport"] = repDoc;
}
else
{
RptViewer.ReportSource = null;
Session["PratifalReport"] = null;
}
// crystalViewer.Zoom(75);
//chartViewer.Zoom(93);
}
public DataTable PopulateProjectTargetsBarsikRpt(ProjectOutputTBarsikBO objOutputTarget)
{
Authentication();
return(objBarsikDal.PopulateProjectTargetsBarsikRpt(objOutputTarget));
}
public int InsertUpdateProjectOutputProgress(ProjectOutputTBarsikBO objOutputTarget)
{
Authentication();
return(objBarsikDal.InsertUpdateProjectOutputProgress(objOutputTarget));
}
public DataTable PopulateProjectProgressRpt(ProjectOutputTBarsikBO obj)
{
Authentication();
return(objBarsikDal.PopulateProjectProgressRpt(obj));
}
