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