public CardStatisticsResponse CardStatistics(CardStatisticsRequest request)
{
var result = new ServerCardStatisticsResponse();
var returnValue = result.ProcessRequest(cnn, request);
return(returnValue);
}
public JsonResult GetClientInfo(string card)
{
LCManager.Infrastructure.Request.GetClientInfoRequest clientInfoRequest = new LCManager.Infrastructure.Request.GetClientInfoRequest();
if (!string.IsNullOrEmpty(card))
{
try { clientInfoRequest.Card = Convert.ToInt64(card); } catch { }
}
else
{
return(Json(new LCManager.Infrastructure.Response.GetClientInfoResponse {
ErrorCode = 10, Message = "Не указана карта клиента"
}));
}
try { clientInfoRequest.Operator = Convert.ToInt16(JwtProps.GetOperator()); } catch { }
HttpResponseMessage response = HttpClientService.PostAsync("api/values/ClientInfo", clientInfoRequest).Result;
if (response.IsSuccessStatusCode)
{
LCManager.Infrastructure.Response.GetClientInfoResponse clientInfoResponse = response.Content.ReadAsAsync <LCManager.Infrastructure.Response.GetClientInfoResponse>().Result;
if (clientInfoResponse.ErrorCode == 0)
{
CardInfoResponse response2 = new CardInfoResponse();
CardStatisticsRequest request2 = new CardStatisticsRequest
{
Card = clientInfoResponse.Card
};
HttpResponseMessage responseMessage2 = HttpClientService.PostAsync("api/card/GetCard", request2).Result;
if (responseMessage2.IsSuccessStatusCode)
{
response2 = responseMessage2.Content.ReadAsAsync <CardInfoResponse>().Result;
if (response2.ErrorCode == 0)
{
return(Json(new { data1 = clientInfoResponse, data2 = response2 }));
}
}
return(Json(new DefaultResponse {
ErrorCode = 11, Message = "Ошибка запроса к ClientInfo"
}));
}
}
return(Json(new DefaultResponse {
ErrorCode = 11, Message = "Ошибка запроса к ClientInfo"
}));
}
/// <summary>
/// Получает базовую инфу по карте ПЛ (статус, тип, оператор, баланс, кол-во покупок, сумма покупок, кол-во начисленных бонусов, кол-во списанных бонусов
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public CardInfoResponse GetCard(CardStatisticsRequest request)
{
CardInfoResponse response = new CardInfoResponse();
try
{
_cnn.Open();
var cmd = _cnn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CardGet";
if (request.Card > 0)
{
cmd.Parameters.AddWithValue("@number", request.Card);
}
//cmd.Parameters.Add("@status", SqlDbType.NVarChar, 20);
//cmd.Parameters["@status"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@virtual", SqlDbType.Bit, 100);
//cmd.Parameters["@virtual"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@name", SqlDbType.NVarChar, 20);
//cmd.Parameters["@name"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@fullbalance", SqlDbType.Decimal);
//cmd.Parameters["@fullbalance"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@balance", SqlDbType.Decimal);
//cmd.Parameters["@balance"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@purchases", SqlDbType.Int);
//cmd.Parameters["@purchases"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@purchasesum", SqlDbType.Decimal);
//cmd.Parameters["@purchasesum"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@charged", SqlDbType.Decimal);
//cmd.Parameters["@charged"].Direction = ParameterDirection.Output;
//cmd.Parameters.Add("@redeemed", SqlDbType.Decimal);
//cmd.Parameters["@redeemed"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@errormessage", SqlDbType.NVarChar, 100);
cmd.Parameters["@errormessage"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@result", SqlDbType.Int);
cmd.Parameters["@result"].Direction = ParameterDirection.ReturnValue;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
response.Status = reader.GetString(0);
}
if (!reader.IsDBNull(1))
{
response.Type = reader.GetBoolean(1);
}
if (!reader.IsDBNull(2))
{
response.OperatorName = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
response.FullBalance = reader.GetDecimal(3);
}
if (!reader.IsDBNull(4))
{
response.Balance = reader.GetDecimal(4);
}
if (!reader.IsDBNull(5))
{
response.Purchases = reader.GetInt16(5);
}
if (!reader.IsDBNull(6))
{
response.PurchaseSum = reader.GetDecimal(6);
}
if (!reader.IsDBNull(7))
{
response.Charged = reader.GetDecimal(7);
}
if (!reader.IsDBNull(8))
{
response.Redeemed = reader.GetDecimal(8);
}
//if (!reader.IsDBNull(14))
//{
// if (reader.GetBoolean(14) == false)
// {
// returnValue.Gender = -1;
// }
// else
// {
// returnValue.Gender = 1;
// }
//}
}
//try { response.Status = Convert.ToString(cmd.Parameters["@status"].Value); } catch { }
//try { response.OperatorName = Convert.ToString(cmd.Parameters["@name"].Value); } catch { }
//try { response.Type = Convert.ToString(cmd.Parameters["@virtual"].Value); } catch { }
//try { response.FullBalance = Convert.ToDecimal(cmd.Parameters["@fullbalance"].Value); } catch { }
//try { response.Balance = Convert.ToDecimal(cmd.Parameters["@balance"].Value); } catch { }
//try { response.Purchases = Convert.ToInt32(cmd.Parameters["@purchases"].Value); } catch { }
//try { response.PurchaseSum = Convert.ToDecimal(cmd.Parameters["@purchasesum"].Value); } catch { }
//try { response.Charged = Convert.ToDecimal(cmd.Parameters["@charged"].Value); } catch { }
//try { response.Redeemed = Convert.ToDecimal(cmd.Parameters["@redeemed"].Value); } catch { }
response.ErrorCode = Convert.ToInt32(cmd.Parameters["@result"].Value);
response.Message = Convert.ToString(cmd.Parameters["@errormessage"].Value);
}
catch (Exception e)
{
response.ErrorCode = 10;
response.Message = e.Message;
}
finally
{
_cnn.Close();
}
return(response);
}
public CardInfoResponse GetCard(CardStatisticsRequest request)
{
return(_cardService.GetCard(request));
}