public IHttpActionResult Get([FromBody] PaymentSearch valPayment)
{
string vResult = "4";
IPaymentData vPaymentData = new PaymentData();
try {
bool vNullField = VerifyNullFiledsSearch(valPayment);
if (vNullField)
{
vResult = "2";
return(ResponseMessage(Request.CreateResponse(HttpStatusCode.NotAcceptable, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vListContainNullValue, Result = vResult })));
}
string vResponse = vPaymentData.SelectById(valPayment);
if (!string.IsNullOrEmpty(vResponse))
{
return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.OK, Message = Messages.vOkListed, Result = vResponse })));
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, new { Code = HttpStatusCode.InternalServerError, Message = Messages.vInternalServerError, Result = vResult })));
}
return(ResponseMessage(Request.CreateResponse(HttpStatusCode.OK, new { Code = HttpStatusCode.OK, Message = Messages.vNotListed, Result = vResult })));
}
public async Task<IActionResult> GetList(int page, int rows, PaymentSearch where)
{
if (where == null)
{
where = new PaymentSearch();
}
if (!where.IsSnapshot.HasValue)
{
where.IsSnapshot = false;
}
var data = await _service.GetListAsync(page, rows, where, null);
return PagerData(data.items, page, rows, data.count);
}
public DataTable <PaymentDatatable> GetList(PaymentSearch search, List <MySqlParameter> filters)
{
try
{
using (var ctx = new AppDb())
{
var result = datatableService.GetDataTableResult <PaymentDatatable>("payment_list_sp", search, filters);
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
private bool VerifyNullFiledsSearch(PaymentSearch valPayment)
{
bool vResult = false;
if (valPayment.IdLanguage == Guid.Empty)
{
vResult = true;
return(vResult);
}
if (valPayment.IdPayment == Guid.Empty)
{
vResult = true;
return(vResult);
}
return(vResult);
}
public string SelectById(PaymentSearch valSearch)
{
string vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdPayment", valSearch.IdPayment.ToString()),
new SqlParameter("@IdLanguage", valSearch.IdLanguage.ToString())
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Payment", vConnection);
Payment vData = DataTableToElement(vDatainTable);
if (vData != null)
{
vResult = JsonConvert.SerializeObject(vData, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = null;
}
//var vDes = JsonConvert.DeserializeObject<List<City>>(vResult);
return(vResult);
}
