public async Task <IActionResult> CreateWarehouseFieldType([Bind("Id,TypeOfMaterial,NameOfTypeMaterial,Provider,Manufacturer")] Warehouse135Model warehouse135) { if (ModelState.IsValid) { try { using (SqlConnection sqlConnection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection2"))) { sqlConnection.Open(); SqlCommand command = new SqlCommand("BasApp_Warehouse_Add", sqlConnection) { CommandType = CommandType.StoredProcedure }; command.Parameters.AddWithValue("in_TypeOfMaterial", warehouse135.TypeOfMaterial); command.Parameters.AddWithValue("in_NameOfTypeMaterial", warehouse135.NameOfTypeMaterial); command.Parameters.AddWithValue("in_Provider", warehouse135.Provider); command.Parameters.AddWithValue("in_Manufacturer", warehouse135.Manufacturer); command.Parameters.AddWithValue("in_SubsType", 1); await command.ExecuteNonQueryAsync(); } } catch (SqlException ex) { throw ex; } return(RedirectToAction(nameof(CreateWarehouseFieldType))); } return(View(ModelState.ErrorCount)); }
public async Task <IActionResult> WarehouseViewAll() { if (ModelState.IsValid) { Warehouse135Model warehouse135 = new Warehouse135Model(); List <string> DiffTypes = new List <string>(); using (SqlConnection sqlConnection1 = new SqlConnection(_configuration.GetConnectionString("DefaultConnection2"))) { sqlConnection1.Open(); SqlCommand cmd = new SqlCommand("BasApp_Warehouse_GetDistinct", sqlConnection1) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("in_SubsType", 1); using (SqlDataReader reader = await cmd.ExecuteReaderAsync()) { while (reader.Read()) { DiffTypes.Add(Convert.ToString(reader.GetString(0))); } } sqlConnection1.Close(); } List <DataTable> DiffDataSets = new List <DataTable>(); using (SqlConnection sqlConnection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection2"))) { foreach (var item in DiffTypes) { DataTable tdbl = new DataTable(); sqlConnection.Open(); SqlDataAdapter sqlDA = new SqlDataAdapter("BasApp_Warehouse_ViewAllData", sqlConnection); sqlDA.SelectCommand.Parameters.AddWithValue("in_TypeOfMaterial", item); sqlDA.SelectCommand.Parameters.AddWithValue("in_SubsType", 1); sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDA.Fill(tdbl); DiffDataSets.Add(tdbl); sqlConnection.Close(); } } warehouse135.listil = DiffDataSets; warehouse135.list = DiffTypes.ToArray(); return(View(warehouse135)); } return(View(ModelState.ErrorCount)); }
public IActionResult CreateWarehouseFields() { Warehouse135Model warehouse135 = new Warehouse135Model(); DataSet dataset = GetTypeOfMaterialWarehouse(); List <SelectListItem> selectListItems = new List <SelectListItem>(); foreach (DataRow item in dataset.Tables[0].Rows) { selectListItems.Add(new SelectListItem { Value = item["TypeOfMaterial"].ToString(), Text = item["TypeOfMaterial"].ToString() }); } ViewBag.TypeList = selectListItems; return(View(warehouse135)); }
public IActionResult CreateWarehouseFieldType() { Warehouse135Model warehouse135 = new Warehouse135Model(); return(View(warehouse135)); }