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
}
