public bool AddSchedule(EditSchedule schedule)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO Schedule (name,description,date) " +
"VALUES (@name, @description, @date )", conn);
cmd.Parameters.AddWithValue("@name", schedule.Name);
cmd.Parameters.AddWithValue("@description", schedule.Description);
cmd.Parameters.AddWithValue("@date", schedule.Date);
cmd.ExecuteNonQuery();
return(true);
}
}
catch (SqlException ex)
{
return(false);
throw;
}
}
public List <EditSchedule> GetSchedules()
{
List <EditSchedule> list = new List <EditSchedule>();
EditSchedule result = new EditSchedule();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select * From Schedule ", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
result = MapRowToSchedule(reader);
list.Add(result);
}
return(list);
}
}
catch (SqlException ex)
{
throw;
}
}
public EditSchedule GetScheduleById(int id)
{
EditSchedule result = new EditSchedule();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select * From Schedule WHERE id = @id", conn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
result = MapRowToSchedule(reader);
}
return(result);
}
}
catch (SqlException ex)
{
throw;
}
}
public bool EditSchedule(EditSchedule schedule)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE Schedule " +
"SET name = @name, description = @description, date = @date " +
"WHERE id = @id", conn);
cmd.Parameters.AddWithValue("@name", schedule.Name);
cmd.Parameters.AddWithValue("@description", schedule.Description);
cmd.Parameters.AddWithValue("@date", schedule.Date);
cmd.Parameters.AddWithValue("@id", schedule.Id);
cmd.ExecuteNonQuery();
return(true);
}
}
catch (SqlException ex)
{
return(false);
throw;
}
}
//Update schedule
public ActionResult Edit(int id)
{
var svc = CreateScheduleService();
var modelOrg = svc.GetScheduleById(id);
var model = new EditSchedule();
model.ScheduleId = id;
var times = GetAllTimes();
var courses = GetAllCourses();
var cList = GetCourses(courses);
var tutors = GetTutorByLocation(modelOrg.LocationSchedule);
var tList = GetLocationsTutors(tutors);
model.AvailableDays = TimesSelectListItems(times);
model.AvailableTutors = LocationTutorListItems(tList);
model.AvailableCourses = CourseListItems(cList);
var service = CreateScheduleService();
var detail = service.GetScheduleById(id);
model.ScheduleId = id;
model.ScheduleTutorID = detail.ScheduleTutor;
model.ScheduleCourseID = detail.ScheduleCourse;
model.ScheduleDate = detail.TimeSchedule;
return(View(model));
}
public IActionResult EditSchedule(int id)
{
EditSchedule model = new EditSchedule();
model = gymDAL.GetScheduleById(id);
return(View(model));
}
private async Task EditItemAsync(string item)
{
StaticMethods.Toast($"Edit popup for {item}.");
var pop = new EditSchedule();
pop.BindingContext = new EditScheduleViewModel(this.Schedules.First(x => x.Code == item));
await Rg.Plugins.Popup.Services.PopupNavigation.Instance.PushAsync(pop);
}
private void btnOk_Click(object sender, EventArgs e)
{
EditSchedule view = new EditSchedule(currentDay, _loginName);
DialogHostFormPC pc = new DialogHostFormPC("编辑事项", view.Width, view.Height);
pc.Child = view;
pc.ShowDialog();
TitleFormat();
}
public IActionResult EditSchedule(EditSchedule model)
{
if (ModelState.IsValid)
{
gymDAL.EditSchedule(model);
return(RedirectToAction(nameof(ViewSchedules)));
}
return(View(model));
}
public void EditItem(MedicalSystem.Anes.Domain.MED_DAILY_SCHEDULE item)
{
EditSchedule view = new EditSchedule(currentDay, _loginName);
view.Edit(item);
DialogHostFormPC pc = new DialogHostFormPC("编辑事项", view.Width, view.Height);
pc.Child = view;
pc.ShowDialog();
TitleFormat();
}
private void btnEdit_Click(object sender, EventArgs e)
{
int index = dataGridView1.SelectedRows[0].Index;
DateTime date = DateTime.Parse(dataGridView1.Rows[index].Cells[0].Value.ToString());
string from = dataGridView1.Rows[index].Cells[2].Value.ToString();
string to = dataGridView1.Rows[index].Cells[3].Value.ToString();
string flightNumber = dataGridView1.Rows[index].Cells[4].Value.ToString();
FlightViewModel temp = new FlightViewModel();
temp = (list.Where(x => x.DateFlight == date && x.From.Equals(from) && x.To.Equals(to) && x.FlightNumber.Equals(flightNumber)).FirstOrDefault());
using (EditSchedule edit = new EditSchedule(temp))
{
if (edit.ShowDialog() == DialogResult.OK)
{
list = GetReloadList();
SetDataToView(list);
}
}
}
//Update schedule
public bool UpdateSchedule(EditSchedule model)
{
int position = model.ScheduleTutorID.IndexOf("-");
int tutorNum = Int32.Parse(model.ScheduleTutorID.Substring(0, position));
int coursePosition = model.ScheduleCourseID.IndexOf("-");
int courseNum = Int32.Parse(model.ScheduleCourseID.Substring(0, coursePosition));
int DaySelPos = model.ScheduleDay.IndexOf(":");
string DaySel = model.ScheduleDay.Substring(DaySelPos - 1);
int hour = 3;
if (DaySel == "3:00")
{
hour = 15;
}
;
if (DaySel == "5:00")
{
hour = 17;
}
;
if (DaySel == "1:00")
{
hour = 13;
}
;
DateTime sch = new DateTime(model.ScheduleDate.Year, model.ScheduleDate.Month, model.ScheduleDate.Day, hour, 0, 0);
using (var ctx = new ApplicationDbContext())
{
var entity =
ctx
.Schedules
.Single(e => e.Id == model.ScheduleId);
entity.TutorId = tutorNum;
entity.CourseId = courseNum;
entity.Time = sch;
return(ctx.SaveChanges() > 0);
}
}
public ActionResult Edit(int id, EditSchedule model)
{
View();
var times = GetAllTimes();
var courses = GetAllCourses();
var cList = GetCourses(courses);
var tutors = GetTutorByLocation(model.ScheduleLocation);
var tList = GetLocationsTutors(tutors);
model.ScheduleId = id;
model.AvailableDays = TimesSelectListItems(times);
model.AvailableTutors = LocationTutorListItems(tList);
model.AvailableCourses = CourseListItems(cList);
if (!ModelState.IsValid)
{
return(View(model));
}
if (model.ScheduleId != id)
{
ModelState.AddModelError("", "Id Mismatch");
return(View(model));
}
var service = CreateScheduleService();
if (service.UpdateSchedule(model))
{
TempData["SaveResult"] = "The schedule was updated.";
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", "The schedule could not be updated.");
return(View(model));
}
public void SetDay(DateTime now, bool today, List <MED_DAILY_SCHEDULE> list)
{
currentDay = now;
toDay = today;
data = list;
this.labTitle.Visible = false;
if (today)
{
this.labDay.Image = Resources.day1;
this.labDay.Text = "";
if (list != null && list.Count > 0)
{
this.labTitle.Text = string.Format("代办事项{0}项", list.Count);
this.labTitle.Visible = true;
}
}
else if (list != null && list.Count > 0)
{
this.labDay.Image = Resources.day2;
this.labDay.Text = now.Day.ToString();
this.labDay.ForeColor = Color.White;
this.labTitle.Text = string.Format("代办事项{0}项", list.Count);
this.labTitle.Visible = true;
}
else
{
this.labDay.Image = null;
this.labDay.Text = now.Day.ToString();
this.labDay.ForeColor = Color.Black;
}
PanelBorder p = null;
Label lab = null;
for (int i = 0; i < this.panelNoFlash2.Controls.Count || list != null && i < list.Count; i++)
{
if (i < panelTmpList.Count)
{
p = panelTmpList[i] as PanelBorder;
lab = p.Controls[0] as Label;
}
else
{
p = new PanelBorder()
{
Height = 26
};
p.Padding = new Padding(6);
p.DashStyle = DashStyle.Custom;
p.DashPattern = new float[] { 1f, 3f };
panelTmpList.Add(p);
this.panelNoFlash2.Controls.Add(p);
p.Dock = DockStyle.Top;
lab = new Label();
p.Controls.Add(lab);
lab.Dock = DockStyle.Fill;
lab.ImageAlign = ContentAlignment.MiddleLeft;
lab.TextAlign = ContentAlignment.MiddleLeft;
p.Tag = i;
lab.Tag = i;
lab.DoubleClick += (sender, e) =>
{
EditSchedule view = new EditSchedule(currentDay, ExtendApplicationContext.Current.LoginUser.LOGIN_NAME);
view.Edit(list[(int)(sender as Control).Tag]);
DialogHostFormPC pc = new DialogHostFormPC("编辑事项", view.Width, view.Height);
pc.Child = view;
pc.ShowDialog();
SetDay(now, today, list);
};
}
p.BringToFront();
if (list != null && i < list.Count)
{
var tmp = list[i];
if (tmp.STATE == 0)
{
p.BorderColor = UN_FINISHED_COLOR;
p.BackColor = UN_FINISHED_COLOR;
lab.Image = Resources.unfinished;
}
else
{
p.BorderColor = FINISHED_COLOR;
p.BorderColor = FINISHED_COLOR;
p.BackColor = FINISHED_COLOR;
lab.Image = Resources.finished;
}
lab.Text = string.Format(" {0} {1}", tmp.CREATE_DATE.Value.ToString("HH:mm"), tmp.CONTENT);
}
else
{
p.Visible = false;
}
}
}
private void btnEditSchedule_Click(object sender, RoutedEventArgs e)
{
Schedule schedule = ScheduleLoader.LoadSchedule("schedule.dat");
EditSchedule form = new EditSchedule(new ScheduleForEdit(schedule));
form.Show();
}
