/// <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"); }