/// <summary>Initializes a new instance of the <see cref="MissionForm"/> class.</summary>
/// <param name="missionModel">The mission model.</param>
public MissionForm(MissionModel missionModel = null)
{
InitializeComponent();
if (missionModel != null)
{
this.missionModel = missionModel;
this.AddStuff();
}
foreach (ShipModel shipModel in shipManager.GetAllShips())
{
cbShip.Items.Add(shipModel);
}
}
/// <summary></summary>
/// <param name="description">The description.</param>
/// <param name="x">The x.</param>
/// <param name="y">The y.</param>
/// <param name="startDate">The start date.</param>
/// <param name="endDate">The end date.</param>
/// <param name="ship">The ship.</param>
/// <returns>The <see cref="MissionModel"/>.</returns>
public MissionModel CreateHopeMission(string description, int x, int y, DateTime startDate, DateTime endDate, ShipModel ship)
{
MissionModel missionModel = new MissionModel(0, ship.ID, description, startDate, x, y, MissionModel.MissionType.Hope, endDate);
try
{
string query =
string.Format(
"INSERT INTO MISSION (ID, SHIPID, STARTDATE, DISCRIPTION, X, Y, ACTIVE, MISSIONTYPE, APPROVED, ENDDATE) "
+ "VALUES (seq_mission.nextval, '{0}', TO_TIMESTAMP('{1} 11:39:02.070000000', 'YYYY-MM-DD HH24:MI:SS.FF'), '{2}', '{3}', '{4}', '0', 'HOPE', '0', TO_DATE('{5} 11:39:31', 'YYYY-MM-DD HH24:MI:SS'))",
missionModel.ShipId, missionModel.StartDate.ToShortDateString(), missionModel.Description, missionModel.X, missionModel.Y, missionModel.EndDate.ToShortDateString());
OracleCommand command = new OracleCommand(query, DatabaseSettings.Connection);
command.ExecuteNonQuery();
DatabaseSettings.Commit();
return missionModel;
}
catch (Exception)
{
return null;
}
}
/// <summary></summary>
/// <param name="description">The description.</param>
/// <param name="x">The x.</param>
/// <param name="y">The y.</param>
/// <param name="policeNeeded">The police needed.</param>
/// <returns>The <see cref="MissionModel"/>.</returns>
public MissionModel CreateSinMission(string description, int x, int y, int policeNeeded)
{
ShipModel shipModel = shipManager.GetClosestShip(x, y, policeNeeded);
if (shipModel == null)
{
return null;
}
MissionModel missionModel = new MissionModel(0, shipModel.ID, DateTime.Today, description, x, y, MissionModel.MissionType.Sin, policeNeeded);
string test = missionModel.StartDate.ToShortDateString();
try
{
string query = string.Format("Insert into MISSION (ID,SHIPID,STARTDATE,DISCRIPTION,X,Y,ACTIVE,RAPPORT,MISSIONTYPE,POLICENEEDED,APPROVED,ENDDATE) values (seq_mission.nextval,'{0}',TO_TIMESTAMP('{1} 09:57:08.493000000', 'YYYY-MM-DD HH24:MI:SS.FF'),'{2}','{3}','{4}','1',null,'{5}','{6}','0',null)", missionModel.ShipId, missionModel.StartDate.ToShortDateString(), missionModel.Description, missionModel.X, missionModel.Y, missionModel.MissionTypeEnum, missionModel.PoliceNeeded);
OracleCommand command = new OracleCommand(query, DatabaseSettings.Connection);
command.ExecuteNonQuery();
DatabaseSettings.Commit();
return missionModel;
}
catch (Exception)
{
return null;
}
}
/// <summary></summary>
/// <returns>The <see cref="List"/>.</returns>
public List<MissionModel> GetAllActiveMissions()
{
List<MissionModel> missions = new List<MissionModel>();
MissionModel missionModel = null;
try
{
string query = "select * from mission where active != 1";
OracleCommand command = new OracleCommand(query, DatabaseSettings.Connection);
OracleDataReader reader = command.ExecuteReader();
// 0 1 2 3 4 5 6 7 8 9
// 4 28 26-06-15 11:39:02,070000000 adsd 3 3 0 HOPE 0 26-06-2015 11:39
while (reader.Read())
{
MissionModel.MissionType missionType;
ShipTypeModel.ShipTypeEnum.TryParse(reader[8].ToString(), true, out missionType);
if (missionType == MissionModel.MissionType.Hope)
{
missionModel = new MissionModel(
Convert.ToInt32(reader[0]),
Convert.ToInt32(reader[1]),
reader[3].ToString(),
Convert.ToDateTime(reader[2]),
Convert.ToInt32(reader[4]),
Convert.ToInt32(reader[5]),
missionType,
Convert.ToDateTime(reader[11]));
}
missions.Add(missionModel);
}
}
catch (Exception)
{
return null;
}
return missions;
}
/// <summary></summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void button3_Click(object sender, EventArgs e)
{
if (rbHope.Checked)
{
if (cbShip.SelectedItem == null || string.IsNullOrEmpty(tbDescription.Text) || nudX.Value == 0 || nudY.Value == 0)
{
MessageBox.Show("Niet alle gegevens zijn correct ingevuld");
return;
}
this.missionModel = missionManager.CreateHopeMission(
tbDescription.Text,
Convert.ToInt32(nudX.Value),
Convert.ToInt32(nudY.Value),
dtpStart.Value,
dtpEnd.Value,
(ShipModel)cbShip.SelectedItem);
this.AddStuff();
}
if (rbSin.Checked)
{
if (string.IsNullOrEmpty(tbDescription.Text) || nudX.Value == 0 || nudY.Value == 0 || nudPoliceNeeded.Value == 0)
{
MessageBox.Show("Niet alle gegevens zijn correct ingevuld");
return;
}
this.missionModel = missionManager.CreateSinMission(tbDescription.Text, Convert.ToInt32(nudX.Value), Convert.ToInt32(nudY.Value), Convert.ToInt32(nudPoliceNeeded.Value));
if (this.missionModel != null)
{
this.AddStuff();
MessageBox.Show("Missie toegevoegd");
}
else
{
MessageBox.Show("Er ging iets mis");
}
}
}
