/// <summary>
/// Make a bet on an open roulette
/// </summary>
/// <param name="apuestaRequest"></param>
/// <returns></returns>
public ModeloResponse <int> PlaceBet(ApuestaRequest apuestaRequest)
{
try
{
using (DataConnectionFactory <int> dapper = new ConnectionFactory <int>(AppConfiguration.Instance.MasivianBD).GetConnectionMananager())
{
dapper.AddParameter("Numero", apuestaRequest.Numero);
dapper.AddParameter("Color", apuestaRequest.Color);
dapper.AddParameter("Dinero", apuestaRequest.Dinero);
dapper.AddParameter("ID_Ruleta", apuestaRequest.IdRuleta);
dapper.AddParameter("ID_Usuario", apuestaRequest.IdUsuario);
var list = dapper.GetList(StoreProcedures.SP_PlaceBet);
if (list != null && list.Any())
{
return(ResponseManager <int> .ResponseOK(0, list));
}
return(ResponseManager <int> .ResponseInternalServerError("Error al realizar apuesta"));
}
}
catch (System.Exception ex)
{
Log.Error(ex, ex.Message);
return(ResponseManager <int> .ResponseInternalServerError(ex.Message));
}
}
public void Insert(Department obj)
{
_objConnectionFactory.AddParameter("@pNameDepartment", obj.NameDepartment);
_objConnectionFactory.AddParameter("@pDescriptionDepartment", obj.DescriptionDepartment);
_objConnectionFactory.ExecuteStoredProcedureNonQuery("spInsertDepartment");
}
/// <summary>
/// Close the bet
/// </summary>
/// <param name="cerrarRuletaRequest"></param>
/// <returns></returns>
public ModeloResponse <CerrarRuletaResponse> CloseBet(CerrarRuletaRequest cerrarRuletaRequest)
{
try
{
using (DataConnectionFactory <CerrarRuletaResponse> dapper = new ConnectionFactory <CerrarRuletaResponse>(AppConfiguration.Instance.MasivianBD).GetConnectionMananager())
{
dapper.AddParameter("IdRuleta", cerrarRuletaRequest.IdRuleta);
dapper.AddParameter("NumeroGanador", cerrarRuletaRequest.NumeroGanador);
var list = dapper.GetList(StoreProcedures.SP_CloseBet);
if (list != null && list.Any())
{
return(ResponseManager <CerrarRuletaResponse> .ResponseOK(0, list));
}
return(ResponseManager <CerrarRuletaResponse> .ResponseInternalServerError("Error al cerrar ruleta"));
}
}
catch (System.Exception ex)
{
Log.Error(ex, ex.Message);
return(ResponseManager <CerrarRuletaResponse> .ResponseInternalServerError(ex.Message));
}
}
/// <summary>
/// Login for client
/// </summary>
/// <param name="clienteRequest"></param>
/// <returns></returns>
public ModeloResponse <ClienteResponse> LoginClient(AuthorizeClient clienteRequest)
{
try
{
using (DataConnectionFactory <ClienteResponse> dapper = new ConnectionFactory <ClienteResponse>(AppConfiguration.Instance.MasivianBD).GetConnectionMananager())
{
dapper.AddParameter("Usuario", clienteRequest.Usuario);
dapper.AddParameter("Contrasena", clienteRequest.Contrasena);
var list = dapper.GetList(StoreProcedures.SP_Login);
if (list != null && list.Any())
{
return(ResponseManager <ClienteResponse> .ResponseOK(0, list));
}
return(ResponseManager <ClienteResponse> .ResponseConflict("Usuario o Contrasena incorrecta"));
}
}
catch (System.Exception ex)
{
Log.Error(ex, ex.Message);
return(ResponseManager <ClienteResponse> .ResponseInternalServerError(ex.Message));
}
}
/// <summary>
/// Active the roulette
/// </summary>
/// <param name="idRuleta"></param>
/// <returns></returns>
public ModeloResponse <int> ActiveRuletas(int idRuleta)
{
try
{
using (DataConnectionFactory <int> dapper = new ConnectionFactory <int>(AppConfiguration.Instance.MasivianBD).GetConnectionMananager())
{
dapper.AddParameter("IdRuleta", idRuleta);
var list = dapper.GetList(StoreProcedures.SP_ActiveRuletas);
if (list != null && list.Any())
{
return(ResponseManager <int> .ResponseOK(0, list));
}
return(ResponseManager <int> .ResponseInternalServerError("Error al activar ruleta"));
}
}
catch (System.Exception ex)
{
Log.Error(ex, ex.Message);
return(ResponseManager <int> .ResponseInternalServerError(ex.Message));
}
}
public void Insert(TNotice obj)
{
_objConnectionFactory.AddParameter("@pTitleNotice", obj.TitleNotice);
_objConnectionFactory.AddParameter("@pContentNotice", obj.ContentNotice);
obj.IdNotice = (byte)_objConnectionFactory.ExecuteStoredProcedureScalar("spInsertNotice");
foreach (var item in obj.Departments)
{
_objConnectionFactory.AddParameter("@pIdNotice", obj.IdNotice);
_objConnectionFactory.AddParameter("@pIdDepartment", item.IdDepartment);
_objConnectionFactory.ExecuteStoredProcedureNonQuery("spInsertDepartmentNotice");
}
}
public void Delete(int id)
{
_objConnectionFactory.AddParameter("@pIdFrequency", id);
_objConnectionFactory.ExecuteStoredProcedureNonQuery("spDeleteFrequency");
}
public void Delete(int id)
{
_objConnectionFactory.AddParameter("@pIdClassEBD", id);
_objConnectionFactory.ExecuteStoredProcedureNonQuery("spDeleteClass");
}
public void Delete(int Id)
{
_objConnectionFactory.AddParameter("@pIdPeriod", Id);
_objConnectionFactory.ExecuteStoredProcedureNonQuery("spDeletePeriod");
}