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