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