public override DTO.SearchFormData GetDataWithFilter(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
};
var data = new DTO.SearchFormData {
Data = new List <DTO.ClientComplaintSearchResult>()
};
totalRows = 0;
try
{
using (var context = CreateContext())
{
string complaintNumber;
string clientUd;
string clientNm;
string season;
int? complaintStatus;
int? complaintType;
int? saleId;
TryParseFilter(filters, "complaintNumber", out complaintNumber);
TryParseFilter(filters, "clientUD", out clientUd);
TryParseFilter(filters, "clientNM", out clientNm);
TryParseFilter(filters, "saleID", out saleId);
TryParseFilter(filters, "season", out season);
TryParseFilter(filters, "complaintType", out complaintType);
TryParseFilter(filters, "complaintStatus", out complaintStatus);
data.TotalRows = context.ClientComplaint_function_SearchClientComplaint(complaintNumber, clientUd, clientNm, saleId, season, complaintType, complaintStatus, orderBy, orderDirection).Count();
var result = context.ClientComplaint_function_SearchClientComplaint(complaintNumber, clientUd,
clientNm, saleId, season, complaintType, complaintStatus, orderBy, orderDirection);
data.Data = _converter.DB2DTO_ClientComplaintSearchResultList(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
}
data.Seasons = _supportFactory.GetSeason();
data.Sales = _supportFactory.GetSaler();
data.ComplaintStatuses = _supportFactory.GetConstantEntries(EntryGroupType.ComplaintStatus);
data.ComplaintTypes = _supportFactory.GetConstantEntries(EntryGroupType.ComplaintType);
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
public DTO.SearchData GetDataWithFilter(int userId, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
DTO.SearchData searchFormData = new DTO.SearchData();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
totalRows = 0;
try
{
//int? companyID = null;
string season = null;
string purchaseOrderUD = null;
string purchaseOrderDate = null;
string factoryRawMaterialShortNM = null;
string purchaseRequestUD = null;
string eTA = null;
string currency = null;
string remark = null;
int? poStatus = null;
string purchaseOrderIDs = null;
Module.Framework.DAL.DataFactory fw_factory = new Framework.DAL.DataFactory();
//companyID = fw_factory.GetCompanyID(userId);
if (filters.ContainsKey("season") && !string.IsNullOrEmpty(filters["season"].ToString()))
{
season = filters["season"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("purchaseOrderUD") && !string.IsNullOrEmpty(filters["purchaseOrderUD"].ToString()))
{
purchaseOrderUD = filters["purchaseOrderUD"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("purchaseOrderDate") && !string.IsNullOrEmpty(filters["purchaseOrderDate"].ToString()))
{
purchaseOrderDate = filters["purchaseOrderDate"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("factoryRawMaterialShortNM") && !string.IsNullOrEmpty(filters["factoryRawMaterialShortNM"].ToString()))
{
factoryRawMaterialShortNM = filters["factoryRawMaterialShortNM"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("purchaseRequestUD") && !string.IsNullOrEmpty(filters["purchaseRequestUD"].ToString()))
{
purchaseRequestUD = filters["purchaseRequestUD"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("currency") && !string.IsNullOrEmpty(filters["currency"].ToString()))
{
currency = filters["currency"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("eTA") && !string.IsNullOrEmpty(filters["eTA"].ToString()))
{
eTA = filters["eTA"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("remark") && !string.IsNullOrEmpty(filters["remark"].ToString()))
{
remark = filters["remark"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("status") && filters["status"] != null && !string.IsNullOrEmpty(filters["status"].ToString()))
{
poStatus = Convert.ToInt32(filters["status"].ToString());
}
if (filters.ContainsKey("purchaseOrderIDs") && !string.IsNullOrEmpty(filters["purchaseOrderIDs"].ToString()))
{
purchaseOrderIDs = filters["purchaseOrderIDs"].ToString().Replace("'", "''");
}
DateTime?valpurchaseOrderDate = purchaseOrderDate.ConvertStringToDateTime();
DateTime?valETA = eTA.ConvertStringToDateTime();
using (PurchaseOrderMngEntities context = CreateContext())
{
Module.Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory();
totalRows = context.PurchaseOrderMng_function_SearchPurchaseOrder(season, purchaseOrderUD, valpurchaseOrderDate, factoryRawMaterialShortNM, purchaseRequestUD, valETA, currency, orderBy, orderDirection, remark, poStatus, purchaseOrderIDs).Count();
searchFormData.Data = converter.DB2DTO_PurchaseOrderSearch(context.PurchaseOrderMng_function_SearchPurchaseOrder(season, purchaseOrderUD, valpurchaseOrderDate, factoryRawMaterialShortNM, purchaseRequestUD, valETA, currency, orderBy, orderDirection, remark, poStatus, purchaseOrderIDs).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
searchFormData.PurchaseOrderStatus = supportFactory.GetConstantEntries(EntryGroupType.PurchaseOrderStatus);
searchFormData.Seasons = supportFactory.GetSeason();
}
return(searchFormData);
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
notification.DetailMessage.Add(ex.Message);
if (ex.GetBaseException() != null)
{
notification.DetailMessage.Add(ex.GetBaseException().Message);
}
return(searchFormData);
}
}
