public GenericAnswer OpenRulette(RuletteModel dataRulette)
{
GenericAnswer response = new GenericAnswer();
SqlParameter[] parameters =
{
new SqlParameter {
Value = dataRulette.idRulette, ParameterName = RuletteMapping.idRulette
},
new SqlParameter {
Value = Enum.Status.Open, ParameterName = RuletteMapping.ruletteStatus
},
};
string messageError = string.Empty;
connectionManager.AcctionRun(updateRulette, ref messageError, parameters);
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
response.error = "Apertura Exitosa";
response.entity = dataRulette;
response.successful = true;
return(response);
}
public GenericAnswer CreateRulette(RuletteModel dataRulette)
{
GenericAnswer response = new GenericAnswer();
SqlParameter[] parameters =
{ new SqlParameter {
Value = Enum.Status.Create, ParameterName = RuletteMapping.ruletteStatus
},
new SqlParameter {
SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output, ParameterName = RuletteMapping.OutIdRulette
} };
string messageError = string.Empty;
connectionManager.AcctionRun(insertRulette, ref messageError, parameters);
if (Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString()) > 0)
{
dataRulette.idRulette = Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString());
}
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
response.error = messageError;
response.entity = dataRulette;
response.successful = true;
return(response);
}
public GenericAnswer CreateEntidad(EntidadesModel entity)
{
GenericAnswer response = new GenericAnswer();
SqlParameter[] parameters =
{
new SqlParameter {
Value = entity.nombre, ParameterName = "@nombre"
},
new SqlParameter {
Value = entity.direccion, ParameterName = "@direccion"
},
new SqlParameter {
Value = entity.telefono, ParameterName = "@telefono"
},
new SqlParameter {
Value = entity.ciudad, ParameterName = "@ciudad"
},
new SqlParameter {
Value = entity.pais, ParameterName = "@pais"
},
new SqlParameter {
Value = entity.correo, ParameterName = "@correo"
},
new SqlParameter {
SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output, ParameterName = "@OutIdEntidad"
}
};
string messageError = string.Empty;
connectionManager.AcctionRun(insertEntidad, ref messageError, parameters);
if (Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString()) > 0)
{
entity.id = Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString());
}
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
response.error = messageError;
response.entity = entity;
response.successful = true;
return(response);
}
public GenericAnswer OpenBet(RuletteModel dataRulette, BetModel dataBet, GamblerModel dataGambler)
{
GenericAnswer response = new GenericAnswer();
string colorBet = string.Empty;
if (dataBet.cashBet > Convert.ToInt32(Enum.Cash.MaxCash))
{
response.error = "Supera el monto máximo de apuesta = " + Enum.Cash.MaxCash;
return(response);
}
SqlParameter[] parameters =
{
new SqlParameter {
Value = dataRulette.idRulette, ParameterName = RuletteMapping.idRulette
},
new SqlParameter {
Value = dataGambler.idGambler, ParameterName = GamblerMapping.idGambler
},
new SqlParameter {
Value = dataBet.cashBet, ParameterName = BetMapping.cashBet
},
new SqlParameter {
Value = dataBet.numberBet, ParameterName = BetMapping.numberBet
},
new SqlParameter {
Value = dataBet.colorBet, ParameterName = BetMapping.colorBet
},
};
string messageError = string.Empty;
connectionManager.AcctionRun(updateRulette, ref messageError, parameters);
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
response.error = "Apertura Exitosa";
response.entity = dataRulette;
response.successful = true;
return(response);
}
public GenericAnswer UpdateEntidad(EntidadesModel entity)
{
GenericAnswer response = new GenericAnswer();
SqlParameter[] parameters =
{
new SqlParameter {
Value = entity.id, ParameterName = "@id"
},
new SqlParameter {
Value = entity.nombre, ParameterName = "@nombre"
},
new SqlParameter {
Value = entity.direccion, ParameterName = "@direccion"
},
new SqlParameter {
Value = entity.telefono, ParameterName = "@telefono"
},
new SqlParameter {
Value = entity.ciudad, ParameterName = "@ciudad"
},
new SqlParameter {
Value = entity.pais, ParameterName = "@pais"
},
new SqlParameter {
Value = entity.correo, ParameterName = "@correo"
},
};
string messageError = string.Empty;
connectionManager.AcctionRun(updateEntidad, ref messageError, parameters);
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
response.error = messageError;
response.entity = entity;
response.successful = true;
return(response);
}
public GenericAnswer ClosedRulette(RuletteModel dataRulette)
{
GenericAnswer response = new GenericAnswer();
SqlParameter[] parameters =
{
new SqlParameter {
Value = dataRulette.idRulette, ParameterName = RuletteMapping.idRulette
},
new SqlParameter {
Value = Enum.Status.Closed, ParameterName = RuletteMapping.ruletteStatus
},
};
string messageError = string.Empty;
connectionManager.AcctionRun(updateRulette, ref messageError, parameters);
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
GenericAnswer getBet = GetObjRulettes(dataRulette);
if (!getBet.successful)
{
response.error = getBet.error;
response.successful = false;
return(response);
}
response.error = getBet.error;
response.entity = getBet.entity;
response.successful = true;
return(response);
}
public GenericAnswer CreateEmpleado(EmpleadosModel entity)
{
GenericAnswer response = new GenericAnswer();
SqlParameter[] parameters =
{
new SqlParameter {
Value = entity.nombres, ParameterName = "@nombres"
},
new SqlParameter {
Value = entity.apellidos, ParameterName = "@apellidos"
},
new SqlParameter {
Value = entity.genero, ParameterName = "@genero"
},
new SqlParameter {
Value = entity.edad, ParameterName = "@edad"
},
new SqlParameter {
Value = entity.cargo, ParameterName = "@cargo"
},
new SqlParameter {
Value = entity.salario, ParameterName = "@salario"
},
new SqlParameter {
Value = entity.direccion, ParameterName = "@direccion"
},
new SqlParameter {
Value = entity.telefono, ParameterName = "@telefono"
},
new SqlParameter {
Value = entity.correo, ParameterName = "@correo"
},
new SqlParameter {
Value = entity.tipoDocumento, ParameterName = "@tipoDocumento"
},
new SqlParameter {
Value = entity.documento, ParameterName = "@documento"
},
new SqlParameter {
Value = entity.idEntidad, ParameterName = "@idEntidad"
},
new SqlParameter {
Value = entity.idUsuario, ParameterName = "@idUsuario"
},
new SqlParameter {
SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output, ParameterName = "@OutIdEmpleado"
}
};
string messageError = string.Empty;
connectionManager.AcctionRun(insertEmpleado, ref messageError, parameters);
if (Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString()) > 0)
{
entity.id = Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString());
}
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
response.error = messageError;
response.entity = entity;
response.successful = true;
return(response);
}
public GenericAnswer UpdateEmpleado(EmpleadosModel entity)
{
GenericAnswer response = new GenericAnswer();
SqlParameter[] parameters =
{
new SqlParameter {
Value = entity.id, ParameterName = "@id"
},
new SqlParameter {
Value = entity.nombres, ParameterName = "@nombres"
},
new SqlParameter {
Value = entity.apellidos, ParameterName = "@apellidos"
},
new SqlParameter {
Value = entity.genero, ParameterName = "@genero"
},
new SqlParameter {
Value = entity.edad, ParameterName = "@edad"
},
new SqlParameter {
Value = entity.cargo, ParameterName = "@cargo"
},
new SqlParameter {
Value = entity.salario, ParameterName = "@salario"
},
new SqlParameter {
Value = entity.direccion, ParameterName = "@direccion"
},
new SqlParameter {
Value = entity.telefono, ParameterName = "@telefono"
},
new SqlParameter {
Value = entity.correo, ParameterName = "@correo"
},
new SqlParameter {
Value = entity.tipoDocumento, ParameterName = "@tipoDocumento"
},
new SqlParameter {
Value = entity.documento, ParameterName = "@documento"
},
new SqlParameter {
Value = entity.idEntidad, ParameterName = "@idEntidad"
},
new SqlParameter {
Value = entity.idUsuario, ParameterName = "@idUsuario"
},
};
string messageError = string.Empty;
connectionManager.AcctionRun(updateEmpleado, ref messageError, parameters);
if (!string.IsNullOrEmpty(messageError))
{
response.error = messageError;
response.successful = false;
return(response);
}
response.error = messageError;
response.entity = entity;
response.successful = true;
return(response);
}
