protected void lb_Command(object sender, CommandEventArgs e) { if (e.CommandName != "UpdateGrid") { return; } Bll.PageEntityID fed = new Bll.PageEntityID(); bool IsMoreValues = false; ParseComplexEntity(e.CommandArgument.ToString(), out fed.EntityID, out fed.PageNumber, out IsMoreValues); List <MetricTrac.Bll.EntityValue> fms = GetData(fed); MetricTrac.MTControls.MTGridView cgvMetricValue = (MetricTrac.MTControls.MTGridView)(((System.Web.UI.Control)sender).Parent.Parent).FindControl("cgvMetricValue"); if (fms.Count != 1) { return; } MetricTrac.Bll.EntityValue LastMetricMetricValue = fms[0]; Panel pnlPager = (Panel)(((System.Web.UI.Control)sender).Parent); Panel pnlUpdate = (Panel)(((System.Web.UI.Control)sender).Parent.Parent); pnlPager.Controls.Clear(); CreateLinkButtons(pnlPager, LastMetricMetricValue.EntityID, LastMetricMetricValue.PageCount, LastMetricMetricValue.IsMoreValues); HiddenField hfLinksMemory = (HiddenField)pnlUpdate.FindControl("hfLinksMemory"); hfLinksMemory.Value = LastMetricMetricValue.EntityID.ToString() + "|" + LastMetricMetricValue.PageCount.ToString() + "|" + LastMetricMetricValue.IsMoreValues.ToString(); cgvMetricValue.DataSource = LastMetricMetricValue.EntityValues; cgvMetricValue.DataBind(); }
private List <MetricTrac.Bll.EntityValue> GetData(Bll.PageEntityID fed) { Guid?ApproverUserId = MetricTrac.Bll.LinqMicajahDataContext.LogedUserId; return(MetricTrac.Bll.MetricValue.WorkList(ValueCount, fed, ApproverUserId, GroupByMetric)); }
public static List <EntityValue> WorkList(int ValueCount, PageEntityID EntityPageInfo, Guid? @ApproverUserId, bool OrderByMetric) { LinqMicajahDataContext dc = new LinqMicajahDataContext(); Guid?EntityID = null; int SkipCount = 0; if (EntityPageInfo != null) { EntityID = EntityPageInfo.EntityID; SkipCount = EntityPageInfo.PageNumber * ValueCount; } ISingleResult <Sp_SelectApproverWorkListResult> V = dc.Sp_SelectApproverWorkList(LinqMicajahDataContext.InstanceId, ValueCount, SkipCount, EntityID, OrderByMetric, @ApproverUserId); List <EntityValue> MetricMetricValues = new List <EntityValue>(); EntityValue LastMetricMetricValue = null; List <Micajah.Common.Bll.MeasureUnit> OrgUoMs = Mc_UnitsOfMeasure.GetOrganizationUoMs(); int i = 0; foreach (var v in V) { if (LastMetricMetricValue == null || (OrderByMetric && v.MetricID != LastMetricMetricValue.EntityID) || (!OrderByMetric && v.OrgLocationID != LastMetricMetricValue.EntityID)) { i = 0; LastMetricMetricValue = new EntityValue(); // copy metric data LastMetricMetricValue.FrequencyID = OrderByMetric ? v.MetricFrequencyID : null; LastMetricMetricValue.PageCount = (SkipCount / ValueCount) + 1; LastMetricMetricValue.EntityID = OrderByMetric ? (Guid)v.MetricID : (Guid)v.OrgLocationID; LastMetricMetricValue.EntityName = OrderByMetric ? v.MetricName : v.OrgLocationFullName; LastMetricMetricValue.IsMoreValues = false; LastMetricMetricValue.MetricTypeID = (int)v.MetricTypeID; MetricMetricValues.Add(LastMetricMetricValue); } if (i == ValueCount) { LastMetricMetricValue.IsMoreValues = true; continue; } MetricValue.Extend LastMetricValue = new MetricValue.Extend(); // metric data LastMetricValue.InstanceId = (Guid)v.InstanceId; LastMetricValue.MetricID = (Guid)v.MetricID; LastMetricValue.NODecPlaces = v.NODecPlaces; LastMetricValue.MetricName = v.MetricName; LastMetricValue.MetricCategoryName = v.MetricCategoryFullName; // value data LastMetricValue.MetricValueID = (Guid)v.MetricValueID; LastMetricValue.FrequencyID = (int)v.ValueFrequencyID; LastMetricValue.ValueFrequencyName = v.ValueFrequencyName; LastMetricValue.Date = (DateTime)v.Date; LastMetricValue.Period = Frequency.GetPeriodName((DateTime)v.Date, LastMetricValue.FrequencyID, true); LastMetricValue.Value = v.Value; LastMetricValue.Approved = v.Approved; LastMetricValue.ReviewUpdated = (bool)v.ReviewUpdated; LastMetricValue.MissedCalc = (bool)v.MissedCalc; string title = String.Empty; if (v.MetricValueID == null || v.MetricValueID == Guid.Empty || String.IsNullOrEmpty(v.Value) /* || v.Status == false*/) //!!! add after fix stored procedure { LastMetricValue.ApprovalStatus = "Missing Value"; } else { if (v.MetricTypeID != 1) { title = "Calc value"; if (v.MissedCalc == true) { title += " | Some input values missed"; } } else { title = "Input value"; } LastMetricValue.ApprovalStatus = (v.Approved == null ? (v.ReviewUpdated == true ? "Under Review | Updated by Collector" : "Under Review") : ((bool)v.Approved ? "Approved" : "Pending")); } title = String.IsNullOrEmpty(title) ? String.Empty : "(" + title + ") "; LastMetricValue.Notes = title + v.Notes; LastMetricValue.FilesAttached = (bool)v.FilesAttached; LastMetricValue.ReviewUpdated = (bool)v.ReviewUpdated; LastMetricValue.OrgLocationID = (Guid)v.OrgLocationID; LastMetricValue.MetricDataTypeID = (int)v.ValueDataTypeID; LastMetricValue.InputUnitOfMeasureID = v.ValueInputUnitOfMeasureID; LastMetricValue.ValueInputUnitOfMeasureName = GetMeasureUnitAbbvr(OrgUoMs, LastMetricValue.InputUnitOfMeasureID); LastMetricValue.OrgLocationFullName = v.OrgLocationID == Guid.Empty ? LinqMicajahDataContext.OrganizationName : v.OrgLocationFullName; LastMetricValue.RelatedOrgLocationUoMRecordID = v.MetricOrgLocationUoMID; LastMetricValue.OrgLocationUnitOfMeasureID = v.OrgLocationUnitOfMeasureID; LastMetricValue.IsCalculated = v.MetricTypeID != 1; LastMetricMetricValue.EntityValues.Add(LastMetricValue); i++; } return(MetricMetricValues); }