public static DataSet GetGeneralChangesRequestsExport(GeneralChangesRequestSearch requestFilter) { return(DataFacade.GetDataSet("GeneralChangesRequestsExportGet", new ParameterValue("RequestId", requestFilter.Id), new ParameterValue("RequesterId", requestFilter.Requester == null ? -1 : requestFilter.Requester.RequesterID), new ParameterValue("RequestDatetimeFrom", requestFilter.DateCreatedFrom), new ParameterValue("RequestDatetimeTo", requestFilter.DateCreatedTo), new ParameterValue("SpecialistVerificationStatus", (string)null), new ParameterValue("MasterDataStatus", !String.IsNullOrEmpty(requestFilter.MasterDataStatus) ? requestFilter.MasterDataStatus : null), new ParameterValue("RequesterSiteNumber", requestFilter.Requester == null || String.IsNullOrEmpty(requestFilter.Requester.SiteNumber) ? null : requestFilter.Requester.SiteNumber), new ParameterValue("IncludeArchive", requestFilter.IncludeArchive) )); }
public static IEnumerable <GeneralChangesRequest> GetGeneralChangesRequests( GeneralChangesRequestSearch requestFilter) { var dataSet = DataFacade.GetDataSet("GeneralChangesRequestsGet", new ParameterValue("RequestId", requestFilter.Id), new ParameterValue("RequesterId", requestFilter.Requester == null ? -1 : requestFilter.Requester.RequesterID), new ParameterValue("RequestDatetimeFrom", requestFilter.DateCreatedFrom), new ParameterValue("RequestDatetimeTo", requestFilter.DateCreatedTo), new ParameterValue("SpecialistVerificationStatus", (string)null), new ParameterValue("MasterDataStatus", !String.IsNullOrEmpty(requestFilter.MasterDataStatus) ? requestFilter.MasterDataStatus : null), new ParameterValue("RequesterSiteNumber", requestFilter.Requester == null || String.IsNullOrEmpty( requestFilter.Requester.SiteNumber) ? null : requestFilter.Requester.SiteNumber), new ParameterValue("IncludeArchive", requestFilter.IncludeArchive) ); var items = new List <GeneralChangesItem>(); foreach (var group in dataSet.Tables["Table4"].Rows.Cast <DataRow>().Select(z => new GeneralChangesItemGroup { Active = (bool)z["Active"], GroupName = z["GroupName"].ToString(), Id = (int)z["Id"], SortOrder = (int)z["SortOrder"], MinSelectionCount = (byte)z["MinSelectionCount"], MaxSelectionCount = (byte)z["MaxSelectionCount"], Approvable = (bool)z["Approvable"] })) { group.GeneralChangesItems = dataSet.Tables["Table3"].Rows.Cast <DataRow>().Where( x => (int)x["GeneralChangesItemGroupId"] == group.Id).Select(row => new GeneralChangesItem { Active = (bool)row["Active"], GeneralChangesItemGroup = group, Id = (int)row["Id"], ItemName = row["ItemName"].ToString(), SortOrder = (int)row["SortOrder"] }).ToList(); items.AddRange(group.GeneralChangesItems); } var returnList = new List <GeneralChangesRequest>(); foreach ( var requestItem in dataSet.Tables["Table"].Rows.Cast <DataRow>().Select(request => new GeneralChangesRequest { Id = (int)request["Id"], Requester = dataSet.Tables["Table1"].Rows.Cast <DataRow>().Where( x => (int)x["RequesterID"] == (int)request["RequesterId"]).Select( x => new Requester { RequesterID = (int)x["RequesterID"], RequestDate = (DateTime)x["RequestDate"], Motivation = x["Motivation"].ToString(), SiteName = x["SiteName"].ToString(), SiteNumber = x["SiteNumber"].ToString(), EmailAddress = x["EmailAddress"].ToString(), ContactNo = x["ContactNo"].ToString(), RequesterName = x["RequesterName"].ToString() }).FirstOrDefault(), DateCreated = (DateTime)request["DateCreated"], SpecialistVerificationStatus = request["SpecialistVerificationStatus"].ToString(), SpecialistVerificationStatusDateTime = request["SpecialistVerificationStatusDateTime"] as DateTime?, IsApproved = (bool)request["IsApproved"], SpecialistVerificationComments = request["SpecialistVerificationComments"].ToString(), MasterDataComments = request["MasterDataComments"].ToString(), ApprovedDateTime = request["ApprovedDateTime"] as DateTime?, MasterDataStatus = request["MasterDataStatus"].ToString(), MasterDataStatusDateTime = request["MasterDataStatusDateTime"] as DateTime?, Archive = (bool)request["Archive"], IsLoaded = (bool)request["IsLoaded"], LoadedDateTime = request["LoadedDateTime"] as DateTime?, MasterDataUserId = request["MasterDataUserId"].ToString(), SpecialistVerificationUserId = request["SpecialistVerificationUserId"].ToString() })) { GeneralChangesRequest reqItem = requestItem; requestItem.GeneralChangesItems = dataSet.Tables["Table2"].Rows.Cast <DataRow>().Where( x => (int)x["GeneralChangesRequestId"] == reqItem.Id).Select(x => new GeneralChangesLink { Id = (int)x["Id"], GeneralChangesRequest = reqItem, GeneralChangesItem = items.FirstOrDefault(y => y.Id == (int)x["GeneralChangesItemId"]), IsSelected = (bool)x["IsSelected"], Comments = x["Comments"].ToString(), Approved = x["Approved"] as bool?, MasterDataApproved = x["MasterDataApproved"] as bool?, SpecialistVerificationApproved = x["SpecialistVerificationApproved"] as bool? }).ToList(); returnList.Add(requestItem); } return(returnList); }
public DataSet GetGeneralChangesRequestsExport(GeneralChangesRequestSearch requestFilter) { return(GeneralChangesRequestDao.GetGeneralChangesRequestsExport(requestFilter)); }
public IEnumerable <GeneralChangesRequest> GetGeneralChangesRequests(GeneralChangesRequestSearch requestFilter) { return(GeneralChangesRequestDao.GetGeneralChangesRequests(requestFilter)); }