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