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!!");
}
}
