public int InserClassAttandetns(ClassAttandents classAttandents) { try { myDatabase.Open(myConnectionString); if (memberAllreadyRegistered(classAttandents.MemberId, classAttandents.ClassId) == true) { return(1); } String sqlText = String.Format( @"INSERT INTO Class_Attandents (memberId, classId, isCompleted) VALUES ({0}, {1}, '{2}')", classAttandents.MemberId, classAttandents.ClassId, classAttandents.IsCompleted); myDatabase.ExecuteUpdate(sqlText); return(0); } catch (Exception) { return(-1); // An error occurred } finally { myDatabase.Close(); } }
private ClassAttandents classAttandentsscreenToModel() { ClassAttandents classAttandents = new ClassAttandents(); string userName = "" + Session["username"]; int classId = Convert.ToInt32(ListBoxMyAccount.SelectedValue); classAttandents.MemberId = memberDAO.GetMemberIdByUsername(userName); classAttandents.ClassId = classId; classAttandents.IsCompleted = "N"; return(classAttandents); }
protected void btClassRegister_Click(object sender, EventArgs e) { ClassAttandents classAttandents = classAttandentsscreenToModel(); int insertOk = classAttandentsDAO.InserClassAttandetns(classAttandents); if (insertOk == 0) //Insert succeded { classViewStateNew(); LbClassReg.Text = "Registration Successfull!!"; } else if (insertOk == 1) { showErrorMessageClass("You have already register for this Class. No record inserted into the database."); } else { showErrorMessageClass("THE DATABASE IS TEMPORARILY OUT OF USE!!"); } }