public IActionResult GetPartiesInfoLab(LaboratoryParties laboratoryParties)
{
if (ModelState.IsValid)
{
GetPartiesInfoLab(laboratoryParties.NumberOfDocument);
return(View());
}
return(View(ModelState.ErrorCount));
}
public IActionResult GetPartiesInfoLab(string numberOfDocument)
{
try
{
LaboratoryParties laboratoryParties = new LaboratoryParties();
DataSet datasetParties = GetParties();
List <SelectListItem> selectListItemsParties = new List <SelectListItem>();
selectListItemsParties.Add(new SelectListItem {
Value = null, Text = "-- Не выбрано --"
});
foreach (DataRow item in datasetParties.Tables[0].Rows)
{
selectListItemsParties.Add(new SelectListItem {
Value = item["Name"].ToString(), Text = item["Name"].ToString()
});
}
laboratoryParties.listyParties = selectListItemsParties;
laboratoryParties.NumberOfDocument = numberOfDocument;
DataTable tdbl = new DataTable();
using (SqlConnection sqlConnection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection2")))
{
sqlConnection.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter("BasApp_Laboratory_GetDataOfParty", sqlConnection);
sqlDA.SelectCommand.Parameters.AddWithValue("incomin_NumberOfDocument", numberOfDocument ??= "Null");
sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDA.Fill(tdbl);
}
laboratoryParties.listil = tdbl;
return(View(laboratoryParties));
}
catch (SqlException ex)
{
throw ex;
}
}
