public void GetOrderDetail(string orderID)
{
OrderDAO orderDao = new OrderDAO();
ScheduleDAO scheduleDAO = new ScheduleDAO();
MovieDAO movieDAO = new MovieDAO();
OrderDTO order = orderDao.CheckOrder(orderID);
if (order != null)
{
ScheduleDTO schedule = scheduleDAO.GetScheduleByID(order.ScheduleID);
string movieTitle = movieDAO.GetMovieTitle(schedule.MovieID);
this.orderDetail.Visible = true;
this.lblOrderID.Text = order.OrderID;
this.invalidCode.Visible = false;
this.lbMovieName.Text = movieTitle;
this.lbDate.Text = schedule.ScheduleDate.ToShortDateString();
this.lbTime.Text = schedule.ScheduleDate.ToShortTimeString();
this.lbRoom.Text = schedule.RoomID.ToString();
this.lbPrice.Text = (schedule.PriceOfTicket * (order.ListOfSeat).Count) + "";
string seat = "";
foreach (string s in order.ListOfSeat)
{
seat += (s + " ");
}
this.lbSeat.Text = seat;
}
else
{
this.invalidCode.CssClass = "error_message_show";
this.orderDetail.Visible = false;
}
}
private void CreateDataAboutFilm(int id)
{
//Информация о выбранном дне сохраняется в HttpContext.Items["CurrentDay"]
//По умолчанию равен дате сегодня
var timeNow = DateTime.Now;
var currentDay = timeNow.Date; //new DateTime(timeNow.Year,timeNow.Month, timeNow.Day);
if (Request.Query.ContainsKey("schedule_date"))
{
currentDay = DateTime.ParseExact(
Request.Query["schedule_date"],
"dd.MM.yyyy", CultureInfo.InvariantCulture);
}
HttpContext.Items["CurrentDay"] = currentDay;
var film = FilmViewModelDAO.GetFilms($"WHERE id = {id}", false).FirstOrDefault();
FilmViewModel = film;
FilmViewModel.Actors = FilmViewModelDAO.GetActorsByFilmId(FilmViewModel.Id);
FilmViewModel.Producers = FilmViewModelDAO.GetProducersByFilmId(FilmViewModel.Id);
FilmViewModel.Country = FilmViewModelDAO.GetCounrtyById(FilmViewModel.CountryId);
FilmViewModel.Reviews = FilmViewModelDAO.GetReviewByFilmId(FilmViewModel.Id);
FilmViewModel.Schedule = ScheduleDAO.GetSchedule($"id_movie={id} AND date::DATE = '{currentDay:yyyy-MM-dd}'");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string movieID = txtMovieID.Text;
ScheduleDAO scheDao = new ScheduleDAO();
scheDao.AdminScheduleDelete(movieID);
if (MovieDao.DeleteMovie(movieID))
{
List <MovieDTO> list = (List <MovieDTO>)Session["AdminMovieSearch"];
foreach (MovieDTO item in list)
{
if (item.MovieID.Equals(movieID))
{
list.Remove(item);
}
}
gvStaffList.DataSource = list;
gvStaffList.DataBind();
SetMessageTextAndColor("Successfully deleted", Color.Green);
Clear();
}
else
{
SetMessageTextAndColor("Failed to delete", Color.Red);
}
}
/// <summary>
/// Helper method to determine the wait time between report runs
/// </summary>
/// <returns>the wait time between report runs</returns>
private TimeSpan GetRepetitionInterval()
{
// get "now" date variables
DateTime now = DateTime.Now;
double nowMS = now.TimeOfDay.TotalMilliseconds;
int nowDayOfWeek = (int)now.DayOfWeek;
// set up loop variables
int minDayOfWeek = -1;
double minMS = -1;
MySqlConnection connection = null;
ScheduleDAO scheduleDAO = null;
try {
connection = DatabaseUtil.OpenDataSource();
scheduleDAO = new ScheduleDAO(connection);
foreach (Schedule schedule in scheduleDAO.GetScheduleItems())
{
// get "scheduled" date variables
int dayOfWeek = (int)schedule.DayOfTheWeek;
double ms = schedule.TimeOfDay.TotalMilliseconds;
// ensure every item compared is in the future or right now
if (dayOfWeek < nowDayOfWeek || (dayOfWeek == nowDayOfWeek && ms < nowMS))
{
dayOfWeek += 7;
}
// if min DoW is not set, or if the scheduled DoW is less than the min, check MS
if (minDayOfWeek < 0 || minDayOfWeek > dayOfWeek || (minDayOfWeek == dayOfWeek && minMS > ms))
{
minDayOfWeek = dayOfWeek;
minMS = ms;
}
}
}
finally {
if (connection != null)
{
connection.Dispose();
}
if (scheduleDAO != null)
{
scheduleDAO.Dispose();
}
}
if (minMS < 0 || minDayOfWeek < 0)
{
throw new NoScheduleException("No schedules found, can not schedule next report run.");
}
else
{
TimeSpan returnTimeSpan = TimeSpan.FromDays(minDayOfWeek - nowDayOfWeek).Add(TimeSpan.FromMilliseconds(minMS - nowMS));
_logger.DebugFormat("Next reporter run scheduled for: {0}", DateTime.Now.Add(returnTimeSpan).ToString());
return(returnTimeSpan);
}
}
//Страница бронирования мест
//Id - это id сеанса(Schedule)
public IActionResult OnGet(int id)
{
Id = id;
//Не авторизован - на главную станицу
if (!_authService.IsAuthenticated)
{
return(Redirect(Url.Content("~/")));
}
var schedule = ScheduleDAO.GetSchedule($"id_schedule = {id}").FirstOrDefault();
schedule.Hall = ScheduleDAO.GetHallByScheduleId(id);
var bookings = BookingDAO.GetBookingByScheduleId(id);
foreach (var booking in bookings)
{
booking.Schedule = schedule;
}
BookingPageViewModel = new BookingPageViewModel
{
//Передаем сеанс с указаным id
Schedule = schedule,
//Передаем все бронирования на этот сеанс
BookingsInSchedule = bookings
};
return(Page());
}
public static ScheduleDAO MapToScheduleDAO(Schedule schedule)
{
var s = new ScheduleDAO();
s.ScheduleId = schedule.ScheduleId;
s.StudentId = schedule.StudentId;
s.ProfessorId = schedule.ProfessorId;
s.Course1Id = schedule.Course1Id;
s.Course1Time = schedule.Course1Time;
s.Course2Id = schedule.Course2Id;
s.Course2Time = schedule.Course2Time;
s.Course3Id = schedule.Course3Id;
s.Course3Time = schedule.Course3Time;
s.Course4Id = schedule.Course4Id;
s.Course4Time = schedule.Course4Time;
s.Course5Id = schedule.Course5Id;
s.Course5Time = schedule.Course5Time;
s.Course6Id = schedule.Course6Id;
s.Course6Time = schedule.Course6Time;
s.Course7Id = schedule.Course7Id;
s.Course7Time = schedule.Course7Time;
return(s);
}
public ActionResult insertSchedule(FormCollection formCollection)
{
foreach (string key in formCollection.AllKeys)
{
Response.Write("Key + " + key + " ");
Response.Write(formCollection[key] + "</br>");
}
DateTime StartTime = Convert.ToDateTime(formCollection["StartTime"]);
DateTime EndTime = Convert.ToDateTime(formCollection["EndTime"]);
DateTime Sche_Date = Convert.ToDateTime(formCollection["Sche_Date"]);
SessionDAO sesDAO = new SessionDAO();
Session session = sesDAO.getSessionByTime(StartTime, EndTime);
int id_Ses = -1;
if (session == null)
{
id_Ses = sesDAO.createSession(StartTime, EndTime);
}
else
{
id_Ses = session.id_Ses;
}
int id_F = Convert.ToInt32(formCollection["id_F"]);
ScheduleDAO scheDAO = new ScheduleDAO();
scheDAO.createSchedule(id_Ses, Sche_Date, id_F);
return(View());
}
private void SaveScheduleDB(Schedule schedule)
{
using (var connection = DependencyService.Get <ISQLite>().GetConnection())
{
var dao = new ScheduleDAO(connection);
dao.Save(schedule);
}
}
// GET: Admin/Schedules
public ActionResult Index(int page = 1, int pageSize = 10)
{
var dao = new ScheduleDAO();
var model = dao.ListAllPaging(page, pageSize);
var schedules = db.Schedules.Include(s => s.Class).Include(s => s.Subject);
return(View(model));
}
public static ScheduleDAO MapToScheduleDAO(Schedule scheduleToMap)
{
ScheduleDAO schedule = new ScheduleDAO();
schedule.Id = scheduleToMap.Id;
schedule.StudentId = scheduleToMap.StudentId;
schedule.CourseSessionId = scheduleToMap.CourseSessionId;
return(schedule);
}
public ActionResult Get(uint id)
{
if (!Authentication.IsValid())
{
return(Json(new { Error = "Not Authenticated" }));
}
JsonResult json = Json(new { Object = ScheduleDAO.GetById(id) });
json.MaxJsonLength = int.MaxValue;
return(json);
}
public static Schedule MapToSchedule(ScheduleDAO schedule)
{
var s = new Schedule();
s.ScheduleId = schedule.Id;
s.PersonId = schedule.Person.Id;
s.CourseId = schedule.Course.Id;
s.Active = schedule.Active;
return(s);
}
public static ScheduleDAO MapToScheduleDAO(Schedule schedule)
{
var s = new ScheduleDAO();
s.Id = schedule.ScheduleId;
s.Person = PersonMapper.MapToPersonDAO(schedule.Person);
s.Course = CourseMapper.MapToCourseDAO(schedule.Course);
s.Active = schedule.Active;
return(s);
}
/// <summary>
/// Convert ScheduleDAO into Schedule.
/// </summary>
/// <param name="scheduleDAO">The ScheduleDAO to convert.</param>
/// <returns>The Schedule.</returns>
public static Schedule MapToSchedule(ScheduleDAO scheduleDAO)
{
RegistrationData data = new RegistrationData();
Schedule schedule = data.FindOrCreateSchedule(scheduleDAO.Id);
schedule.ScheduleId = scheduleDAO.Id;
schedule.StartTime = scheduleDAO.StartTime;
schedule.TimeBlocks = scheduleDAO.TimeBlocks;
return(schedule);
}
public static string SignOut(string sno, string sequence, string remark)
{
if (!ScheduleField.Sequence.TestValue(sequence) || !ScheduleField.SignOutRemark.TestValue(remark))
{
return("数据格式或长度错误 请联系管理员！");
}
DateTime nowtime = DateTime.Now;
SqlQueryCondition[] sqlconditions1 = new SqlQueryCondition[] {
new SqlQueryCondition(UserField.StudentNmber, SqlQueryConditionOperator.Equal, sno),
new SqlQueryCondition(UserField.Status, SqlQueryConditionOperator.Equal, 1)
};
object[,] user = UserDAO.Select(new UserField[] { UserField.Id, UserField.Name }, new SqlQueryCondition(sqlconditions1, SqlQueryLogicalOperator.And));
if (user.Length == 0)
{
return("未找到该用户的信息，请检查学号是否填写正确！");
}
SqlQueryCondition[] sqlconditions2 = new SqlQueryCondition[] {
new SqlQueryCondition(ScheduleField.Date, SqlQueryConditionOperator.Equal, nowtime),
new SqlQueryCondition(ScheduleField.Sequence, SqlQueryConditionOperator.Equal, sequence),
new SqlQueryCondition(ScheduleField.Attendant, SqlQueryConditionOperator.Equal, user[0, 0])
};
object[,] schedule = ScheduleDAO.Select(new ScheduleField[] { ScheduleField.Id, ScheduleField.SignInTime, ScheduleField.SignOutTime },
new SqlQueryCondition(sqlconditions2, SqlQueryLogicalOperator.And));
if (schedule.Length == 0)
{
return("未找到你的值班信息，请检查班次是否错误！");
}
if (schedule[0, 1] == DBNull.Value)
{
return("你还未进行入站签到，请先入站签到！");
}
if (schedule[0, 2] != DBNull.Value)
{
return("你已对此班签出！");
}
if (nowtime.TimeOfDay < dutytimes[sequence].EndTime - aheadtime)
{
return("此时签出太早了，请晚点再来！");
}
if (nowtime.TimeOfDay > dutytimes[sequence].EndTime + gracetime)
{
return("你来晚了，签出时间已过！");
}
ScheduleDAO.Update(new ScheduleField[] { ScheduleField.SignOutTime, ScheduleField.SignOutRemark }, new object[] { nowtime.TimeOfDay, remark },
new SqlQueryCondition(ScheduleField.Id, SqlQueryConditionOperator.Equal, schedule[0, 0]));
UserLogDAO.Insert((int)user[0, 0], "signout{" + sequence + '\r' + remark + "}");
return("true\n" + user[0, 1].ToString() + " 第" + sequence + "班 " + nowtime.ToLongTimeString() + "签出");
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
string idstr = boxID.Text;
try
{
User usr = new User();
if (!String.IsNullOrEmpty(idstr))
{
usr.Id = int.Parse(idstr);
}
usr.Name = boxNombre.Text;
usr.Appat = boxApPat.Text;
usr.Apmat = boxApMat.Text;
usr.Email = boxEmail.Text;
usr.Institution = InstitutionDAO.GetInstitution(int.Parse(selInstitution.SelectedValue));
usr.Schedule = ScheduleDAO.GetSchedule(int.Parse(Request.Form["selSchedule"]));
usr.Username = boxUsername.Text;
usr.Password = boxPassword.Text;
User sUser = (User)Session["user"];
if (sUser.Type == "manager")
{
usr.Type = "agent";
}
else
{
usr.Type = Request.Form["selType"];
}
if (String.IsNullOrEmpty(idstr)) //new
{
UserDAO.AddUser(usr);
}
else //update
{
UserDAO.ModUser(usr);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
Response.Redirect("~/UserList");
Context.ApplicationInstance.CompleteRequest();
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
string idstr = boxID.Text;
try
{
Schedule schedule = new Schedule();
schedule.Name = boxNombre.Text;
schedule.Description = boxDescripcion.Text;
schedule.Fk_institution = int.Parse(selInstitution.SelectedValue);
schedule.Lunesin = boxLunesin.Text;
schedule.Lunesout = boxLunesout.Text;
schedule.Martesin = boxMartesin.Text;
schedule.Martesout = boxMartesout.Text;
schedule.Miercolesin = boxMiercolesin.Text;
schedule.Miercolesout = boxMiercolesout.Text;
schedule.Juevesin = boxJuevesin.Text;
schedule.Juevesout = boxJuevesout.Text;
schedule.Viernesin = boxViernesin.Text;
schedule.Viernesout = boxViernesout.Text;
schedule.Sabadoin = boxSabadoin.Text;
schedule.Sabadoout = boxSabadoout.Text;
schedule.Domingoin = boxDomingoin.Text;
schedule.Domingoout = boxDomingoout.Text;
if (String.IsNullOrEmpty(idstr)) //new
{
ScheduleDAO.AddSchedule(schedule);
}
else //update
{
schedule.Id = int.Parse(boxID.Text);
ScheduleDAO.ModSchedule(schedule);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.StackTrace);
Debug.WriteLine(ex.Message);
}
Response.Redirect("~/ScheduleList");
Context.ApplicationInstance.CompleteRequest();
}
public void UpdateList()
{
using (var connection = DependencyService.Get <ISQLite>().GetConnection())
{
ScheduleDAO dao = new ScheduleDAO(connection);
var listDB = dao.List;
var query =
listDB
.OrderBy(l => l.DateSchedule)
.ThenBy(l => l.TimeSchedule);
this.List.Clear();
foreach (var itemDB in query)
{
this.List.Add(itemDB);
}
}
}
public IActionResult OnGet(int id)
{
UserViewModel = UserDAO.GetUserById(id);
UserViewModel.Bookings = BookingDAO.GetBookingsByUserId(id);
foreach (var booking in UserViewModel.Bookings)
{
booking.Schedule = ScheduleDAO.GetSchedule($"id_schedule = {booking.ScheduleId}").FirstOrDefault();
booking.Schedule.Hall = ScheduleDAO.GetHallByScheduleId(booking.Schedule.Id);
booking.Schedule.Film = FilmViewModelDAO.GetFilms($"WHERE id = {booking.Schedule.FilmId}", false).FirstOrDefault();
if (booking.Row == 0)
{
booking.Schedule.PricePerSeat /= 2;
}
else if (booking.Row == booking.Schedule.Hall.SeatsRowCount.Length - 1)
{
booking.Schedule.PricePerSeat = Math.Round(booking.Schedule.PricePerSeat * (decimal)1.2);
}
}
return(Page());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
User sUser = (User)Session["user"];
if (sUser == null)
{
Response.Redirect("~/Login");
}
string idstr = Request["Id"];
if (String.IsNullOrEmpty(idstr)) //new schedule
{
btnBorrar.Visible = false;
lblId.Visible = false;
boxID.Visible = false;
}
else //load schedule
{
try
{
boxID.Enabled = false;
Schedule schedule = ScheduleDAO.GetSchedule(int.Parse(idstr));
boxID.Text = schedule.Id.ToString();
boxNombre.Text = schedule.Name;
boxDescripcion.Text = schedule.Description;
boxLunesin.Text = schedule.Lunesin;
boxLunesout.Text = schedule.Lunesout;
boxMartesin.Text = schedule.Martesin;
boxMartesout.Text = schedule.Martesout;
boxMiercolesin.Text = schedule.Miercolesin;
boxMiercolesout.Text = schedule.Miercolesout;
boxJuevesin.Text = schedule.Juevesin;
boxJuevesout.Text = schedule.Juevesout;
boxViernesin.Text = schedule.Viernesin;
boxViernesout.Text = schedule.Viernesout;
boxSabadoin.Text = schedule.Sabadoin;
boxSabadoout.Text = schedule.Sabadoout;
boxDomingoin.Text = schedule.Domingoin;
boxDomingoout.Text = schedule.Domingoout;
}
catch (Exception ex)
{
Debug.WriteLine(ex.StackTrace);
Debug.WriteLine(ex.Message);
}
}
List <Institution> institutions = InstitutionDAO.GetInstitutions();
int ins_fk = 1;
if (!String.IsNullOrEmpty(Request["Id"]))
{
ins_fk = ScheduleDAO.GetSchedule(int.Parse(boxID.Text)).Fk_institution;
}
if (sUser.Type == "admin")
{
foreach (Institution ins in institutions)
{
if (!String.IsNullOrEmpty(Request["Id"]) && ins.Id == ins_fk) //not postback, requesting id info,
{
selInstitution.Items.Add(new ListItem(ins.Id + " - " + ins.Name, ins.Id.ToString()));
selInstitution.SelectedValue = ins.Id.ToString();
//selInstitution.InnerText += ("<option value=\"" + ins.Id + "\" selected>" + ins.Id + "-" + ins.Name + "</option>");
}
else
{
//selInstitution.InnerText += ("<option value=\"" + ins.Id + "\">" + ins.Id + "-" + ins.Name + "</option>");
selInstitution.Items.Add(new ListItem(ins.Id + " - " + ins.Name, ins.Id.ToString()));
}
}
}
else if (sUser.Type == "manager")
{
selInstitution.Items.Add(new ListItem(sUser.Institution.Id + " - " + sUser.Institution.Name, sUser.Institution.Id.ToString()));
//selInstitution.InnerText += ("<option value=\"" + sUser.Institution.Id + "\" selected>" + sUser.Institution.Name + "</option>");
}
}
}
protected void btnBorrar_Click(object sender, EventArgs e)
{
ScheduleDAO.RemoveSchedule(int.Parse(boxID.Text));
Response.Redirect("~/ScheduleList");
Context.ApplicationInstance.CompleteRequest();
}
public IEnumerable <Schedule> GetList()
{
return(ScheduleDAO.GetList());
}
public Schedule GetById(uint id)
{
return(ScheduleDAO.GetById(id));
}
