private void button1_Click(object sender, EventArgs e)
{
String msg = "";
int valCredits, valCapacity;
valCapacity = subjectCurrentCapacity + 1;
valCredits = studentCurrentCredits + subjectUnits;
if (valCredits <= studentMaxCredits && valCapacity <= subjectMaxCapacity)
{
SubjectEnroll subjEnroll = new SubjectEnroll();
subjEnroll.Date_Enroll = DateTime.Now;
subjEnroll.SubjectOfferID = Convert.ToInt16(offerIDValLbl.Text);
subjEnroll.StudentID = Convert.ToInt16(idValLbl.Text);
subjEnroll.SubjectID = Convert.ToInt16(subIDValLbl.Text);
msg = myConnn.subjecEnrollInsert(subjEnroll);
if (msg == "Successfull Added")
{
myConnn.updateStudentCurrentCredits(idValLbl.Text, valCredits);
myConnn.updateSubjectOfferCurrentCapacity(offerIDValLbl.Text, valCapacity);
}
}
else
{
msg = "Fail";
}
MessageBox.Show(msg);
}
public String subjecEnrollInsert(SubjectEnroll subjEnroll)
{
try
{
string strCommand = "INSERT INTO SubjectEnroll(Stud_Id,Sub_Id,date_enroll,SubjectOffer_ID) VALUES(@Stud_Id,@Sub_Id,@Date_enroll,@Subject_Offer_ID)";
SqlCeCommand cmdInsert = new SqlCeCommand();
cmdInsert.Connection = conn;
cmdInsert.CommandType = CommandType.Text;
cmdInsert.CommandText = strCommand;
cmdInsert.Parameters.AddWithValue("@Stud_Id", subjEnroll.StudentID);
cmdInsert.Parameters.AddWithValue("@Sub_Id", subjEnroll.SubjectID);
cmdInsert.Parameters.AddWithValue("@Date_enroll", subjEnroll.Date_Enroll);
cmdInsert.Parameters.AddWithValue("@Subject_Offer_ID", subjEnroll.SubjectOfferID);
cmdInsert.ExecuteNonQuery();
return("Successfull Added");
}
catch (SqlCeException e)
{
MessageBox.Show(e.Source + "\n" + e.Message + "\n" + e.StackTrace);
return("Fail to Add");
}
}
