public async Task <IActionResult> CreateWarehouseFieldsLab([Bind("Id,TypeOfMaterial,NameOfTypeMaterial,Provider,Manufacturer")] WarehouseLab warehouse) { 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", warehouse.TypeOfMaterial); command.Parameters.AddWithValue("in_NameOfTypeMaterial", warehouse.NameOfTypeMaterial); command.Parameters.AddWithValue("in_Provider", warehouse.Provider); command.Parameters.AddWithValue("in_Manufacturer", warehouse.Manufacturer); command.Parameters.AddWithValue("in_SubsType", 2); await command.ExecuteNonQueryAsync(); } } catch (SqlException ex) { throw ex; } return(RedirectToAction(nameof(CreateWarehouseFieldsLab))); } return(View(ModelState.ErrorCount)); }
public async Task <IActionResult> WarehouseViewLab(WarehouseLab warehouse) { if (ModelState.IsValid) { await WarehouseViewLab(warehouse.WarehouseSubs); return(View()); } return(View(ModelState.ErrorCount)); }
public async Task <IActionResult> WarehouseViewLab(bool loc_SubsType) { if (ModelState.IsValid) { WarehouseLab warehouse = new WarehouseLab(); 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", loc_SubsType == true ? 3 : 2); 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", loc_SubsType == true ? 3 : 2); sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDA.Fill(tdbl); DiffDataSets.Add(tdbl); sqlConnection.Close(); } } warehouse.listil = DiffDataSets; warehouse.list = DiffTypes.ToArray(); return(View(warehouse)); } return(View(ModelState.ErrorCount)); }
public IActionResult CreateWarehouseFieldsLab() { WarehouseLab warehouse = new WarehouseLab(); 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(warehouse)); }
public IActionResult CreateWarehouseFieldTypeLab() { WarehouseLab warehouse = new WarehouseLab(); return(View(warehouse)); }