private AttendancePlanned GetAttendancePlannedFromDR(NpgsqlDataReader dr) { int intAttendancePlannedID = Convert.ToInt32(dr["intAttendancePlannedID"]); RehearsalPart rehearsalPart = GetRehearsalPartByID(Convert.ToInt32(dr["intRehearsalPartID"])); Member member = GetMemberByID(Convert.ToInt32(dr["intMemberID"])); return(new AttendancePlanned(intAttendancePlannedID, rehearsalPart, member)); }
public ActionResult CreateNewSchedule(ScheduleHomeVM vm) { GetDAL get = new GetDAL(); get.OpenConnection(); Event e = get.GetEventByID(vm.SelectedEvent.IntEventID); List <RehearsalPart> rehearsalParts = get.GetRehearsalPartsByEvent(e); foreach (RehearsalPart rp in rehearsalParts) { rp.LstMembers = get.GetUsersByRehearsalPart(rp); } get.CloseConnection(); //List<RehearsalPart> rehearsalParts = vm.LstAllRehearsalParts.Where(x => x.Event.Equals(e)).ToList(); Schedule newSchedule = new Schedule(rehearsalParts, e); ScheduleViewVM model = new ScheduleViewVM(); model.Schedule = newSchedule.FinalSchedule; tmpRehearsalPartsSchedule = model.Schedule; foreach (LocalDate d in uniqueDatesOfRehearsals(model.Schedule.LstScheduledRehearsalParts)) { Rehearsal tmpRehearsal = new Rehearsal(); // get earliest rehearsal on any day DateTime fromDateOnly = new DateTime(d.Year, d.Month, d.Day); // get start of earliest rehearsal part on that day RehearsalPart earliest = model.Schedule.LstScheduledRehearsalParts.Where(x => x.DtmStartDateTime.GetValueOrDefault().Date.Equals(fromDateOnly)).OrderBy(x => x.DtmStartDateTime.GetValueOrDefault()).FirstOrDefault(); tmpRehearsal.DtmStartDateTime = earliest.DtmStartDateTime.GetValueOrDefault(); // get end of latest rehearsal part on that day RehearsalPart lastest = model.Schedule.LstScheduledRehearsalParts.Where(x => x.DtmEndDateTime.GetValueOrDefault().Date.Equals(fromDateOnly)).OrderByDescending(x => x.DtmEndDateTime.GetValueOrDefault()).FirstOrDefault(); tmpRehearsal.DtmEndDateTime = lastest.DtmEndDateTime.GetValueOrDefault(); tmpRehearsal.LstRehearsalParts = model.Schedule.LstScheduledRehearsalParts.Where(x => x.DtmStartDateTime.GetValueOrDefault().Date.Equals(fromDateOnly)).ToList(); model.LstTmpRehearsals.Add(tmpRehearsal); } return(View("ScheduleView", model)); }
public ActionResult ChooseRehearsalPart(CheckInOutMidVM vm) { GetDAL get = new GetDAL(); get.OpenConnection(); ChosenRehearsalPart = get.GetRehearsalPartByID(vm.ChosenRehearsalPart.IntRehearsalPartID); UsersNotCurrentlyAtRehearsal = get.GetUsersByRehearsalPart(ChosenRehearsalPart); CheckInOutViewVM model = new CheckInOutViewVM { CurrentRehearsalPart = ChosenRehearsalPart, UsersNotCurrentlyAtRehearsal = UsersNotCurrentlyAtRehearsal }; get.CloseConnection(); return(View("CheckInOutView", model)); }
public RehearsalPart GetRehearsalPartByID(int intRehearsalPartID) { RehearsalPart retval = null; // define a query string query = "SELECT * FROM \"rehearsalParts\" WHERE \"intRehearsalPartID\" = " + intRehearsalPartID; NpgsqlCommand cmd = new NpgsqlCommand(query, conn); // execute query NpgsqlDataReader dr = cmd.ExecuteReader(); // read all rows and output the first column in each row while (dr.Read()) { retval = GetRehearsalPartFromDR(dr); } return(retval); }
public List <AttendancePlanned> GetAttendancePlannedByRehearsalPart(RehearsalPart rehearsalPart) { List <AttendancePlanned> retval = new List <AttendancePlanned>(); // define a query string query = "SELECT * FROM \"attendancePlanned\" WHERE \"intRehearsalPartID\" = " + rehearsalPart.IntRehearsalPartID; NpgsqlCommand cmd = new NpgsqlCommand(query, conn); // execute query NpgsqlDataReader dr = cmd.ExecuteReader(); // read all rows and output the first column in each row while (dr.Read()) { AttendancePlanned tmpAttendancePlanned = GetAttendancePlannedFromDR(dr); retval.Add(tmpAttendancePlanned); } return(retval); }
public List <RehearsalPart> GetRehearsalPartsByEvent(Event paramEvent) { List <RehearsalPart> retval = new List <RehearsalPart>(); // define a query string query = "SELECT * FROM \"rehearsalParts\" WHERE \"intEventID\" = " + paramEvent.IntEventID; NpgsqlCommand cmd = new NpgsqlCommand(query, conn); // execute query NpgsqlDataReader dr = cmd.ExecuteReader(); // read all rows and output the first column in each row while (dr.Read()) { RehearsalPart tmpRehearsalPart = GetRehearsalPartFromDR(dr); retval.Add(tmpRehearsalPart); } return(retval); }
// return new id public int InsertRehearsalPart(RehearsalPart rehearsalPart) { conn.TypeMapper.UseNodaTime(); string query = "INSERT INTO public.\"rehearsalParts\"(" + "\"intTypeID\", \"strDescription\", \"intEventID\", \"durLength\", \"intPriority\")" + " VALUES(@intTypeID, @strDescription, @intEventID, @durLength, @intPriority)" + " RETURNING \"intRehearsalPartID\";"; NpgsqlCommand cmd = new NpgsqlCommand(query, conn); //cmd.Parameters.AddWithValue("dtmStartDateTime", rehearsalPart.DtmStartDateTime); //cmd.Parameters.AddWithValue("dtmEndDateTime", rehearsalPart.DtmEndDateTime); cmd.Parameters.AddWithValue("intPriority", rehearsalPart.IntPriority); cmd.Parameters.AddWithValue("intTypeID", rehearsalPart.Type.IntTypeID); cmd.Parameters.AddWithValue("strDescription", rehearsalPart.StrDescription); cmd.Parameters.AddWithValue("durLength", rehearsalPart.DurLength); cmd.Parameters.AddWithValue("intEventID", rehearsalPart.Event.IntEventID); int result = (int)cmd.ExecuteScalar(); return(result); }
private bool UpdateRehearsalPartWithRehearsal(RehearsalPart rp, int intRehearsalID) { // define a query string query = "UPDATE \"rehearsalParts\" SET \"intRehearsalID\" = @intRehearsalID" + " WHERE \"intRehearsalPartID\" = @intRehearsalPartID"; NpgsqlCommand cmd = new NpgsqlCommand(query, conn); cmd.Parameters.AddWithValue("intRehearsalID", intRehearsalID); cmd.Parameters.AddWithValue("intRehearsalPartID", rp.IntRehearsalPartID); int result = cmd.ExecuteNonQuery(); if (result == 1) { return(true); } else { return(false); } }
public CheckInOutViewVM() { Users UserToCheckInOut = new Users(); RehearsalPart CurrentRehearsalPart = new RehearsalPart(); }
public AttendancePlanned(int intAttendancePlannedID, RehearsalPart rehearsalPart, Member member) { IntAttendancePlannedID = intAttendancePlannedID; RehearsalPart = rehearsalPart; Member = member; }
public CheckInOutMidVM() { ChosenEvent = new Event(); LstRehearsalParts = new List <RehearsalPart>(); ChosenRehearsalPart = new RehearsalPart(); }
// get a list of attendance for a rehearsal part (kinda same as GetAttendanceActualByPlanned but further abstracted up) public List <AttendanceActual> GetAttendanceActualByRehearsalPart(RehearsalPart rehearsalPart) { //TODO }
public bool InsertRehearsalPart(RehearsalPart rehearsalPart) { //TODO }