private void LoadData()
{
nsgSchool = DB.CoreSchools.Where(cs => cs.SchoolID == nsgSchoolId).FirstOrDefault();
var busRoutes = (from cbr in DB.CoreBusRoutes
join cbrs in DB.CoreBusRouteSchools on cbr.BusRouteID equals cbrs.BusRouteID
where cbrs.SchoolID == nsgSchoolId
select cbr.RouteNo).ToArray();
nsgSchoolId = nsgSchool.SchoolID;
txtSchoolName.Text = nsgSchool.SchoolName;
this.Text += nsgSchool.SchoolName;
txtSchoolAddress.Text = nsgSchool.SchoolAddress;
txtAdminContactNumbers.Text = nsgSchool.AdminContactNumbers;
cmbState.SelectedValue = nsgSchool.StateID;
cmbCity.SelectedValue = nsgSchool.CityID;
dtSummerDateFrom.Value = nsgSchool.SummerTimingStart;
dtSummerDateTo.Value = nsgSchool.SummerTimingEnd;
dtSummerTimeFrom.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, nsgSchool.SummerTimingFrom.Hours, nsgSchool.SummerTimingFrom.Minutes, nsgSchool.SummerTimingFrom.Seconds);
dtSummerTimeTo.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, nsgSchool.SummerTimingTo.Hours, nsgSchool.SummerTimingTo.Minutes, nsgSchool.SummerTimingTo.Seconds);
dtWinterDateFrom.Value = nsgSchool.WinterTimingStart;
dtWinterDateTo.Value = nsgSchool.WinterTimingEnd;
dtWinterTimeFrom.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, nsgSchool.WinterTimingFrom.Hours, nsgSchool.WinterTimingFrom.Minutes, nsgSchool.WinterTimingFrom.Seconds);
dtWinterTimeTo.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, nsgSchool.WinterTimingTo.Hours, nsgSchool.WinterTimingTo.Minutes, nsgSchool.WinterTimingTo.Seconds);
txtDistanceFromGarage.Text = nsgSchool.DistanceFromGarage.ToString();
if (busRoutes.Length > 0)
{
txtBusRoutes.Text = string.Join(", ", busRoutes);
}
}
private void RefreshMe(bool reEntry = false)
{
if (reEntry)
{
nsgSchoolId = 0;
}
nsgSchool = null;
txtSchoolName.Text = string.Empty;
txtSchoolAddress.Text = string.Empty;
txtAdminContactNumbers.Text = string.Empty;
cmbState.SelectedIndex = -1;
cmbCity.SelectedIndex = -1;
dtSummerDateFrom.Value = new DateTime(DateTime.Today.Year, 2, 1);
dtSummerDateTo.Value = new DateTime(DateTime.Today.Year, 10, 31);
dtSummerTimeFrom.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 8, 0, 0);
dtSummerTimeTo.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 14, 0, 0);
dtWinterDateFrom.Value = new DateTime(DateTime.Today.Year, 11, 1);
dtWinterDateTo.Value = new DateTime(DateTime.Today.Year + 1, 1, 31);
dtWinterTimeFrom.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 9, 0, 0);
dtWinterTimeTo.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 15, 0, 0);
txtDistanceFromGarage.Text = string.Empty;
txtBusRoutes.Text = string.Empty;
if (nsgSchoolId > 0)
{
this.Text = "School Detail [EDIT] - ";
LoadData();
btnDelete.Visible = true;
}
else
{
this.Text = "School Detail [ADD]";
btnDelete.Visible = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateMainControls())
{
return;
}
try
{
if (nsgSchool == null)
{
nsgSchool = new CoreSchool();
nsgSchool.EntryDate = DateTime.Now;
nsgSchool.EntryUserID = GlobalClass.LoggedInUserID;
}
else
{
nsgSchool.UpdateDate = DateTime.Now;
nsgSchool.UpdateUserID = GlobalClass.LoggedInUserID;
}
nsgSchool.SchoolName = txtSchoolName.Text;
nsgSchool.SchoolAddress = txtSchoolAddress.Text;
nsgSchool.StateID = int.Parse(cmbState.SelectedValue.ToString());
nsgSchool.CityID = int.Parse(cmbCity.SelectedValue.ToString());
nsgSchool.AdminContactNumbers = txtAdminContactNumbers.Text;
nsgSchool.SummerTimingStart = dtSummerDateFrom.Value.Date;
nsgSchool.SummerTimingEnd = dtSummerDateTo.Value.Date;
nsgSchool.SummerTimingFrom = new TimeSpan(dtSummerTimeFrom.Value.Hour, dtSummerTimeFrom.Value.Minute, dtSummerTimeFrom.Value.Second);
nsgSchool.SummerTimingTo = new TimeSpan(dtSummerTimeTo.Value.Hour, dtSummerTimeTo.Value.Minute, dtSummerTimeTo.Value.Second);
nsgSchool.WinterTimingStart = dtWinterDateFrom.Value.Date;
nsgSchool.WinterTimingEnd = dtWinterDateTo.Value.Date;
nsgSchool.WinterTimingFrom = new TimeSpan(dtWinterTimeFrom.Value.Hour, dtWinterTimeFrom.Value.Minute, dtWinterTimeFrom.Value.Second);
nsgSchool.WinterTimingTo = new TimeSpan(dtWinterTimeTo.Value.Hour, dtWinterTimeTo.Value.Minute, dtWinterTimeTo.Value.Second);
nsgSchool.DistanceFromGarage = decimal.Parse(txtDistanceFromGarage.Text);
if (nsgSchool.SchoolID == 0)
{
DB.CoreSchools.Add(nsgSchool);
}
DB.SaveChanges();
var msgResponse = MessageBox.Show("School details saved successfully. Do you want to continue with school 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);
}
}
