private void RefreshMe(bool reEntry = false)
{
if (reEntry)
{
busRouteId = 0;
}
nsgBusRoute = null;
nsgBusRouteDetails = null;
txtBusRouteNumber.Text = string.Empty;
grdPickupPoints.Rows.Clear();
if (busRouteId > 0)
{
this.Text = "Bus Route Detail [EDIT] - ";
LoadData();
btnDelete.Visible = true;
}
else
{
this.Text = "Bus Route Detail [ADD]";
btnDelete.Visible = false;
}
var busRouteSchools = DB.BusRouteSchoolsGet(int.Parse(busRouteId.ToString()));
grdSchools.DataSource = busRouteSchools;
}
private void LoadData()
{
nsgBusRoute = DB.CoreBusRoutes.Where(br => br.BusRouteID == busRouteId).FirstOrDefault();
txtBusRouteNumber.Text = nsgBusRoute.RouteNo;
this.Text += nsgBusRoute.RouteNo;
nsgBusRouteDetails = DB.CoreBusRouteDetails.Where(brd => brd.BusRouteID == busRouteId).ToList();
if (nsgBusRouteDetails != null)
{
foreach (var nsgBusRouteDetail in nsgBusRouteDetails)
{
grdPickupPoints.Rows.Add(new[] { nsgBusRouteDetail.BusStopNumber.ToString(), nsgBusRouteDetail.BusStopName, nsgBusRouteDetail.PickUpTime, nsgBusRouteDetail.DropTime });
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateMainControls())
{
return;
}
try
{
if (nsgBusRoute == null)
{
nsgBusRoute = new CoreBusRoute();
nsgBusRoute.EntryDate = DateTime.Now;
nsgBusRoute.EntryUserID = GlobalClass.LoggedInUserID;
}
else
{
nsgBusRoute.UpdateDate = DateTime.Now;
nsgBusRoute.UpdateUserID = GlobalClass.LoggedInUserID;
}
nsgBusRoute.RouteNo = txtBusRouteNumber.Text;
if (nsgBusRoute.BusRouteID == 0)
{
DB.CoreBusRoutes.Add(nsgBusRoute);
}
DB.SaveChanges();
busRouteId = nsgBusRoute.BusRouteID;
nsgBusRouteDetails = DB.CoreBusRouteDetails.Where(d => d.BusRouteID == busRouteId).ToList();
if (nsgBusRouteDetails != null)
{
DB.CoreBusRouteDetails.RemoveRange(nsgBusRouteDetails);
DB.SaveChanges();
}
nsgBusRouteDetails = new List <CoreBusRouteDetail>();
for (int i = 0; i < grdPickupPoints.RowCount; i++)
{
if (grdPickupPoints.Rows[i].Cells[0].Value != null)
{
nsgBusRouteDetails.Add(new CoreBusRouteDetail()
{
BusRouteID = busRouteId,
BusStopNumber = int.Parse(grdPickupPoints.Rows[i].Cells[0].Value.ToString()),
BusStopName = grdPickupPoints.Rows[i].Cells[1].Value.ToString(),
PickUpTime = grdPickupPoints.Rows[i].Cells[2].Value.ToString(),
DropTime = grdPickupPoints.Rows[i].Cells[3].Value.ToString(),
EntryUserID = GlobalClass.LoggedInUserID,
EntryDate = DateTime.Now
});
}
}
DB.CoreBusRouteDetails.AddRange(nsgBusRouteDetails);
DB.SaveChanges();
nsgBusRouteSchools = DB.CoreBusRouteSchools.Where(s => s.BusRouteID == busRouteId).ToList();
DB.CoreBusRouteSchools.RemoveRange(nsgBusRouteSchools);
DB.SaveChanges();
nsgBusRouteSchools = new List <CoreBusRouteSchool>();
for (int i = 0; i < grdSchools.Rows.Count; i++)
{
if (bool.Parse(grdSchools.Rows[i].Cells[2].Value.ToString()) == true)
{
nsgBusRouteSchools.Add(new CoreBusRouteSchool()
{
BusRouteID = busRouteId,
SchoolID = long.Parse(grdSchools.Rows[i].Cells[0].Value.ToString()),
EntryUserID = GlobalClass.LoggedInUserID,
EntryDate = DateTime.Now
});
}
}
DB.CoreBusRouteSchools.AddRange(nsgBusRouteSchools);
DB.SaveChanges();
var msgResponse = MessageBox.Show("Bus Route Details saved successfully. Do you want to continue with new route entry?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
if (msgResponse == DialogResult.Yes)
{
RefreshMe(true);
}
else
{
btnClose_Click(null, null);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
MessageBox.Show(ex.Message, this.Text + " : btnSave_Click : " + ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
