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; }