private void UpdateDetail()
{
try
{
var sv = new Journey1SoapClient();
var sv1 = new ServicePortNationalSoapClient();
int id = (int)gridTrip.GetFocusedRowCellValue("ID");
var trip = sv.GetTripId(id);
#region Detail
cbxBeginpo.EditValue = trip.BeginPosition;
cbxEndPo.EditValue = trip.EndPosition;
dateTimeBegin.Value = trip.TimeBegin.Value;
dateTimeEnd.Value = trip.TimeEnd.Value;
txtTimeProvide.Text = trip.TimeProvide.ToString();
bool status = (bool)trip.Status;
if (status == true)
{
cbxSatus.Text = "Complete";
btnUpdatePosition.Enabled = false;
}
else
{
cbxSatus.Text = "Not Complete";
btnUpdatePosition.Enabled = true;
}
#endregion
#region Load Map
((MapItemStorage)vectorItemsLayer1.Data).Items.Clear();
var portBegin = sv1.GetPortByID((int)trip.BeginPosition);
var portEnd = sv1.GetPortByID((int)trip.EndPosition);
ItemStorage.Items.Add(new MapPushpin()
{
Location = new GeoPoint((float)portBegin.Latitude, (float)portBegin.Longitude), Text = "Begin"
});
ItemStorage.Items.Add(new MapPushpin()
{
Location = new GeoPoint((float)portEnd.Latitude, (float)portEnd.Longitude), Text = "End"
});
map.CenterPoint = new GeoPoint((float)portBegin.Latitude, (float)portBegin.Longitude);
map.Zoom(7);
LoadMap(id);
#endregion
}
catch
{
}
}
private void btnUpdatePosition_Click(object sender, EventArgs e)
{
var sv = new Journey1SoapClient();
int id = (int)gridTrip.GetFocusedRowCellValue("ID");
GUI.UpdatePosition form = new GUI.UpdatePosition(id);
form.ShowDialog();
}
private void LoadUnitControl()
{
var sv = new Journey1SoapClient();
cbxBeginpo.Properties.DataSource = sv.GetAllPort().Select(p => new { p.ID, p.Name }).ToList();
cbxBeginpo.Properties.DisplayMember = "Name";
cbxBeginpo.Properties.ValueMember = "ID";
cbxEndPo.Properties.DataSource = sv.GetAllPort().Select(p => new { p.ID, p.Name }).ToList();
cbxEndPo.Properties.DisplayMember = "Name";
cbxEndPo.Properties.ValueMember = "ID";
//ClearControl();
}
private void btnAdd_Click(object sender, EventArgs e)
{
var sv = new Journey1SoapClient();
if (btnAdd.Text == "Add")
{
btnUpdate.Enabled = false;
btnAdd.Text = "Save";
btnExit.Text = "Cancel";
ClearControl();
UnlockControl();
return;
}
if (btnAdd.Text == "Save")
{
if (txtTimeProvide.Text == "")
{
MessageBox.Show("You must enter all fields", "notification");
return;
}
else
{
btnAdd.Text = "Add";
btnExit.Text = "Exit";
LockControl();
bool status = false;
int idbeginPo = (int)cbxBeginpo.EditValue;
int idendPo = (int)cbxEndPo.EditValue;
float timepro = float.Parse(txtTimeProvide.Text);
// bool status = false;
sv.inserttrip(IDboat, idbeginPo, idendPo, timepro, dateTimeBegin.Value, dateTimeEnd.Value, status);
if (status == false)
{
var sv1 = new Position1SoapClient();
var sv2 = new Journey1SoapClient();
var sv3 = new ServicePortNationalSoapClient();
var journeyNew = sv2.GetTrip(IDboat).OrderByDescending(p => p.ID).FirstOrDefault();
var port = sv3.GetPortByID((int)journeyNew.BeginPosition);
sv1.UpdatePosition(journeyNew.ID, (float)(port.Longitude), (float)(port.Latitude), DateTime.Now, port.Ocean);
}
MessageBox.Show("Add successfully!");
LoaDgvTrip(IDboat);
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
var sv = new Journey1SoapClient();
int idtrip = (int)gridTrip.GetFocusedRowCellValue("ID");
var trip = sv.GetTripId(idtrip);
if (btnUpdate.Text == "Update")
{
btnUpdate.Text = "Save";
btnExit.Text = "Cancel";
UnlockControl();
return;
}
if (btnUpdate.Text == "Save")
{
btnUpdate.Text = "Update";
btnExit.Text = "Exit";
LockControl();
bool status = false;
int idbeginPo = (int)cbxBeginpo.EditValue;
int idendPo = (int)cbxEndPo.EditValue;
float timepro = float.Parse(txtTimeProvide.Text);
if (cbxSatus.Text == "Complete")
{
status = true;
var sv1 = new Position1SoapClient();
var sv3 = new ServicePortNationalSoapClient();
var port = sv3.GetPortByID((int)trip.EndPosition);
sv1.UpdatePosition((int)trip.ID, (float)(port.Longitude), (float)(port.Latitude), DateTime.Now, port.Ocean);
}
else
{
status = false;
}
sv.UpdateTrip(idtrip, IDboat, idbeginPo, idendPo, timepro, dateTimeBegin.Value, dateTimeEnd.Value, status);
MessageBox.Show("Update successfully!");
FrmJourney_Load(sender, e);
}
}
private void LoadDgv()
{
int i = 1, j = 1;
var sv_boat = new ServiceBoatSoapClient();
var sv_position = new Position1SoapClient();
var sv_journey = new Journey1SoapClient();
var boat = sv_boat.GetAllBoat().ToList();
// var position = new Position1SoapClient();
var position = sv_position.GetPosition().ToList();
var journey = sv_journey.LoadJourneyActive().ToList();
var BoatActive = (from a in journey
join b in boat
on a.IDBoat equals b.ID
select new
{
ID = b.ID,
Name = b.Name,
IMO = b.IMO,
ID_Journey = a.ID
}).ToList();
var InforBoatActive = (from p in BoatActive
select new
{
STT = i++,
ID = p.ID,
Name = p.Name,
IMO = p.IMO,
Lat = sv_position.ListPosition(p.ID_Journey).Latitude,
Long = sv_position.ListPosition(p.ID_Journey).Longitude,
Oceans = sv_position.ListPosition(p.ID_Journey).Oceans
}).ToList();
var list = InforBoatActive.GroupBy(p => p.Oceans).Select(p => new { STT = j++, Name = p.Key, count = p.Count() });
int tong = InforBoatActive.Count();
dgvOcean.DataSource = list;
chartThongKe.DataSource = list;
chartThongKe.Series[0].XValueMember = "Name";
chartThongKe.Series[0].XValueType = ChartValueType.String;
chartThongKe.Series[0].YValueMembers = "count";
chartThongKe.Series[0].YValueType = ChartValueType.Int32;
label_Tong.Text = tong.ToString();
}
public void LoaDgvTrip(int IDBoat)
{
int i = 0;
var sv = new Journey1SoapClient();
var trip = sv.GetTrip(IDBoat).ToList();
var port = sv.GetAllPort().ToList();
foreach (var p in trip)
{
if (p.Status == false)
{
btnAdd.Enabled = false; break;
}
}
var ShowTrip = (from t in trip
from p in port
from pt in port
where p.ID == t.BeginPosition
where pt.ID == t.EndPosition
select new
{
STT = ++i,
ID = t.ID,
BeginPosition = p.Name,
EndPosition = pt.Name,
Status = t.Status
}).ToList();
dgvTripList.DataSource = ShowTrip;
if (ShowTrip.Where(p => p.Status == false).ToList().Count() == 0)
{
btnUpdate.Enabled = false; btnAdd.Enabled = true;
}
if (ShowTrip.Count() == 0)
{
btnUpdatePosition.Enabled = false; btnUpdate.Enabled = false;
}
}
void LoadDgv()
{
int i = 1;
var sv_boat = new ServiceBoatSoapClient();
var sv_position = new Position1SoapClient();
var sv_journey = new Journey1SoapClient();
var boat = sv_boat.GetAllBoat().ToList();
var position = sv_position.GetPosition().ToList();
var journey = sv_journey.LoadJourneyActive().ToList();
var BoatActive = (from a in journey
join b in boat
on a.IDBoat equals b.ID
select new
{
ID = b.ID,
Name = b.Name,
IMO = b.IMO,
ID_Journey = a.ID
}).ToList();
var PositionOfBoatActive = (from p in BoatActive
select new
{
STT = i++,
Name = p.Name,
IMO = p.IMO,
Latitude = sv_position.ListPosition(p.ID_Journey).Latitude,
Longitude = sv_position.ListPosition(p.ID_Journey).Longitude,
Ocean = sv_position.ListPosition(p.ID_Journey).Oceans,
IDPosition = sv_position.ListPosition(p.ID_Journey).ID
}).ToList();
dgvBoat.DataSource = PositionOfBoatActive;
foreach (var p in PositionOfBoatActive)
{
var para = new ServiceParameterSoapClient();
var parameter = para.parameter(p.IDPosition);
if (parameter == null)
{
ItemStorage.Items.Add(new MapPushpin()
{
Location = new GeoPoint((float)p.Latitude, (float)p.Longitude), Text = p.STT.ToString()
});
}
else
{
string PositionPara = "Parameter\nSpeed : " + parameter.Speed.ToString() + " ( km/h)" + "\n Wind: " + parameter.Wind.ToString() + " ( mph ) " + "\nWater Level: " + parameter.Waterlevel.ToString() + " ( m )\nWeather: " + parameter.Weather.ToString();
ItemStorage.Items.Add(new MapCallout()
{
Location = new GeoPoint((float)p.Latitude, (float)p.Longitude), Text = PositionPara
});
ItemStorage.Items.Add(new MapPushpin()
{
Location = new GeoPoint((float)p.Latitude, (float)p.Longitude), Text = p.STT.ToString(), TextColor = Color.Red
});
}
}
}
