} // end RetrieveData
/// <summary>
/// creates a single cCustomer from database
/// </summary>
/// <param name="retrieveType">way to retieve data</param>
/// <param name="custId">ID for customer to create</param>
/// <returns>cCustomer</returns>
public static cCustomer RetrieveData(retrieveCustomerData retrieveType, int custId)
{
List <ParamStruct> paramList = new List <ParamStruct>();
ParamStruct param0 = new ParamStruct("@customerId", custId, DbType.Int32, 4, ParameterDirection.Input);
paramList.Add(param0);
ParamStruct param1 = new ParamStruct("@retrieveType", retrieveType, DbType.Int32, 4, ParameterDirection.Input);
paramList.Add(param1);
string sproc = "retrieveCustomerData";
DbDataReader dr = DAL.DAL.ReadData(sproc, paramList);
List <cCustomer> customerList = Repackage(dr, retrieveType);
if (customerList.Count == 0)
{
throw new DataException("No Records Found");
}
else
{
return(customerList[0]);
}
} // end RetriveData - Customer detail
public static cCustomer Retrieve(int customerId, retrieveCustomerData retrieveType)
{
if (customerId == 0)
{
throw new Exception("You must enter a valid customer ID.");
}
return(cCustomerSQL.RetrieveData(retrieveType, customerId));
}
} // end RetriveData - Customer detail
/// <summary>
/// gets the lookup for the cCustomer
/// </summary>
/// <param name="type">way to retrive data</param>
/// <param name="startswith">charecters that the customer's name starts with</param>
/// <returns>list of cCustomers</returns>
public static List <cCustomer> retrieveSearch(retrieveCustomerData type, string startswith)
{
List <ParamStruct> paramList = new List <ParamStruct>();
ParamStruct param0 = new ParamStruct("@startswith", startswith, DbType.String, 4, ParameterDirection.Input);
paramList.Add(param0);
ParamStruct param1 = new ParamStruct("@retrieveType", type, DbType.Int32, 20, ParameterDirection.Input);
paramList.Add(param1);
string sproc = "retrieveCustomerData";
DbDataReader dr = DAL.DAL.ReadData(sproc, paramList);
List <cCustomer> customerList = Repackage(dr, type);
return(customerList);
}
public static List <cCustomer> Retrieve(retrieveCustomerData retrieveType)
{
return(cCustomerSQL.RetrieveData(retrieveType));
}
} // end InsertData
/// <summary>
/// Uses database data to create cCustomer Objects
/// </summary>
/// <param name="datareader">data reader containing the table data</param>
/// <param name="retrieve">way to retrieve data</param>
/// <returns>list of cCustomers</returns>
private static List <cCustomer> Repackage(IDataReader datareader, retrieveCustomerData retrieve)
{
using (datareader)
{
List <cCustomer> custList = new List <cCustomer>();
while (datareader.Read())
{
cCustomer cust = cCustomer.Create();
switch (retrieve)
{
case retrieveCustomerData.getCustomerIdName:
cust.CustomerId = (int)datareader["customerId"];
if (datareader["name"] == DBNull.Value)
{
cust.Name = (string)datareader["contactFirstName"] + ' ' + (string)datareader["contactLastName"];
}
else
{
cust.Name = (string)datareader["name"];
}
break;
case retrieveCustomerData.getCustomerDetail:
case retrieveCustomerData.getCustomerLookup:
cust.CustomerId = (int)datareader["customerId"];
if (datareader["name"] == DBNull.Value)
{
cust.Name = (string)datareader["contactFirstName"] + ' ' + (string)datareader["contactLastName"];
}
else
{
cust.Name = (string)datareader["name"];
}
cust.ContactFirstName = (string)datareader["contactFirstName"];
cust.ContactLastName = (string)datareader["contactLastName"];
cust.ContactNumber = (string)datareader["contactNumber"];
cust.Street = (string)datareader["street"];
cust.City = (string)datareader["city"];
cust.Prov = (string)datareader["prov"];
cust.PostalCode = (string)datareader["postalCode"];
cust.CreditCheck = (bool)datareader["creditCheck"];
cust.AccountNumber = (string)datareader["accountNumber"];
cust.AccountType = (string)datareader["accountType"];
cust.AccountExp = (DateTime)datareader["accountExpiry"];
cust.AccountLimit = (decimal)datareader["accountLimit"];
if (cust.CreditCheck == true)
{
cust.BankName = (string)datareader["bankName"];
cust.Branch = (string)datareader["branch"];
cust.BankContactName1 = (string)datareader["bankContactName1"];
cust.BankContactName2 = (string)datareader["bankContactName2"];
cust.BankContactNumber = (string)datareader["bankContactNumber"];
cust.BankStreet = (string)datareader["bankStreet"];
cust.BankCity = (string)datareader["bankCity"];
cust.BankProv = (string)datareader["bankProv"];
cust.BankPostalCode = (string)datareader["bankPostalCode"];
}
break;
} // end switch
cust.Trusted = false;
custList.Add(cust);
} // end while
datareader.Close();
return(custList);
} //end using
} // end Repackage