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