// // CUSTOM FUNCTION HERE // public DTO.SupportFormData GetInitData(out Library.DTO.Notification notification) { notification = new Library.DTO.Notification { Type = Library.DTO.NotificationType.Success }; DTO.SupportFormData data = new DTO.SupportFormData(); data.ContainerTypeDTOs = new List <DTO.ContainerTypeDTO>(); try { using (CPLoadingPlanEntities context = CreateContext()) { data.ContainerTypeDTOs = converter.DB2DTO(context.SupportMng_ContainerType_View.ToList()); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }
public override DTO.SearchFormData GetDataWithFilter(System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.SearchFormData data = new DTO.SearchFormData(); data.Data = new List <DTO.LoadingPlanSearchResultDTO>(); data.OrderInfoDTOs = new List <DTO.OrderInfoDTO>(); totalRows = 0; int ClientID = 0; int? ContainerTypeID = null; string BLNo = null; string LoadingPlanUD = null; string ContainerNo = null; string SealNo = null; string ProformaInvoiceNo = null; string ClientOrderNumber = null; DateTime?ETDFrom = null; DateTime?ETDTo = null; DateTime?ETAFrom = null; DateTime?ETATo = null; if (filters.ContainsKey("ClientID") && filters["ClientID"] != null && !string.IsNullOrEmpty(filters["ClientID"].ToString())) { ClientID = Library.Helper.ConvertStringToInt(filters["ClientID"].ToString()).Value; } if (filters.ContainsKey("ContainerTypeID") && filters["ContainerTypeID"] != null && !string.IsNullOrEmpty(filters["ContainerTypeID"].ToString())) { ContainerTypeID = Library.Helper.ConvertStringToInt(filters["ContainerTypeID"].ToString()); } if (filters.ContainsKey("BLNo") && !string.IsNullOrEmpty(filters["BLNo"].ToString())) { BLNo = filters["BLNo"].ToString().Replace("'", "''"); } if (filters.ContainsKey("LoadingPlanUD") && !string.IsNullOrEmpty(filters["LoadingPlanUD"].ToString())) { LoadingPlanUD = filters["LoadingPlanUD"].ToString().Replace("'", "''"); } if (filters.ContainsKey("ContainerNo") && !string.IsNullOrEmpty(filters["ContainerNo"].ToString())) { ContainerNo = filters["ContainerNo"].ToString().Replace("'", "''"); } if (filters.ContainsKey("SealNo") && !string.IsNullOrEmpty(filters["SealNo"].ToString())) { SealNo = filters["SealNo"].ToString().Replace("'", "''"); } if (filters.ContainsKey("ProformaInvoiceNo") && !string.IsNullOrEmpty(filters["ProformaInvoiceNo"].ToString())) { ProformaInvoiceNo = filters["ProformaInvoiceNo"].ToString().Replace("'", "''"); } if (filters.ContainsKey("ClientOrderNumber") && !string.IsNullOrEmpty(filters["ClientOrderNumber"].ToString())) { ClientOrderNumber = filters["ClientOrderNumber"].ToString().Replace("'", "''"); } if (filters.ContainsKey("ETDFrom") && !string.IsNullOrEmpty(filters["ETDFrom"].ToString())) { ETDFrom = Library.Helper.ConvertStringToDateTime(filters["ETDFrom"].ToString(), nl); } if (filters.ContainsKey("ETDTo") && !string.IsNullOrEmpty(filters["ETDTo"].ToString())) { ETDTo = Library.Helper.ConvertStringToDateTime(filters["ETDTo"].ToString(), nl); } if (filters.ContainsKey("ETAFrom") && !string.IsNullOrEmpty(filters["ETAFrom"].ToString())) { ETAFrom = Library.Helper.ConvertStringToDateTime(filters["ETAFrom"].ToString(), nl); } if (filters.ContainsKey("ETATo") && !string.IsNullOrEmpty(filters["ETATo"].ToString())) { ETATo = Library.Helper.ConvertStringToDateTime(filters["ETATo"].ToString(), nl); } //try to get data try { using (CPLoadingPlanEntities context = CreateContext()) { totalRows = context.CP_LoadingPlanMng_function_SearchLoadingPlan(ClientID, BLNo, ETDFrom, ETDTo, ETAFrom, ETATo, LoadingPlanUD, ContainerTypeID, ContainerNo, SealNo, ProformaInvoiceNo, ClientOrderNumber, orderBy, orderDirection).Count(); var result = context.CP_LoadingPlanMng_function_SearchLoadingPlan(ClientID, BLNo, ETDFrom, ETDTo, ETAFrom, ETATo, LoadingPlanUD, ContainerTypeID, ContainerNo, SealNo, ProformaInvoiceNo, ClientOrderNumber, orderBy, orderDirection); data.Data = converter.DB2DTO(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); var IDs = data.Data.Select(o => o.LoadingPlanID).ToArray(); if (IDs.Length > 0) { var IDstring = string.Join(",", IDs); data.OrderInfoDTOs = converter.DB2DTO(context.CP_LoadingPlanMng_function_GetOrderInfo(IDstring).ToList()); } } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }