public IList<CustomerListForDisplay> CustomerListDisplayAdvance(string paramCategory) //List of customers
{
string SQL_str = "Select id" +
",iCustid" +
",vCustName" +
",vCustContactNme" +
",vCustPrimaryPh" +
",vCustPhone2" +
",vCustPhone3" +
",vCustPhone4" +
",vCustFax1" +
",vCustFax2" +
",vCustEmail" +
",vCustAddress1" +
",vCustAddress2" +
",vCustCity" +
",vCustState" +
",vCustCountry" +
",vCustZipCode" +
",vCustBillAddress1" +
",vCustBillAddress2" +
",vCustBillCity" +
",vCustBillCountry" +
",vCustBillZipCode" +
",vCustShipAddress1" +
",vCustShipAddress2" +
",vCustShipCity" +
",vCustShipState" +
",vCustShipCountry" +
",vCustShipZipCode" +
",vCustAccountNum" +
",vCustNote1" +
",vCustNote2" +
",vCustNote3" +
",vCustCategory" +
",vCustComments" +
",vCustStatus" +
",vEntryBy" +
",tTimestamp" +
",POS_Setup_Id" +
" FROM POS_Customer" ;
//Connect to database and retrieve
CustomerListForDisplay Obj = new CustomerListForDisplay();
IList<CustomerListForDisplay> ALLcustomers;
SqlCEDataAccess POSdbAccess = new SqlCEDataAccess();
ALLcustomers = POSdbAccess.connection.ConvertSqlQueryToIList(Obj, SQL_str);
return ALLcustomers;
}
public bool CustomerUpdate(CustomerListForDisplay InputRecordObj) //Update Customer
{
string _vItemStatus = "Publish";
string SQL_str = "Update POS_Customer set " +
"[vCustName]=@vCustName" +
",[vCustContactNme]=@vCustContactNme" +
",[vCustPrimaryPh]=@vCustPrimaryPh" +
",[vCustPhone2]=@vCustPhone2" +
",[vCustPhone3]=@vCustPhone3" +
",[vCustPhone4]=@vCustPhone4" +
",[vCustFax1]=@vCustFax1" +
",[vCustFax2]=@vCustFax2" +
",[vCustEmail]=@vCustEmail" +
",[vCustAddress1]=@vCustAddress1" +
",[vCustAddress2]=@vCustAddress2" +
",[vCustCity]=@vCustCity" +
",[vCustState]=@vCustState" +
",[vCustCountry]=@vCustCountry" +
",[vCustZipCode]=@vCustZipCode" +
",[vCustBillAddress1]=@vCustBillAddress1" +
",[vCustBillAddress2]=@vCustBillAddress2" +
",[vCustBillCity]=@vCustBillCity" +
",[vCustBillCountry]=@vCustBillCountry" +
",[vCustBillZipCode]=@vCustBillZipCode" +
",[vCustShipAddress1]=@vCustShipAddress1" +
",[vCustShipAddress2]=@vCustShipAddress2" +
",[vCustShipCity]=@vCustShipCity" +
",[vCustShipState]=@vCustShipState" +
",[vCustShipCountry]=@vCustShipCountry" +
",[vCustShipZipCode]=@vCustShipZipCode" +
",[vCustAccountNum]=@vCustAccountNum" +
",[vCustNote1]=@vCustNote1" +
",[vCustNote2]=@vCustNote2" +
",[vCustNote3]=@vCustNote3" +
",[vCustCategory]=@vCustCategory" +
",[vCustComments]=@vCustComments" +
",[vCustStatus]=@vCustStatus" +
",[vEntryBy]=@vEntryBy" +
",[tTimestamp]=@tTimestamp" +
" Where id = " + InputRecordObj.Id;
//Connect to database and retrieve
SqlCEDataAccess POSdbAccess = new SqlCEDataAccess();
POSdbAccess.connection.Execute(SQL_str, new {InputRecordObj.vCustName
,InputRecordObj.iCustid
,
InputRecordObj.vCustContactNme
,
InputRecordObj.vCustPrimaryPh
,
InputRecordObj.vCustPhone2
,
InputRecordObj.vCustPhone3
,
InputRecordObj.vCustPhone4
,
InputRecordObj.vCustFax1
,
InputRecordObj.vCustFax2
,
InputRecordObj.vCustEmail
,
InputRecordObj.vCustAddress1
,
InputRecordObj.vCustAddress2
,
InputRecordObj.vCustCity
,
InputRecordObj.vCustState
,
InputRecordObj.vCustCountry
,
InputRecordObj.vCustZipCode
,
InputRecordObj.vCustBillAddress1
,
InputRecordObj.vCustBillAddress2
,
InputRecordObj.vCustBillCity
,
InputRecordObj.vCustBillCountry
,
InputRecordObj.vCustBillZipCode
,
InputRecordObj.vCustShipAddress1
,
InputRecordObj.vCustShipAddress2
,
InputRecordObj.vCustShipCity
,
InputRecordObj.vCustShipState
,
InputRecordObj.vCustShipCountry
,
InputRecordObj.vCustShipZipCode
,
InputRecordObj.vCustAccountNum
,
InputRecordObj.vCustNote1
,
InputRecordObj.vCustNote2
,
InputRecordObj.vCustNote3
,
InputRecordObj.vCustCategory
,
InputRecordObj.vCustComments
,
InputRecordObj.vCustStatus
,
InputRecordObj.vEntryBy
,
InputRecordObj.tTimestamp
});
bool Result;
Result = true;
// DataTable ResultTable;
// Result = POSdbAccess.execScalar(SQL_str);
//ResultTable = ResultSet.Tables[0];
return Result;
}
public bool CustomerAdd(CustomerListForDisplay InputRecordObj) //Add Customer
{
string _vItemStatus = "Publish";
string SQL_str = "Insert Into POS_Customer (id" +
",iCustid" +
",vCustName" +
",vCustContactNme" +
",vCustPrimaryPh" +
",vCustPhone2" +
",vCustPhone3" +
",vCustPhone4" +
",vCustFax1" +
",vCustFax2" +
",vCustEmail" +
",vCustAddress1" +
",vCustAddress2" +
",vCustCity" +
",vCustState" +
",vCustCountry" +
",vCustZipCode" +
",vCustBillAddress1" +
",vCustBillAddress2" +
",vCustBillCity" +
",vCustBillCountry" +
",vCustBillZipCode" +
",vCustShipAddress1" +
",vCustShipAddress2" +
",vCustShipCity" +
",vCustShipState" +
",vCustShipCountry" +
",vCustShipZipCode" +
",vCustAccountNum" +
",vCustNote1" +
",vCustNote2" +
",vCustNote3" +
",vCustCategory" +
",vCustComments" +
",vCustStatus" +
",vEntryBy" +
",tTimestamp" +
",POS_Setup_Id)" +
"Values ( " + "@id" +
",@iCustid" +
",@vCustName" +
",@vCustContactNme" +
",@vCustPrimaryPh" +
",@vCustPhone2" +
",@vCustPhone3" +
",@vCustPhone4" +
",@vCustFax1" +
",@vCustFax2" +
",@vCustEmail" +
",@vCustAddress1" +
",@vCustAddress2" +
",@vCustCity" +
",@vCustState" +
",@vCustCountry" +
",@vCustZipCode" +
",@vCustBillAddress1" +
",@vCustBillAddress2" +
",@vCustBillCity" +
",@vCustBillCountry" +
",@vCustBillZipCode" +
",@vCustShipAddress1" +
",@vCustShipAddress2" +
",@vCustShipCity" +
",@vCustShipState" +
",@vCustShipCountry" +
",@vCustShipZipCode" +
",@vCustAccountNum" +
",@vCustNote1" +
",@vCustNote2" +
",@vCustNote3" +
",@vCustCategory" +
",@vCustComments" +
",@vCustStatus" +
",@vEntryBy" +
",@tTimestamp" +
",@POS_Setup_Id)" ;
//Connect to database and retrieve
SqlCEDataAccess POSdbAccess = new SqlCEDataAccess();
bool Result;
DataTable ResultTable;
Result = POSdbAccess.execScalar(SQL_str);
//ResultTable = ResultSet.Tables[0];
return Result;
}
