internal static void Update(ParticipantEnrollment P)
{
int rows = 0;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE YACM.ParticipantEnrollment SET teamName=@teamName, dorsal=@dorsal WHERE participantID=@participantID AND eventNumber=@eventNumber";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@participantID", P.ParticipantID);
cmd.Parameters.AddWithValue("@eventNumber", P.EventNumber);
cmd.Parameters.AddWithValue("@teamName", P.TeamName);
cmd.Parameters.AddWithValue("@dorsal", P.Dorsal);
cmd.Connection = Program.db.Open();
try {
rows = cmd.ExecuteNonQuery();
}
catch (Exception ex) {
MessageBox.Show("Failed to update user in database. \n Error message: \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally {
if (rows == 1)
{
MessageBox.Show("Updated sucessfully");
}
else
{
MessageBox.Show("Update not sucesfull");
}
Program.db.Close();
}
}
internal static ParticipantEnrollment Read(int participantID, int eventNumber)
{
Debug.Assert(participantID > -1 && eventNumber > -1, "Participant ID or event Number Index Invalid. Can't Load Participant Enrollment");
ParticipantEnrollment P = new ParticipantEnrollment();
SqlCommand cmd = new SqlCommand("SELECT * FROM YACM.ParticipantEnrollment WHERE participantID = @participantID AND eventNumber = @eventNumber", Program.db.Open());
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@participantID", participantID);
cmd.Parameters.AddWithValue("@eventNumber", eventNumber);
try {
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
P.ParticipantID = Convert.ToInt32(reader["participantID"].ToString());
P.EventNumber = Convert.ToInt32(reader["eventNumber"].ToString());
P.TeamName = reader["teamName"].ToString();
P.Dorsal = Convert.ToInt32(reader["dorsal"].ToString());
}
}
catch (Exception ex) {
MessageBox.Show("Failed to read from database. \n Error message: \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally {
Program.db.Close();
}
return(P);
}
public bool InsertPayment(ParticipantEnrollment obj)
{
ParticipantEnrollment enrollment = context.ParticipantEnrollments.Find(obj.EnrollID);
enrollment.PaymentStatus = true;
context.SaveChanges();
return(true);
}
public bool InsertEnrollment(ParticipantEnrollment obj)
{
//context.Database.Delete();
//context.Database.Create();
context.ParticipantEnrollments.Add(obj);
context.SaveChanges();
return(true);
}
public bool AddPayment(EnrollmentDto objEnrollmentDto)
{
EnrollmentDal objEnrollmentDal = new EnrollmentDal();
ParticipantEnrollment objEnrollment = new ParticipantEnrollment();
objEnrollment.EnrollID = objEnrollmentDto.EnrollId;
objEnrollment.PaymentStatus = objEnrollmentDto.PaymentStatus;
bool status = objEnrollmentDal.InsertPayment(objEnrollment);
return(status);
}
public void UpdateFeedback(ParticipantEnrollment pe)
{
var res = context.ParticipantEnrollments.Where(p => p.UserID == pe.UserID && p.EventID == pe.EventID).Single();
res.InteractionSkill = pe.InteractionSkill;
res.PresentationSkill = pe.PresentationSkill;
res.SubjectKnowledge = pe.SubjectKnowledge;
res.TrainingContent = pe.TrainingContent;
res.TrainingSkill = pe.TrainingSkill;
res.Comments = pe.Comments;
context.SaveChanges();
}
public bool AddEnrollment(EnrollmentDto objEnrollmentDto)
{
EnrollmentDal objEnrollmentDal = new EnrollmentDal();
ParticipantEnrollment objEnrollment = new ParticipantEnrollment();
objEnrollment.EnrollID = objEnrollmentDto.EnrollId;
objEnrollment.PaymentStatus = false;
objEnrollment.EventID = objEnrollmentDto.EnrollEventId;
objEnrollment.UserID = objEnrollmentDto.EnrollMemberId;
bool status = objEnrollmentDal.InsertEnrollment(objEnrollment);
return(status);
}
public void UpdateFeedback(FeedBackDto fd)
{
FeedbackDal pd = new FeedbackDal();
//pd.UpdateFeedback();
ParticipantEnrollment pe = new ParticipantEnrollment();
pe.EventID = fd.EventID;
pe.UserID = fd.UserID;
pe.InteractionSkill = fd.InteractionSkill;
pe.PresentationSkill = fd.PresentationSkill;
pe.SubjectKnowledge = fd.SubjectKnowledge;
pe.TrainingContent = fd.TrainingContent;
pe.TrainingSkill = fd.TrainingSkill;
pe.Comments = fd.Comments;
pd.UpdateFeedback(pe);
}
internal static void Delete(ParticipantEnrollment P)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "DELETE YACM.ParticipantEnrollment WHERE participantID=@participantID AND eventNumber=@eventNumber ";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@participantID", P.ParticipantID);
cmd.Parameters.AddWithValue("@eventNumber", P.EventNumber);
cmd.Connection = Program.db.Open();
try {
cmd.ExecuteNonQuery();
}
catch (Exception ex) {
MessageBox.Show("Failed to delete participant in database. \n Error Message: \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally {
Program.db.Close();
}
}
internal static void Create(ParticipantEnrollment P)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT YACM.ParticipantEnrollment(participantID, eventNumber, teamName, dorsal) VALUES (@participantID, @eventNumber, @teamName, @dorsal)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@participantID", P.ParticipantID);
cmd.Parameters.AddWithValue("@eventNumber", P.EventNumber);
cmd.Parameters.AddWithValue("@teamName", P.TeamName);
cmd.Parameters.AddWithValue("@dorsal", P.Dorsal);
cmd.Connection = Program.db.Open();
try {
cmd.ExecuteNonQuery();
}
catch (Exception ex) {
MessageBox.Show("Failed to insert into database. \n Error message: \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally {
Program.db.Close();
}
}
