public AddContragentResultModel AddContragent([FromBody] AddContragentBindingModel model) { var contragent = new AddContragentResultModel(); if (ModelState.IsValid) { try { using (SqlConnection connection = new SqlConnection(ConnectionStrings.connectionString)) { SqlCommand command = new SqlCommand(ContragentQueries.AddContragentToUser, connection); command.Parameters.AddWithValue("@inContragentName", model.ContragentName); command.Parameters.AddWithValue("@inAdress", model.Adress); command.Parameters.AddWithValue("@inEmail", model.Email); command.Parameters.AddWithValue("@inVatNumber", model.VatNumber); command.Parameters.AddWithValue("@inUserId", model.UserId); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string name = (string)(reader["ContragentName"] == DBNull.Value ? "" : reader["ContragentName"].ToString()); string adress = (string)(reader["Adress"] == DBNull.Value ? "" : reader["Adress"].ToString()); string mail = (string)(reader["Email"] == DBNull.Value ? "" : reader["Email"].ToString()); string vatNum = (string)(reader["VatNumber"] == DBNull.Value ? "" : reader["VatNumber"].ToString()); int userId = (int)(reader["UserId"] == DBNull.Value ? -1 : int.Parse(reader["UserId"].ToString())); int code = (int)(reader["Code"] == DBNull.Value ? -1 : int.Parse(reader["Code"].ToString())); string message = (string)(reader["Msg"] == DBNull.Value ? "" : (reader["Msg"].ToString())); contragent = new AddContragentResultModel() { ContragentName = name, Adress = adress, Email = mail, VatNumber = vatNum, UserId = userId }; } } } catch (Exception ex) { var error = ex.Message; } } return(contragent); }
public ActionResult AddContragent(AddContragentBindingModel model) { if (ModelState.IsValid) { var newContragent = new AddContragentResultModel { ContragentName = model.ContragentName, Adress = model.Adress, Email = model.Email, VatNumber = model.VatNumber, UserId = model.UserId }; try { using (var client = new HttpClient()) { var postTask = client.PostAsJsonAsync("http://localhost:52680/contragent/AddContragent/", newContragent); postTask.Wait(); var result = postTask.Result; if (result.IsSuccessStatusCode) { var readTask = result.Content.ReadAsAsync <AddContragentResultModel>(); readTask.Wait(); newContragent = readTask.Result; ViewBag.Title = "Successfully added contragent"; } else { ModelState.AddModelError(string.Empty, "error"); } } } catch (Exception ex) { var exception = ex; } } return(RedirectToAction("Index", "Home")); }