public void BindGridView()
{
SqlParameter[] parameter = new SqlParameter[6];
if (ResourceId == 0 && ProjectID == 0)
{
parameter[0] = new SqlParameter("@ResourceID", _resourceID == null ? "0" : _resourceID);
parameter[1] = new SqlParameter("@dayfrom", _dayFrom == null ? "" : _dayFrom);
parameter[2] = new SqlParameter("@dayto", _dayTo == null ? "" : _dayTo);
parameter[3] = new SqlParameter("@Year", Session["Year"]);
parameter[4] = new SqlParameter("@Status", _Status);
parameter[5] = new SqlParameter("@ProjectID", _projectId);
}
else
//int year = Convert.ToInt16(Session["Year"]);
{
parameter[0] = new SqlParameter("@ResourceID", ResourceId);
parameter[1] = new SqlParameter("@dayfrom", dayfrom);
parameter[2] = new SqlParameter("@dayto", dayto);
parameter[3] = new SqlParameter("@Year", Session["Year"]);
parameter[4] = new SqlParameter("@Status", Status);
parameter[5] = new SqlParameter("@ProjectID", ProjectID);
}
DataSet dsProjectDetails = BaseDAL.ExecuteSPDataSet("GetTimeTrackerAudit", parameter);
if (dsProjectDetails != null && dsProjectDetails.Tables.Count > 0)
{
gvTimeTrackerAudit.DataSource = dsProjectDetails.Tables[0] as DataTable;
gvTimeTrackerAudit.DataBind();
}
}
private void BindGridView()
{
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter("@ProjectId", EstAudProjectId);
parameter[1] = new SqlParameter("@Year", 1);
DataSet dsProjectDetails = BaseDAL.ExecuteSPDataSet("GetProjectAudit", parameter);
gvProjectAudit.DataSource = dsProjectDetails.Tables[0] as DataTable;
gvProjectAudit.DataBind();
}
public void BindGridView()
{
EstAudProjectId = Convert.ToInt32(Session["AudProjectId"]);
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter("@ProjectId", EstAudProjectId);
parameter[1] = new SqlParameter("@Year", 1);
DataTable dt = PMOscar.BaseDAL.ExecuteDataTable("SELECT DeliveryDate,RevisedDeliveryDate FROM Project where ProjectId =" + EstAudProjectId + " ");
DataSet dsProjectDetails = BaseDAL.ExecuteSPDataSet("GetProjectAudit", parameter);
gvProjectAudit.DataSource = dsProjectDetails.Tables[0] as DataTable;
gvProjectAudit.DataBind();
}
public void BindGridView()
{
EstProjectId = Convert.ToInt32(Session["EstAudProjectId"]);
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter("@ProjectID", EstProjectId);
parameter[1] = new SqlParameter("@Year", 1);
DataSet dsProjectDetails = BaseDAL.ExecuteSPDataSet("GetProjectEstimationAudit", parameter);
DataTable dt = AddToBugetRevisionDataTable(dsProjectDetails.Tables[0]);
gvProjectEstimationAudit.DataSource = dt; //gvProjectEstimationAudit.DataSource = dsProjectDetails.Tables[0] as DataTable;
gvProjectEstimationAudit.DataBind();
}
public void BindGridView()
{
ActProjectId = Convert.ToInt32(Session["ActProjectId"]);
ActPhaseId = Convert.ToInt32(Session["ActPhaseId"]);
ActEstRoleId = Convert.ToInt32(Session["ActEstRoleId"]);
SqlParameter[] parameter = new SqlParameter[3];
parameter[0] = new SqlParameter("@ProjectId", ActProjectId);
parameter[1] = new SqlParameter("@PhaseID", ActPhaseId);
parameter[2] = new SqlParameter("@EstimationRoleID", ActEstRoleId);
DataSet dsProjectDetails = BaseDAL.ExecuteSPDataSet("GetActualHoursHistory", parameter);
gvProjectAudit.DataSource = dsProjectDetails.Tables[0] as DataTable;
gvProjectAudit.DataBind();
//Session["ActProjectId"] = 0;
//Session["ActPhaseId"] = 0;
//Session["ActEstRoleId"] = 0;
}
