// 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();
}
}
