public ActionResult AddRehearsalPart(AdminHomeVM vm)
{
PeriodBuilder builder = new PeriodBuilder();
builder.Minutes = vm.NewRehearsalPart.IntLengthMinutes;
vm.NewRehearsalPart.DurLength = builder.Build();
GetDAL get = new GetDAL();
get.OpenConnection();
foreach (var id in vm.NewRehearsalPart.ArrMemberNeededIDs)
{
Users tmpUser = get.GetUserByID(id);
vm.NewRehearsalPart.LstMembers.Add(tmpUser);
}
get.CloseConnection();
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
int newRehearsalPartID = insert.InsertRehearsalPart(vm.NewRehearsalPart);
vm.NewRehearsalPart.IntRehearsalPartID = newRehearsalPartID;
foreach (var m in vm.NewRehearsalPart.LstMembers)
{
AttendancePlanned ap = new AttendancePlanned(vm.NewRehearsalPart, m);
insert.InsertAttendancePlanned(ap);
}
insert.CloseConnection();
return(RedirectToAction("Index"));
}
private AttendanceActual GetAttendanceActualFromDR(NpgsqlDataReader dr)
{
int intAttendanceActualID = Convert.ToInt32(dr["intAttendanceActualID"]);
DateTime dtmInTime = Convert.ToDateTime(dr["dtmInTime"]);
DateTime dtmOutTime = Convert.ToDateTime(dr["dtmOutTime"]);
bool ysnDidShow = Convert.ToBoolean(dr["ysnDidShow"]);
AttendancePlanned attendancePlanned = GetAttendancePlannedByID(Convert.ToInt32(dr["intAttendancePlannedID"]));
return(new AttendanceActual(intAttendanceActualID, dtmInTime, dtmOutTime, ysnDidShow, attendancePlanned));
}
public AttendancePlanned GetAttendancePlannedByID(int intAttendancePlannedID)
{
AttendancePlanned retval = null;
// define a query
string query = "SELECT * FROM \"attendancePlanned\" WHERE \"intAttendancePlannedID\" = " + intAttendancePlannedID;
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 = GetAttendancePlannedFromDR(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 bool InsertAttendancePlanned(AttendancePlanned attendancePlanned)
{
string query = "INSERT INTO public.\"attendancePlanned\"(" +
"\"intRehearsalPartID\", \"intUserID\")" +
" VALUES(@intRehearsalPartID, @intUserID); ";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.AddWithValue("intRehearsalPartID", attendancePlanned.RehearsalPart.IntRehearsalPartID);
cmd.Parameters.AddWithValue("intUserID", attendancePlanned.User.IntUserID);
int result = (int)cmd.ExecuteNonQuery();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
// get a list of the attendance for a planned rehearsal part
public List <AttendanceActual> GetAttendanceActualByPlanned(AttendancePlanned attendancePlanned)
{
//TODO
}
public bool InsertAttendancePlanned(AttendancePlanned attendancePlanned)
{
//TODO
}
