public DTO.SupportFormData GetSearchFilter(out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
DTO.SupportFormData data = new DTO.SupportFormData();
data.SaleDTOs = new List <DTO.SaleDTO>();
try
{
using (MIDeltaByClientRptEntities context = CreateContext())
{
data.SaleDTOs.Add(new DTO.SaleDTO {
UserID = -1, SaleUD = "GEN", EmployeeNM = "General"
});
data.SaleDTOs.AddRange(converter.DB2DTO_SaleDTO(context.SupportMng_AccountManager_View.Where(o => o.IsAccountManager).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.DeltaByClientDTO>();
totalRows = 0;
string Season = null;
int? SaleID = null;
int UserID = 0;
int? ClientID = null;
if (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString()))
{
Season = filters["Season"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("UserID") && filters["UserID"] != null && !string.IsNullOrEmpty(filters["UserID"].ToString()))
{
UserID = Convert.ToInt32(filters["UserID"].ToString());
}
if (!fwFactory.HasSpecialPermission(UserID, "ViewAllSalesData"))
{
SaleID = UserID;
}
else
{
if (filters.ContainsKey("SaleID") && filters["SaleID"] != null && !string.IsNullOrEmpty(filters["SaleID"].ToString()))
{
SaleID = Convert.ToInt32(filters["SaleID"].ToString());
}
if (SaleID == -1)
{
SaleID = null;
}
}
if (filters.ContainsKey("ClientID") && filters["ClientID"] != null && !string.IsNullOrEmpty(filters["ClientID"].ToString()))
{
ClientID = Convert.ToInt32(filters["ClientID"].ToString());
}
//try to get data
try
{
using (MIDeltaByClientRptEntities context = CreateContext())
{
//totalRows = context.Sample2Mng_function_SearchSampleOrder(SampleOrderUD, Season, ClientUD, ClientNM, PurposeID, TransportTypeID, SampleOrderStatusID, orderBy, orderDirection).Count();
var result = context.MIDeltaByClientRpt_function_SearchData(Season, SaleID, ClientID, orderBy, orderDirection).ToList();
data.Data = converter.DB2DTO_DeltaByClient(result);
totalRows = result.Count();
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}