public DTO.InitDataDTO SearchPI(Hashtable filters, out Notification notification)
{
notification = new Notification()
{
Type = NotificationType.Success
};
DTO.InitDataDTO data = new DTO.InitDataDTO();
data.Data = new List <DTO.SupportQCReportSetting>();
try
{
string searchString = (filters.ContainsKey("searchQuery") && filters["searchQuery"] != null && !string.IsNullOrEmpty(filters["searchQuery"].ToString().Replace("'", "''"))) ? filters["searchQuery"].ToString() : null;
int? factoryID = null;
if (filters.ContainsKey("factoryID") && !string.IsNullOrEmpty(filters["factoryID"].ToString()))
{
factoryID = Convert.ToInt32(filters["factoryID"].ToString());
}
using (var context = CreateContext())
{
data.Data = converter.DB2DTO_SearchPI(context.QCReportMng_function_SearchQCReportSetting(factoryID, searchString).ToList());
}
}
catch (Exception ex)
{
notification = new Notification {
Type = NotificationType.Error, Message = ex.Message
};
return(null);
}
return(data);
}
public DTO.InitDataDTO QuickSearchSample(int userId, int?factoryID, Hashtable filters, out Notification notification)
{
notification = new Notification()
{
Type = NotificationType.Success
};
DTO.InitDataDTO data = new DTO.InitDataDTO();
data.Data = new List <DTO.QuickSearchSampleProductDTO>();
try
{
int userID = userId;
//if (filters.ContainsKey("factoryID") && !string.IsNullOrEmpty(filters["factoryID"].ToString()))
//{
// factoryID = Convert.ToInt32(filters["factoryID"].ToString());
//}
string searchString = (filters.ContainsKey("searchQuery") && filters["searchQuery"] != null && !string.IsNullOrEmpty(filters["searchQuery"].ToString().Replace("'", "''"))) ? filters["searchQuery"].ToString() : null;
using (var context = CreateContext())
{
data.Data = converter.DB2DTO_QuickSerachSample(context.SpecificationMng_Function_QuickSearchSample(userID, factoryID, searchString).ToList());
}
}
catch (Exception ex)
{
notification = new Notification {
Type = NotificationType.Error, Message = ex.Message
};
return(null);
}
return(data);
}
public DTO.InitDataDTO GetInitData(out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.InitDataDTO data = new DTO.InitDataDTO();
data.Factories = new List <Support.DTO.Factory>();
try
{
data.Factories = supportFactory.GetFactory().ToList();
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
