private static ClsRoulette MapRoulette(DataRow DrFilaDatos) { ClsRoulette clsRoulette = new ClsRoulette(); clsRoulette.InIdRoulette = int.Parse(DrFilaDatos["InIdRoulette"].ToString()); clsRoulette.StrRouletteName = DrFilaDatos["VcRouletteName"].ToString(); clsRoulette.BlStatus = Convert.ToBoolean(DrFilaDatos["BtStatus"].ToString()); return(clsRoulette); }
public async Task <ClsRoulette> CreateRoulette(ClsRoulette clsRoulette) { SqlConnection sql = new SqlConnection(_connectionString); ClsRoulette ObjRoulette = new ClsRoulette(); var datos = new DataSet(); var sqlDataAdapter = new SqlDataAdapter("dbo.USP_CreateRoulette", _connectionString); SqlParameter[] parametro = { new SqlParameter { ParameterName = "@VcRouletteName", Value = clsRoulette.StrRouletteName } }; try { sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDataAdapter.SelectCommand.CommandTimeout = 0; sqlDataAdapter.SelectCommand.Parameters.AddRange(parametro); sqlDataAdapter.SelectCommand.Connection.Open(); await Task.Run(() => sqlDataAdapter.Fill(datos)); foreach (DataRow item in datos.Tables[0].Rows) { ObjRoulette.InIdRoulette = int.Parse(item[0].ToString()); ObjRoulette.StrRouletteName = clsRoulette.StrRouletteName; } } catch (Exception Ex) { throw new Exception(Ex.Message); } finally { sqlDataAdapter.SelectCommand.Connection.Close(); sqlDataAdapter.SelectCommand.Dispose(); } return(ObjRoulette); }
public async Task <ClsRoulette> UpdateMunicipioCobertura([FromBody] DtoAddRoulette dtoAddRoulette) { ClsRoulette clsRoulette = _mapper.Map <ClsRoulette>(dtoAddRoulette); return(await _rouletteRepository.CreateRoulette(clsRoulette)); }