public objCustomer SelectByCustomerAccountId(int customerAccountId)
{
IDataReader idr = db.SelectByCustomerAccountId(customerAccountId);
objCustomer rt = new objCustomer();
rt = Select_Obj(idr);
return(rt);
}
public objCustomer Select(string customerURL)
{
objCustomer o = new objCustomer();
IDataReader idr = db.Select(customerURL);
o = Select_Obj(idr);
return(o);
}
public objCustomer Select(int customerId)
{
objCustomer o = new objCustomer();
IDataReader idr = db.Select(customerId);
o = Select_Obj(idr);
return(o);
}
public void Add(objCustomer i)
{
int customerId = db.Add(
i.customerId, i.customerCode, i.customerURL, i.customerTitle, i.customerDescription, i.customerProductType, i.customerAddressLine1, i.customerAddressLine2, i.customerCity, i.customerZip, i.customerState, i.customerStateShortcode, i.customerCountry, i.customerCountryShortcode, i.customerIsActive, i.customerEmail, i.customerEmailAlt, i.customerPhone, i.customerPhoneAlt, i.customerMinQty, i.customerMaxQty, i.customerOrderIntimationEmal, i.customerSampleIntimationEmail, i.customerFTP, i.customerFtpUsername, i.customerFtpPassword, i.customerSendOnFtp, i.customerFirstName, i.customerLastName, i.customerAccountId, i.customerCreatedOn, i.customerCreatedBy, i.customerCreatedIP);
//Integration.FinWithErp.Customers bICustomer = new Integration.FinWithErp.Customers();
//bICustomer.Create_Account(customerId);
}
private objCustomer Select_Obj(IDataReader idr)
{
objCustomer o = new objCustomer();
bool rtNull = true;
if (idr != null)
{
while (idr.Read())
{
rtNull = false;
if (idr["customerId"] != DBNull.Value)
{
o.customerId = Convert.ToInt32(idr["customerId"]);
}
if (idr["customerCode"] != DBNull.Value)
{
o.customerCode = Convert.ToString(idr["customerCode"]);
}
if (idr["customerURL"] != DBNull.Value)
{
o.customerURL = Convert.ToString(idr["customerURL"]);
}
if (idr["customerTitle"] != DBNull.Value)
{
o.customerTitle = Convert.ToString(idr["customerTitle"]);
}
if (idr["customerDescription"] != DBNull.Value)
{
o.customerDescription = Convert.ToString(idr["customerDescription"]);
}
if (idr["customerProductType"] != DBNull.Value)
{
o.customerProductType = Convert.ToInt32(idr["customerProductType"]);
}
if (idr["customerAddressLine1"] != DBNull.Value)
{
o.customerAddressLine1 = Convert.ToString(idr["customerAddressLine1"]);
}
if (idr["customerAddressLine2"] != DBNull.Value)
{
o.customerAddressLine2 = Convert.ToString(idr["customerAddressLine2"]);
}
if (idr["customerCity"] != DBNull.Value)
{
o.customerCity = Convert.ToString(idr["customerCity"]);
}
if (idr["customerZip"] != DBNull.Value)
{
o.customerZip = Convert.ToString(idr["customerZip"]);
}
if (idr["customerState"] != DBNull.Value)
{
o.customerState = Convert.ToString(idr["customerState"]);
}
if (idr["customerStateShortcode"] != DBNull.Value)
{
o.customerStateShortcode = Convert.ToString(idr["customerStateShortcode"]);
}
if (idr["customerCountry"] != DBNull.Value)
{
o.customerCountry = Convert.ToString(idr["customerCountry"]);
}
if (idr["customerCountryShortcode"] != DBNull.Value)
{
o.customerCountryShortcode = Convert.ToString(idr["customerCountryShortcode"]);
}
if (idr["customerIsActive"] != DBNull.Value)
{
o.customerIsActive = Convert.ToBoolean(idr["customerIsActive"]);
}
if (idr["customerEmail"] != DBNull.Value)
{
o.customerEmail = Convert.ToString(idr["customerEmail"]);
}
if (idr["customerEmailAlt"] != DBNull.Value)
{
o.customerEmailAlt = Convert.ToString(idr["customerEmailAlt"]);
}
if (idr["customerPhone"] != DBNull.Value)
{
o.customerPhone = Convert.ToString(idr["customerPhone"]);
}
if (idr["customerPhoneAlt"] != DBNull.Value)
{
o.customerPhoneAlt = Convert.ToString(idr["customerPhoneAlt"]);
}
if (idr["customerMinQty"] != DBNull.Value)
{
o.customerMinQty = Convert.ToInt32(idr["customerMinQty"]);
}
if (idr["customerMaxQty"] != DBNull.Value)
{
o.customerMaxQty = Convert.ToInt32(idr["customerMaxQty"]);
}
if (idr["customerOrderIntimationEmal"] != DBNull.Value)
{
o.customerOrderIntimationEmal = Convert.ToString(idr["customerOrderIntimationEmal"]);
}
if (idr["customerSampleIntimationEmail"] != DBNull.Value)
{
o.customerSampleIntimationEmail = Convert.ToString(idr["customerSampleIntimationEmail"]);
}
if (idr["customerFTP"] != DBNull.Value)
{
o.customerFTP = Convert.ToString(idr["customerFTP"]);
}
if (idr["customerFtpUsername"] != DBNull.Value)
{
o.customerFtpUsername = Convert.ToString(idr["customerFtpUsername"]);
}
if (idr["customerFtpPassword"] != DBNull.Value)
{
o.customerFtpPassword = Convert.ToString(idr["customerFtpPassword"]);
}
if (idr["customerSendOnFtp"] != DBNull.Value)
{
o.customerSendOnFtp = Convert.ToBoolean(idr["customerSendOnFtp"]);
}
if (idr["customerFirstName"] != DBNull.Value)
{
o.customerFirstName = idr["customerFirstName"].ToString();
}
if (idr["customerLastName"] != DBNull.Value)
{
o.customerLastName = idr["customerLastName"].ToString();
}
if (idr["customerAccountId"] != DBNull.Value)
{
o.customerAccountId = Convert.ToInt32(idr["customerAccountId"]);
}
if (idr["customerCreatedOn"] != DBNull.Value)
{
o.customerCreatedOn = Convert.ToDateTime(idr["customerCreatedOn"]);
}
if (idr["customerCreatedBy"] != DBNull.Value)
{
o.customerCreatedBy = Convert.ToInt32(idr["customerCreatedBy"]);
}
if (idr["customerCreatedIP"] != DBNull.Value)
{
o.customerCreatedIP = Convert.ToString(idr["customerCreatedIP"]);
}
}
}
if (rtNull)
{
o = null;
}
return(o);
}
public void Update(objCustomer i)
{
db.Update(
i.customerId, i.customerCode, i.customerURL, i.customerTitle, i.customerDescription, i.customerProductType, i.customerAddressLine1, i.customerAddressLine2, i.customerCity, i.customerZip, i.customerState, i.customerStateShortcode, i.customerCountry, i.customerCountryShortcode, i.customerIsActive, i.customerEmail, i.customerEmailAlt, i.customerPhone, i.customerPhoneAlt, i.customerMinQty, i.customerMaxQty, i.customerOrderIntimationEmal, i.customerSampleIntimationEmail, i.customerFTP, i.customerFtpUsername, i.customerFtpPassword, i.customerSendOnFtp, i.customerFirstName, i.customerLastName, i.customerAccountId, i.customerCreatedOn, i.customerCreatedBy, i.customerCreatedIP);
}