public IHttpActionResult ByUser([FromBody] PaymentUserSearch valPayment)
{
string vResult = "4";
IPaymentData vPaymentData = new PaymentData();
try {
bool vNullField = VerifyNullFiledsUserSearch(valPayment);
if (vNullField)
{
vResult = "2";
return(ResponseMessage(Request.CreateResponse(HttpStatusCode.NotAcceptable, new { Code = HttpStatusCode.NotAcceptable, Message = Messages.vListContainNullValue, Result = vResult })));
}
string vResponse = vPaymentData.SelectByUser(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.vNotInserted, Result = vResult })));
}
public string SelectByUser(PaymentUserSearch valSearch)
{
string vResult = null;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdUser", valSearch.IdUser.ToString()),
new SqlParameter("@IdLanguage", valSearch.IdLanguage.ToString()),
new SqlParameter("@RowsPerPage", valSearch.RowsPerPage),
new SqlParameter("@PageNumber", valSearch.PageNumber)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Payment_User", vConnection);
List <Payment> vData = DataTableToListSearchUser(vDatainTable);
SetIfUserHasRankingActivity(ref vData);
long vTotalRows = GetTotalByUser(valSearch);
PaymentResponse vResponseObject = new PaymentResponse();
vResponseObject.Payments = vData;
vResponseObject.TotalRows = vTotalRows;
if (vResponseObject != null)
{
vResult = JsonConvert.SerializeObject(vResponseObject, Formatting.Indented);
}
} catch (Exception vEx) {
string vMessage = vEx.Message;
vResult = null;
}
//var vDes = JsonConvert.DeserializeObject<List<City>>(vResult);
return(vResult);
}
private bool VerifyNullFiledsUserSearch(PaymentUserSearch valPayment)
{
bool vResult = false;
if (valPayment.IdLanguage == Guid.Empty)
{
vResult = true;
return(vResult);
}
if (valPayment.IdUser == Guid.Empty)
{
vResult = true;
return(vResult);
}
return(vResult);
}
private long GetTotalByUser(PaymentUserSearch valSearch)
{
long vResult = 0;
DataTable vDatainTable = new DataTable();
SQLToolsLibrary vSqlTools = new SQLToolsLibrary();
try {
List <SqlParameter> vParameterList = new List <SqlParameter> {
new SqlParameter("@IdUser", valSearch.IdUser.ToString()),
new SqlParameter("@IdLanguage", valSearch.IdLanguage.ToString()),
new SqlParameter("@RowsPerPage", valSearch.RowsPerPage),
new SqlParameter("@PageNumber", valSearch.PageNumber)
};
vDatainTable = vSqlTools.ExcecuteSelectWithStoreProcedure(vParameterList, "sp_Select_Payment_User_Count", vConnection);
vResult = DataTableToListSearchTotal(vDatainTable);
} catch (Exception vEx) {
string vMessage = vEx.Message;
}
return(vResult);
}
