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