public HttpResponseMessage WaiterTransactionFilter(HttpRequestMessage req, RP_WaiterTransactionFilter rpWaiterTransactionFilter)
{
if (rpWaiterTransactionFilter != null)
{
RM_WaiterTransactionFilter rmWaiterTransactionFilter = new RM_WaiterTransactionFilter();
List<RPR_WaiterTransactionFilter> rprWaiterTransactionFilter = rmWaiterTransactionFilter.WaiterTransactionFilter(rpWaiterTransactionFilter);
if (rmWaiterTransactionFilter._IsSuccess)
return req.CreateResponse<List<RPR_WaiterTransactionFilter>>(HttpStatusCode.Created, rprWaiterTransactionFilter);
return req.CreateErrorResponse(HttpStatusCode.InternalServerError, "ServerError");
}
return req.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request");
}
public List<RPR_WaiterTransactionFilter> WaiterTransactionFilter(RP_WaiterTransactionFilter rpWaiterTransactionFilter)
{
this.SpName = "DigitalMenu_waiterTransactionFilter"; //Sp Name
_IsSuccess = true;
try
{
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@key", rpWaiterTransactionFilter.key);
param[1] = new SqlParameter("@WaiterId", rpWaiterTransactionFilter.WaiterId);
param[2] = new SqlParameter("@RestId", int.Parse(rpWaiterTransactionFilter.RestId));
param[3] = new SqlParameter("@FromDate", string.IsNullOrEmpty(rpWaiterTransactionFilter.FromDate) ? Convert.DBNull : Convert.ToDateTime(rpWaiterTransactionFilter.FromDate).Date);
param[4] = new SqlParameter("@ToDate", string.IsNullOrEmpty(rpWaiterTransactionFilter.ToDate) ? Convert.DBNull : Convert.ToDateTime(rpWaiterTransactionFilter.ToDate).Date);
param[5] = new SqlParameter("@TableNo", string.IsNullOrEmpty(rpWaiterTransactionFilter.TableNo)?Convert.DBNull:rpWaiterTransactionFilter.TableNo);
ds = db.GetDataSet(this.SpName, param);
if (ds != null && ds.Tables.Count > 0)
{
rprWaiterTransactionFilter = SerializeData.SerializeMultiValue<RPR_WaiterTransactionFilter>(ds.Tables[0]);
}
}
catch (Exception ex)
{
_IsSuccess = false;
Logger.WriteLog(LogLevelL4N.ERROR, " waiter tran filter | Exception : " + ex.Message);
}
return rprWaiterTransactionFilter;
}
