public ListResponeMessage <QuoteInfo> GetListWithCondition(string quoteCode = "",
string proposalCode = "", int customerID = 0, DateTime?fromDate = null,
DateTime?toDate = null, int pageSize = 10, int pageIndex = 0, string _userID = "")
{
ListResponeMessage <QuoteInfo> ret = new ListResponeMessage <QuoteInfo>();
try
{
QuoteSeachCriteria _criteria = new QuoteSeachCriteria();
_criteria.ProposalCode = proposalCode;
_criteria.QuoteCode = quoteCode;
_criteria.CustomerID = customerID;
_criteria.FromDate = fromDate;
_criteria.ToDate = toDate;
_criteria.pageSize = pageSize;
_criteria.pageIndex = pageIndex;
ret.isSuccess = true;
ret.data = QuoteService.GetInstance().getAllQuote(pageSize, pageIndex, _criteria, _userID);
ret.totalRecords = ret.data.Count;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "005";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public int getTotalRecords(QuoteSeachCriteria _criteria, string _userID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
return(QuoteDataLayer.GetInstance().getTotalRecords(connection, _criteria, _userID));
}
}
public List <QuoteInfo> getAllQuote(int pageSize, int pageIndex, QuoteSeachCriteria _criteria, string _userID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
return(QuoteDataLayer.GetInstance().GetListQuote(connection, _criteria, _userID));
}
}
public List <QuoteInfo> getQuote(QuoteSeachCriteria _criteria, string _userID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <QuoteInfo> ListQuote = QuoteDataLayer.GetInstance().GetListQuote(connection, _criteria, _userID);
return(ListQuote);
}
}
