public ValidationLead GetValidationInformation(int validationID) { using (var dc = new EngageCCTDataClassesDataContext()) { ValidationLead vlead = new ValidationLead(); var tValidation = dc.T_Validations.Where(v => v.ValidationID == validationID).FirstOrDefault(); if (tValidation != null) { List<ValidationResult> results = new List<ValidationResult>(); var tResults = dc.T_ValidationResults .Where(res => res.ValidationID == tValidation.ValidationID); foreach (T_ValidationResult res in tResults) { results.Add(GetValidationResultEntity(res)); } vlead.Results = results; DateTime dt = tValidation.vldDate; int year = dt.Year; int month = dt.Month; int day = dt.Day; vlead.Date = string.Format("{0}/{1}/{2}", month, day, year); CCTLeadProvider leadProvider = new CCTLeadProvider(); vlead.ValidationID = tValidation.ValidationID; vlead.Lead = leadProvider.GetLeadEntity(tValidation.T_Lead); vlead.User = leadProvider.GetUserInformationEntity(tValidation.T_UserInformation); } return vlead; } }
public List<ValidationLead> GetValidationsPage(int leadID, int rowIndex, int pageSize) { using (var dc = new EngageCCTDataClassesDataContext()) { int pageIndex = rowIndex / pageSize; var list = new List<ValidationLead>(); var validPage = dc.T_Validations.Where(v => v.T_Lead.LeadID == leadID).OrderByDescending(o => o.vldDate).Skip(pageIndex * pageSize).Take(pageSize); foreach (var item in validPage) { List<ValidationResult> results = new List<ValidationResult>(); var tResults = dc.T_ValidationResults .Where(res => res.ValidationID == item.ValidationID) .OrderBy(ob => ob.TypeID); foreach (T_ValidationResult res in tResults) { //if (item.) results.Add(GetValidationResultEntity(res)); } ValidationLead validation = new ValidationLead(); DateTime dt = item.vldDate; int year = dt.Year; int month = dt.Month; int day = dt.Day; validation.Date = string.Format("{0}/{1}/{2}", month, day, year); validation.Results = results; CCTLeadProvider leadProvider = new CCTLeadProvider(); validation.ValidationID = item.ValidationID; validation.Lead = leadProvider.GetLeadEntity(item.T_Lead); validation.User = leadProvider.GetUserInformationEntity(item.T_UserInformation); list.Add(validation); } return list; } }