public List <JCS_DataInterface.Models.Customer.CustomerAccount> dbSearch(string searchKey)
{
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_sqlConn.GetParameter("middlename", searchKey));
parameters.Add(_sqlConn.GetParameter("lastname", searchKey));
parameters.Add(_sqlConn.GetParameter("firstname", searchKey));
parameters.Add(_sqlConn.GetParameter("company", searchKey));
List <JCS_DataInterface.Models.Customer.CustomerAccount> result = new List <JCS_DataInterface.Models.Customer.CustomerAccount>();
JCS_DataInterface.Models.Customer.CustomerAccount resultItem = new JCS_DataInterface.Models.Customer.CustomerAccount();
try
{
using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT CustomerID ,FirstName ,MiddleName ,LastName ,Address ,Company ,ClosestBranch ,PhoneNumber ,BusinessPhone ,Email ,isVIP ,AccountNumber FROM Customer_Accounts wHERE middlename LIKE '%'+@middlename+'%' OR firstname LIKE '%'+@firstname+'%' OR lastname LIKE '%'+@lastname+'%' OR company LIKE '%'+@company+'%'", parameters, System.Data.CommandType.Text))
{
while (dataReader.Read())
{
resultItem = new Models.Customer.CustomerAccount();
resultItem._customerID = dataReader["CustomerID"].ToString();
resultItem._firstname = dataReader["FirstName"].ToString();
resultItem._middlename = dataReader["MiddleName"].ToString();
resultItem._lastname = dataReader["LastName"].ToString();
resultItem._address = dataReader["Address"].ToString();
resultItem._company = dataReader["Company"].ToString();
resultItem._closestBranch = dataReader["ClosestBranch"].ToString();
resultItem._phoneNumber = dataReader["PhoneNumber"].ToString();
resultItem._businessPhone = dataReader["BusinessPhone"].ToString();
resultItem._email = dataReader["Email"].ToString();
resultItem._isVIP = dataReader["isVIP"].ToString();
resultItem._accountNumber = dataReader["AccountNumber"].ToString();
result.Add(resultItem);
}
return(result);
}
}
catch (Exception ex)
{
resultItem._firstname = "Error on JCS_DataInterface.iCustomerAccount.dbSearch :=> " + ex.Message.ToString();
result.Add(resultItem);
return(result);
}
}
public JCS_DataInterface.Models.Customer.CustomerAccount dbGet(string collection_type_code)
{
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_sqlConn.GetParameter("CustomerID", this._customerID));
JCS_DataInterface.Models.Customer.CustomerAccount result = new JCS_DataInterface.Models.Customer.CustomerAccount();
try
{
using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT SELECT CustomerID ,FirstName ,MiddleName ,LastName ,Address ,Company ,ClosestBranch ,PhoneNumber ,BusinessPhone ,Email ,isVIP ,AccountNumber FROM Customer_Accounts WHERE CustomerID = @CustomerID", parameters, System.Data.CommandType.Text))
{
while (dataReader.Read())
{
result = new Models.Customer.CustomerAccount();
result._customerID = dataReader["CustomerID"].ToString();
result._firstname = dataReader["FirstName"].ToString();
result._middlename = dataReader["MiddleName"].ToString();
result._lastname = dataReader["LastName"].ToString();
result._address = dataReader["Address"].ToString();
result._company = dataReader["Company"].ToString();
result._closestBranch = dataReader["ClosestBranch"].ToString();
result._phoneNumber = dataReader["PhoneNumber"].ToString();
result._businessPhone = dataReader["BusinessPhone"].ToString();
result._email = dataReader["Email"].ToString();
result._isVIP = dataReader["isVIP"].ToString();
result._accountNumber = dataReader["AccountNumber"].ToString();
return(result);
}
}
}
catch (Exception ex)
{
result._firstname = "Error on JCS_DataInterface.iCustomerAccount.dbGet :=> " + ex.Message.ToString();
return(result);
}
result._firstname = "No Records Found";
return(result);
}
