public Enrollment SendUserEnrollment(DataTable dataTableEnrollment) { Enrollment enrollment = new Enrollment(); enrollment.Id = Convert.ToInt32(dataTableEnrollment.Rows[0]["Id"]); enrollment.Lapse.Id = Convert.ToInt32(dataTableEnrollment.Rows[0]["LapseId"]); enrollment.Lapse.Name = dataTableEnrollment.Rows[0]["LapseName"].ToString(); return enrollment; }
protected Enrollment CreateEnrollment() { Lapse lapse = new Lapse(); Enrollment enrollment = new Enrollment(); lapse = lapseData.SendLapse(lapseData.DataTableLapseOn()); enrollment.UserName = Session["User-UserName"].ToString(); enrollment.Lapse = lapse; if (lapse == null) return null; else return enrollment; }
public void UpdateEnrollment(Enrollment enrollment) { SqlConnection connection = ManageDatabaseConnection("Open"); using (SqlCommand update = new SqlCommand(@"UpdateEnrollment", connection)) { update.CommandType = CommandType.StoredProcedure; update.Parameters.Add("@UserName", SqlDbType.VarChar).Value = enrollment.UserName; update.Parameters.Add("@LapseId", SqlDbType.Int).Value = enrollment.Lapse.Id; update.Parameters.Add("@LapseName", SqlDbType.VarChar).Value = enrollment.Lapse.Name; update.ExecuteNonQuery(); } connection = ManageDatabaseConnection("Close"); }
protected void InsertEnrollment(Enrollment enrollment) { if (enrollment == null) buttonStyle.buttonStyleRed(buttonErrors, "No lapse active you can't create your enrollment."); else { try { enrollmentData.InsertEnrollment(enrollment); buttonActivateEnrollment.Visible = true; buttonCreateEnrollment.Visible = false; buttonStyle.buttonStyleBlue(buttonErrors, "Enrollment created succesfull."); SetEnrollmentValues(); } catch (Exception) { buttonStyle.buttonStyleRed(buttonErrors, "Ops an error ocurred creating your enrollment." + "\n" + "Please, try again."); } } }
protected void ActivateEnrollment(Enrollment enrollment) { if (enrollment != null) { try { enrollmentData.UpdateEnrollment(enrollment); SetEnrollmentValues(); buttonActivateEnrollment.Disabled = true; buttonStyle.buttonStyleBlue(buttonErrors, "Enrollment activated successful"); } catch (Exception) { buttonStyle.buttonStyleRed(buttonErrors, "Ops an error ocurred activating your enrollment." + "\n" + "Please, try again."); } } else { buttonStyle.buttonStyleRed(buttonErrors, "You can't activate your enrollment." + "/n" + "Please, wait one week before begin the period."); } }