public Session() { if (customerList == null) { customerList = SQLData.getInstance().getAllCustomers(); } }
public bool saveCustomer(Customer c) { bool result = true; result = EConnectData.getInstance().createOrUpdateCustomer(c); result = SQLData.getInstance().saveOrUpdate(c); return(result); }
public Customer getCustomer(String customerCode) { Customer c = EConnectData.getInstance().getCustomer(customerCode); if (c == null) { return(null); } c = SQLData.getInstance().getCustomer(c); return(c); }
//This transaction appends several extender sql statements into one transaction public bool saveOrUpdate(Customer c) { bool status = true; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); //DONT PROCESS IF THIS IS FALSE if (c.OfficiallyEnrolled == null) { return(false); } //Create Extender SQLString string sqlString = SQLData.beginExtenderTransaction(c.CustomerID); if (c.FirstName != null) { sqlString += SQLData.addExtenderString(c.FirstName, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.FIRSTNAME_FIELD_ID); } if (c.MiddleName != null) { sqlString += SQLData.addExtenderString(c.MiddleName, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.MIDDLENAME_FIELD_ID); } if (c.LastName != null) { sqlString += SQLData.addExtenderString(c.LastName, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.LASTNAME_FIELD_ID); } if (c.EmailAddress != null) { sqlString += SQLData.addExtenderString(c.EmailAddress, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.EMAIL_FIELD_ID); } if ((c.Birthday != null) && !(c.Birthday.Equals(new DateTime()))) { sqlString += SQLData.addExtenderDate(Convert.ToDateTime(c.Birthday), Constants.WINDOW_EXT_ID, c.CustomerID, Constants.BIRTHDAY_FIELD_ID); } if ((c.LastEnrolledDate != null) && !(c.LastEnrolledDate.Equals(new DateTime()))) { sqlString += SQLData.addExtenderDate(c.LastEnrolledDate, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.LASTENROLLEDDATE_FIELD_ID); } if (c.OfficiallyEnrolled != null) { sqlString += SQLData.addExtenderString(c.OfficiallyEnrolled, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.ENROLLED_FIELD_ID); } if (c.Level != null) { sqlString += SQLData.addExtenderString(c.Level, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.LEVEL_FIELD_ID); } if (c.Section != null) { sqlString += SQLData.addExtenderString(c.Section, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.SECTION_FIELD_ID); } if (c.Nationality != null) { sqlString += SQLData.addExtenderString(c.Nationality, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.NATIONALITY_FIELD_ID); } if (c.LastSchAttended != null) { sqlString += SQLData.addExtenderString(c.LastSchAttended, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.LASTSCHOOL_FIELD_ID); } if (c.Gender != null) { sqlString += SQLData.addExtenderString(c.Gender, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.GENDER_FIELD_ID); } if (c.Religion != null) { sqlString += SQLData.addExtenderString(c.Religion, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.RELIGION_FIELD_ID); } if (c.PlaceOfBirth != null) { sqlString += SQLData.addExtenderString(c.PlaceOfBirth, Constants.WINDOW_EXT_ID, c.CustomerID, Constants.PLACEOFBIRTH_FIELD_ID); } sqlString += SQLData.endExtenderTransaction(); try { SqlCommand cmd = new SqlCommand(sqlString, connection); cmd.ExecuteNonQuery(); } catch (Exception e) { status = false; Console.WriteLine(e); } } return(status); }
public List <Customer> getAllCustomers() { return(SQLData.getInstance().getAllCustomers()); }