public IHttpActionResult setCreateAddress(AddressTO adrs)
{
int codError = 1;
string msjError = "";
AddressServices objServicio = new AddressServices();
var result = objServicio.setCreateAddress(adrs, ref codError, ref msjError);
if (codError == 1)
{
return(Ok(result));
}
return(BadRequest(msjError));
}
public int setCreateAddress(AddressTO adrs, ref int codError, ref string msjError)
{
List <AddressTO> objList = new List <AddressTO>();
try
{
using (SqlConnection sql = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("createAddress", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@idUser", SqlDbType.Int).Value = adrs.IdUser;
cmd.Parameters.Add("@idStatus", SqlDbType.Int).Value = adrs.IdStatus;
cmd.Parameters.Add("@idCommune", SqlDbType.Int).Value = adrs.IdCommune;
cmd.Parameters.Add("@CEP", SqlDbType.BigInt).Value = adrs.CEP;
cmd.Parameters.Add("@address", SqlDbType.VarChar).Value = adrs.Address;
sql.Open();
var ds = new DataSet();
var da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds.Tables.Count == 1)
{
List <ResultTO> error = ds.Tables[0].AsEnumerable()
.Select(dataRow => new ResultTO
{
Result = dataRow.Field <int>("result"),
Msg = dataRow.Field <string>("msg")
}).ToList();
codError = 1;
msjError = error.FirstOrDefault().Msg;
return(0);
}
List <ResultTO> results = ds.Tables[1].AsEnumerable()
.Select(dataRow => new ResultTO
{
Result = dataRow.Field <int>("result"),
Msg = dataRow.Field <string>("msg")
}).ToList();
objList = ds.Tables[0].AsEnumerable()
.Select(dataRow => new AddressTO
{
IdAddress = dataRow.Field <int>("idAddress")
}).ToList();
}
}
return(objList.FirstOrDefault().IdAddress);
}
catch (Exception e)
{
codError = 0;
msjError = e.Message;
return(0);
}
}
