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