private void btnNav_Click(object sender, EventArgs e)
{
if (pSchedule.Visible && !pVehicle.Visible && !pOverview.Visible)
{
if (dtStart.Value.Date > dtEnd.Value.Date)
{
MessageBox.Show("End Date can't be lower than Start Date");
}
else
{
var param = new Dictionary <string, object>();
param.Add("@start", dtStart.Value);
param.Add("@end", dtEnd.Value);
//grd.DataSource = Connection.GetTMSConnection.ExecuteStoredProcedure("SP_AvailableVehicle", param);
//grd.ClearSelection();
lb.DataSource = Connection.GetTMSConnection.ExecuteStoredProcedure("SP_AvailableVehicle", param);
lb.DisplayMember = "Vehicle";
lb.ValueMember = "Vehicle";
pSchedule.Visible = false;
pVehicle.Visible = true;
btnBack.Visible = true;
}
}
else if (!pSchedule.Visible && pVehicle.Visible && !pOverview.Visible) // Available Vehicle
{
//if (grd.SelectedRows.Count == 0)
//{
// MessageBox.Show("Select a vehicle.");
//}
lblExpStart.Text = dtStart.Value.Date.ToShortDateString();
lblExpEnd.Text = dtEnd.Value.Date.ToShortDateString();
lblIncharge.Text = txtIncharge.Text;
lblVehicle.Text = lb.SelectedValue.ToString();
pVehicle.Visible = false;
pOverview.Visible = true;
btnNav.Text = "Save";
}
else if (!pSchedule.Visible && !pVehicle.Visible && pOverview.Visible)
{
var unit = new TripUnit();
var manager = new TripManager();
unit.TripId = DataSupport.GetNextMenuCodeInt("TR");
unit.ExpectedStart = lblExpStart.Text;
unit.ExpectedEnd = lblExpEnd.Text;
unit.Incharge = lblIncharge.Text;
unit.VehicleId = lblVehicle.Text;
unit.RouteId = "";
unit.ActualStart = "";
unit.ActualEnd = "";
unit.Cost = "";
unit.LastUpdated = "";
manager.InsertTrip(unit);
manager.RunScript();
MessageBox.Show("Successfully saved!");
DialogResult = DialogResult.OK;
}
}
private void btnNav_Click(object sender, EventArgs e)
{
if (cbRoute.SelectedIndex == -1)
{
MessageBox.Show("Select Route");
return;
}
var manager = new TripManager();
var tripUnit = new TripUnit();
tripUnit.TripId = lblTripNo.Text;
tripUnit.ExpectedStart = lblTripStart.Text;
tripUnit.ExpectedEnd = lblTripEnd.Text;
tripUnit.Incharge = lblIncharge.Text;
tripUnit.VehicleId = lblVehicle.Text;
tripUnit.RouteId = cbRoute.SelectedValue.ToString();
tripUnit.ActualStart = "";
tripUnit.ActualEnd = "";
tripUnit.Cost = "";
tripUnit.LastUpdated = DateTime.Now.Date.ToShortDateString();
manager.InsertTrip(tripUnit);
manager.WMSHeaderInsert(lblTripNo.Text, lblIncharge.Text);
foreach (DataGridViewRow row in grdOrders.Rows)
{
var tripOrderUnit = new TripOrderUnit();
tripOrderUnit.DropSequence = row.Cells["colDropSequence"].Value.ToString();
tripOrderUnit.TripId = lblTripNo.Text;
tripOrderUnit.OrderId = row.Cells["colShipId"].Value.ToString();
tripOrderUnit.Reference = row.Cells["colRefDoc"].Value.ToString();
tripOrderUnit.ReferenceDate = row.Cells["colRefDocDate"].Value.ToString();
tripOrderUnit.ClientId = row.Cells["colClient"].Value.ToString();
tripOrderUnit.CustomerId = row.Cells["colCustId"].Value.ToString();
tripOrderUnit.OrderManagementSystem = row.Cells["colClient"].Value.ToString();
tripOrderUnit.DocumentValue = row.Cells["colDocValue"].Value.ToString();
tripOrderUnit.CustomerDeliveryAddress = "";
tripOrderUnit.Remarks = "";
tripOrderUnit.Status = "FOR RECEIVING";
manager.InsertTripOrder(tripOrderUnit);
manager.UpdateOutgoingShipmentRequest("out_shipment_id", tripOrderUnit.OrderId);
manager.WMSDetailsInsert(tripOrderUnit.TripId, tripOrderUnit.OrderId, tripOrderUnit.DropSequence, lblTripStart.Text);
}
manager.RunScript();
MessageBox.Show("SAVED");
DialogResult = DialogResult.OK;
}
public void InsertTrip(TripUnit unit)
{
var param = new Dictionary <string, object>
{
{ "trip_id", unit.TripId },
{ "vehicle", unit.VehicleId },
{ "in_charge", unit.Incharge },
{ "expected_start", unit.ExpectedStart },
{ "expected_end", unit.ExpectedEnd },
{ "actual_start", unit.ActualStart },
{ "actual_end", unit.ActualEnd },
{ "cost", unit.Cost },
{ "route", unit.RouteId },
{ "last_updated_on", unit.LastUpdated }
};
TMSSqlScript.AppendLine(DataSupport.GetUpsert("Trips", param, "trip_id"));
}
private void grdVehicleWithTrip_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var grd = sender as DataGridView;
if (grd.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
var unit = new TripUnit();
unit.TripId = grd.Rows[e.RowIndex].Cells["colTripId"].Value.ToString();
unit.VehicleId = grd.Rows[e.RowIndex].Cells["colVehicle"].Value.ToString();
unit.ExpectedStart = DateTime.Parse(grd.Rows[e.RowIndex].Cells["colExpectedStart"].Value.ToString()).ToShortDateString();
unit.ExpectedEnd = DateTime.Parse(grd.Rows[e.RowIndex].Cells["colExpectedEnd"].Value.ToString()).ToShortDateString();
unit.Incharge = grd.Rows[e.RowIndex].Cells["colIncharge"].Value.ToString();
unit.RouteId = grd.Rows[e.RowIndex].Cells["colRoute"].Value.ToString();
unit.LastUpdated = grd.Rows[e.RowIndex].Cells["colLastUpdated"].Value.ToString();
using (var dialog = new ViewTripScheduleForm(unit))
{
dialog.ShowDialog();
}
}
}
public ViewTripScheduleForm(TripUnit unit)
{
InitializeComponent();
Unit = unit;
}
public TripOverviewUserControl(TripUnit unit)
{
InitializeComponent();
Unit = unit;
}
