// dodanie nowej operacji public bool AddNewOperation(NewOperation newOp) { using (SqlCommand sqlCmd = new SqlCommand()) { DateTime addOpDate = DateTime.Now; DateTime zeroDate = new DateTime(1999, 01, 01); sqlCmd.CommandText = "INSERT INTO Operations (Employee_Id, Operation, GodzinaRozkladowa, FlightNb, AirPort, " + "Pax, Gate, PPS, Bus, RadioGate, RadioNeon, Created, Accepted, " + "StartLoad, StartDrive, StartUnload, EndOp, Finished) " + "VALUES (@employee_Id, @operation, @godzinaRozkladowa, @flightNb, @airPort, " + "@pax, @gate, @pps, @bus, @radioGate, @radioNeon, @created, @accepted, " + "@startLoad, @startDrive, @startUnload, @endOp, @finished)"; sqlCmd.Parameters.AddWithValue("@employee_Id", 2); sqlCmd.Parameters.AddWithValue("@operation", newOp.Operation); sqlCmd.Parameters.AddWithValue("@godzinaRozkladowa", newOp.GodzinaRozkładowa); sqlCmd.Parameters.AddWithValue("@flightNb", newOp.FlightNb); sqlCmd.Parameters.AddWithValue("@airPort", newOp.AirPort); sqlCmd.Parameters.AddWithValue("@pax", newOp.Pax); sqlCmd.Parameters.AddWithValue("@gate", newOp.Gate); sqlCmd.Parameters.AddWithValue("@pps", newOp.PPS); sqlCmd.Parameters.AddWithValue("@bus", newOp.Bus); sqlCmd.Parameters.AddWithValue("@radioGate", newOp.RadioGate); sqlCmd.Parameters.AddWithValue("@radioNeon", newOp.RadioNeon); sqlCmd.Parameters.AddWithValue("@created", addOpDate); sqlCmd.Parameters.AddWithValue("@accepted", zeroDate); sqlCmd.Parameters.AddWithValue("@startLoad", zeroDate); sqlCmd.Parameters.AddWithValue("@startDrive", zeroDate); sqlCmd.Parameters.AddWithValue("@startUnload", zeroDate); sqlCmd.Parameters.AddWithValue("@endOp", zeroDate); sqlCmd.Parameters.AddWithValue("@finished", 0); try { dal.QueryExecution(sqlCmd); sqlCmd.CommandText = ""; sqlCmd.Parameters.Clear(); result = true; } catch (Exception AddNewOperation_ex1) { result = false; } if (result) { sqlCmd.CommandText = "UPDATE Vehicles SET Work_Status = 1 WHERE VehicleNb = @busNb"; sqlCmd.Parameters.AddWithValue("@busNb", newOp.BusNb); try { dal.QueryExecution(sqlCmd); sqlCmd.Dispose(); result = true; } catch (Exception AddNewOperation_ex2) { result = false; } } } return(result); }
//Dodanie nowej operacji protected void Gv_Alocator_RowCommand(object sender, GridViewCommandEventArgs e) { bool success = false; if (e.CommandName.Equals("Insert")) { NewOperation newOp = new NewOperation(); DateTime zeroDate = new DateTime(1999, 01, 01); DateTime dateTime = new DateTime(); DropDownList ddl_OperationAdd = (DropDownList)gv_Alocator.FooterRow.FindControl("ddl_operationAdd"); newOp.Operation = Convert.ToInt32(ddl_OperationAdd.SelectedValue); ddl_OperationAdd.Dispose(); TextBox tb_FlightNbAdd = (TextBox)gv_Alocator.FooterRow.FindControl("tb_flightNbAdd"); newOp.FlightNb = tb_FlightNbAdd.Text; tb_FlightNbAdd.Dispose(); TextBox tb_GodzinaRozkładowaAdd = (TextBox)gv_Alocator.FooterRow.FindControl("tb_godzinaRozkładowaAdd"); if (!DateTime.TryParseExact(tb_GodzinaRozkładowaAdd.Text, "HH:mm", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal, out dateTime)) { // w przypadku błędu konwersji daty Response.Write("<script> alert('Błąd - format daty wydaje się być nieprawidłowy' ) </script>"); return; } newOp.GodzinaRozkładowa = dateTime; tb_GodzinaRozkładowaAdd.Dispose(); DropDownList ddl_AirPortAdd = (DropDownList)gv_Alocator.FooterRow.FindControl("ddl_airPortAdd"); newOp.AirPort = Convert.ToInt32(ddl_AirPortAdd.SelectedValue); ddl_AirPortAdd.Dispose(); TextBox tb_PaxAdd = (TextBox)gv_Alocator.FooterRow.FindControl("tb_paxAdd"); newOp.Pax = Convert.ToInt32(tb_PaxAdd.Text); tb_PaxAdd.Dispose(); DropDownList ddl_GateAdd = (DropDownList)gv_Alocator.FooterRow.FindControl("ddl_gateAdd"); newOp.Gate = Convert.ToInt32(ddl_GateAdd.SelectedValue); ddl_GateAdd.Dispose(); DropDownList ddl_PpsAdd = (DropDownList)gv_Alocator.FooterRow.FindControl("ddl_ppsAdd"); newOp.PPS = Convert.ToInt32(ddl_PpsAdd.SelectedValue); ddl_PpsAdd.Dispose(); DropDownList ddl_BusAdd = (DropDownList)gv_Alocator.FooterRow.FindControl("ddl_busAdd"); newOp.Bus = Convert.ToInt32(ddl_BusAdd.SelectedValue); ddl_BusAdd.Dispose(); TextBox tb_RadioGateAdd = (TextBox)gv_Alocator.FooterRow.FindControl("tb_radioGateAdd"); newOp.RadioGate = tb_RadioGateAdd.Text; tb_RadioGateAdd.Dispose(); TextBox tb_RadioNeonAdd = (TextBox)gv_Alocator.FooterRow.FindControl("tb_radioNeonAdd"); newOp.RadioNeon = tb_RadioNeonAdd.Text; tb_RadioNeonAdd.Dispose(); newOp.BusNb = ddl_BusAdd.SelectedItem.ToString(); try { success = bl.AddNewOperation(newOp); } catch (Exception Gv_Alocator_RowCommand_ex) { Response.Write("<script> alert('Błąd - Gv_Alocator_RowCommand()' ) </script>"); } } else if (e.CommandName.Equals("Edit")) { btn_addNewOperation.Visible = true; gv_Alocator.ShowFooter = false; BindGrid(); } if (success) { btn_addNewOperation.Visible = true; gv_Alocator.ShowFooter = false; AlocatorHomeTimer.Enabled = true; BindGrid(); } }