public clsEntReports getCurrentQtrYear(int Year = -1)
{
SqlDataAccess objDataAccess = new SqlDataAccess(clsConstant.DBCONSTRING);
SqlDataReader reader = null;
clsEntReports objEnt = new clsEntReports();
try
{
if (objDataAccess.Connection.State == ConnectionState.Closed)
{
objDataAccess.Connection.Open();
}
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@year", Year) };
reader = objDataAccess.ExecuteReaderQuery(clsConstant.SP_SELECT_CURRENT_QTR_YR_B, CommandType.StoredProcedure, param);
while (reader.Read())
{
objEnt.Year = reader.GetValue(0).ToString().TrimEnd();
objEnt.Month = reader.GetValue(1).ToString().TrimEnd();
}
return(objEnt);
}
catch (Exception ex)
{
throw ex;
}
}
public void getValueofCurrentSchedularStatus(DropDownList frmQtr, DropDownList fromYr)
{
clsEntReports objEnt = (new ProjectPerGroupBSummary()).getCurrentQtrYear();
string month = objEnt.Month;
frmQtr.Items.FindByValue(month).Selected = true;
fromYr.Items.FindByText(objEnt.Year).Selected = true;
new ProjectPerformanceGroupBDetails().getValues(frmQtr, drpFromYear, frmQtr, drpLstYear, drplstQuarter);
}
public void getValueofCurrentSchedularStatus(DropDownList frmMonth, DropDownList fromYr)
{
clsEntReports objEnt = (new ProjectPerGroupA()).getCurrentQtrYear();
string month = objEnt.Month == "Mar" ? "1" : objEnt.Month == "Jun" ? "2" : objEnt.Month == "Sep" ? "3" : objEnt.Month == "Dec" ? "4" : "";
frmMonth.Items.FindByValue(month).Selected = true;
fromYr.Items.FindByText(objEnt.Year).Selected = true;
this.getValues(frmMonth, drpFromYear, frmMonth, drpLstYear, drplstMonth);
}
protected void drpYear_SelectedIndexChanged1(object sender, EventArgs e)
{
int Year = int.Parse(drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "-1");
clsEntReports objEnt = (new ProjectPerGroupBSummary()).getCurrentQtrYear(Year);
//if (objEnt.Month != null)
//{
// if (drpQuarter.Items.Contains(drpQuarter.Items.FindByValue(objEnt.Month.ToString())))
// {
// drpQuarter.Items.RemoveAt(int.Parse(objEnt.Month));
// }
// else
// {
// this.bindQuarterForGrpB();
// }
//}
}
protected void drpYearA_SelectedIndexChanged(object sender, EventArgs e)
{
int Year = int.Parse(drpYearA.SelectedIndex != 0? drpYearA.SelectedItem.Text :"-1");
clsEntReports objEnt = (new ProjectPerGroupA()).getCurrentQtrYear(Year);
string month = objEnt.Month == "Mar" ? "1" : objEnt.Month == "Jun" ? "2" : objEnt.Month == "Sep" ? "3" : objEnt.Month == "Dec" ? "4" : "";
if (month != "")
{
if (ddlMonthGroupA.Items.Contains(ddlMonthGroupA.Items.FindByValue(month)))
{
ddlMonthGroupA.Items.RemoveAt(int.Parse(month));
}
else
{
this.bindQuarterForGrpA();
}
}
}
public void getValueofCurrentSchedularStatus(DropDownList frmQtr, DropDownList fromYr)
{
#region Show the last report run on
clsEntReports objEnt = (new ProjectPerGroupBSummary()).getCurrentQtrYear();
string month = objEnt.Month;
frmQtr.Items.FindByValue(month).Selected = true;
fromYr.Items.FindByText(objEnt.Year).Selected = true;
#region Select the Last Month
drplstQuarter.Items.FindByValue(month).Selected = true;
drpLstYear.Items.FindByText(objEnt.Year).Selected = true;
#endregion
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session[clsConstant.TOKEN] == null)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("ProjectPerformanceDetailsGroupC") == false)
{
//UrlParameterPasser urlWrapper = new UrlParameterPasser();
//urlWrapper["pageaccesserr"] = "1";
////urlWrapper.Url = "../Logout.aspx";
//urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
//urlWrapper.PassParameters();
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
dt = new DataTable();
comnFunctionObj = new CommonFunction();
drpLoanNumber.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_LOAN, null);
drpLoanNumber.DataTextField = "DisplayFieldText";
drpLoanNumber.DataValueField = "ValueFieldText";
drpLoanNumber.DataBind();
drpLoanNumber.Items.RemoveAt(0);
drpLoanNumber.Items.Insert(0, new ListItem("----------ENTER NAME/NO----------", "0"));
drpSector.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_DOC_CATEGORY, null);
drpSector.DataTextField = "DisplayFieldText";
drpSector.DataValueField = "ValueFieldText";
drpSector.DataBind();
drpFromQuarter.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_QUARTER, null);
drpFromQuarter.DataTextField = "DisplayFieldText";
drpFromQuarter.DataValueField = "ValueFieldText";
drpFromQuarter.DataBind();
drpFromYear.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_YEAR_FOR_REPORTSCEDULER, null);
drpFromYear.DataTextField = "DisplayFieldText";
drpFromYear.DataValueField = "ValueFieldText";
drpFromYear.DataBind();
//print
//this.btnPrint.Attributes.Add("onclick", "tablePrint('ctl00_ContentPlaceHolder1_tbl_Print','Group C Detailed Report');");
clsEntReports objEnt = (new ProjectPerGroupBSummary()).getCurrentQtrYear();
string month = objEnt.Month;
drpFromQuarter.Items.FindByValue(month).Selected = true;
drpFromYear.Items.FindByText(objEnt.Year).Selected = true;
this.GridviewBind();
info.AddMergedColumns(new int[] { 3, 4, 5, 6, 7 }, "Date");
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//this.newReason.Attributes.Add("onkeydown", "javascript:return textAreaCharacterCounter1(this,500);");
// this.newReason.Attributes.Add("onkeyup", "javascript:return textAreaCharacterCounter1(this,500);");
try
{
if (!IsPostBack)
{
if (Session[clsConstant.TOKEN] == null)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("OverrideGroupReportB") == false)
{
//UrlParameterPasser urlWrapper = new UrlParameterPasser();
//urlWrapper["pageaccesserr"] = "1";
//// urlWrapper.Url = "../Logout.aspx";
//urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
//urlWrapper.PassParameters();
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
dt = new DataTable();
comnFunctionObj = new CommonFunction();
drpLoanNumber.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_LOAN, null);
drpLoanNumber.DataTextField = "DisplayFieldText";
drpLoanNumber.DataValueField = "ValueFieldText";
drpLoanNumber.DataBind();
drpLoanNumber.Items.RemoveAt(0);
drpLoanNumber.Items.Insert(0, new ListItem("----------ENTER NAME/NO----------", "0"));
drpSector.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_DOC_CATEGORY, null);
drpSector.DataTextField = "DisplayFieldText";
drpSector.DataValueField = "ValueFieldText";
drpSector.DataBind();
drpAgency.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_AGENCY, null);
drpAgency.DataTextField = "DisplayFieldText";
drpAgency.DataValueField = "ValueFieldText";
drpAgency.DataBind();
drpState.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_STATE, null);
drpState.DataTextField = "DisplayFieldText";
drpState.DataValueField = "ValueFieldText";
drpState.DataBind();
drpFromYear.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_YEAR_FOR_REPORTSCEDULER, null);
drpFromYear.DataTextField = "DisplayFieldText";
drpFromYear.DataValueField = "ValueFieldText";
drpFromYear.DataBind();
drpFromQuarter.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_QUARTER, null);
drpFromQuarter.DataTextField = "DisplayFieldText";
drpFromQuarter.DataValueField = "ValueFieldText";
drpFromQuarter.DataBind();
//Lines Hided due to Grid view doesn't show at page Load
// grdOverrideGroupB.DataSource = GetDataSource();
// grdOverrideGroupB.DataBind();
foreach (GridViewRow row in grdOverrideGroupB.Rows)
{
string newReason = ((TextBox)grdOverrideGroupB.Rows[row.RowIndex].FindControl("txtReason")).ID;
//(TextBox)grdOverrideGroupB.Rows[row.RowIndex].FindControl("txtReason")
//newReason.Attributes.Add("onkeydown", "javascript:return textAreaCharacterCounter1(this,500);");
}
#region Show the last report run on
clsEntReports objEnt = (new ProjectPerGroupBSummary()).getCurrentQtrYear();
/*Set the Value for drop down for current and last*/
string month = objEnt.Month;
drpFromQuarter.Items.FindByValue(month).Selected = true;
int value = int.Parse(drpFromQuarter.Items.FindByValue(month).Value);
/*Year Need to be set here*/
drpFromYear.Items.FindByText(objEnt.Year).Selected = true;
int valueYr = int.Parse(drpFromYear.Items.FindByText(objEnt.Year).Value);
#endregion
#region BIND THE LATEST GRID
this.GridviewBind();
#endregion
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session[clsConstant.TOKEN] == null)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("OverrideGroupAReport") == false)
{
//UrlParameterPasser urlWrapper = new UrlParameterPasser();
//urlWrapper["pageaccesserr"] = "1";
//// urlWrapper.Url = "../Logout.aspx";
//urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
//urlWrapper.PassParameters();
pnlInvalid.Visible = true;
MainDiv.Visible = false;
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
//this.MakeReadOnly(this.Controls);
}
dt = new DataTable();
comnFunctionObj = new CommonFunction();
drpLoanNumber.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_LOAN_FOR_GROUP_A, null);
drpLoanNumber.DataTextField = "DisplayFieldText";
drpLoanNumber.DataValueField = "ValueFieldText";
drpLoanNumber.DataBind();
drpLoanNumber.Items.RemoveAt(0);
drpLoanNumber.Items.Insert(0, new ListItem("----------ENTER NAME/NO----------", "0"));
drpSector.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_DOC_CATEGORY, null);
drpSector.DataTextField = "DisplayFieldText";
drpSector.DataValueField = "ValueFieldText";
drpSector.DataBind();
drpAgency.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_AGENCY_FOR_GROUP_A, null);
// drpAgency.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_AGENCY, null);
drpAgency.DataTextField = "DisplayFieldText";
drpAgency.DataValueField = "ValueFieldText";
drpAgency.DataBind();
drpState.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_STATE, null);
drpState.DataTextField = "DisplayFieldText";
drpState.DataValueField = "ValueFieldText";
drpState.DataBind();
drpFromYear.DataSource = comnFunctionObj.getDropDownList(clsConstant.SP_GET_YEAR_FOR_REPORTSCEDULER, null);
drpFromYear.DataTextField = "DisplayFieldText";
drpFromYear.DataValueField = "ValueFieldText";
drpFromYear.DataBind();
getMonth();
clsEntReports objEnt = (new ProjectPerGroupA()).getCurrentQtrYear();
string month = objEnt.Month == "Mar" ? "1" : objEnt.Month == "Jun" ? "2" : objEnt.Month == "Sep" ? "3" : objEnt.Month == "Dec" ? "4" : "";
drpFromMonth.Items.FindByValue(month).Selected = true;
int value = int.Parse(drpFromMonth.Items.FindByValue(month).Value);
drpFromYear.Items.FindByText(objEnt.Year).Selected = true;
int valueYr = int.Parse(drpFromYear.Items.FindByText(objEnt.Year).Value);
this.GridviewBind();
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
