public objVendor Select(string vendorURL)
{
objVendor o = new objVendor();
IDataReader idr = db.Select(vendorURL);
o = Select_Obj(idr);
return(o);
}
public objVendor SelectByVendorAccountId(int vendorAccountId)
{
objVendor o = new objVendor();
IDataReader idr = db.SelectByVendorAccountId(vendorAccountId);
o = Select_Obj(idr);
return(o);
}
public void Add(objVendor i)
{
int vendorId = db.Add(
i.vendorId, i.vendorCode, i.vendorURL, i.vendorTitle, i.vendorDescription, i.vendorProductType, i.vendorAddressLine1, i.vendorAddressLine2, i.vendorCity, i.vendorZip, i.vendorState, i.vendorStateShortcode, i.vendorCountry, i.vendorCountryShortcode, i.vendorIsActive, i.vendorEmail, i.vendorEmailAlt, i.vendorPhone, i.vendorPhoneAlt, i.vendorMinQty, i.vendorMaxQty, i.vendorOrderIntimationEmal, i.vendorSampleIntimationEmail, i.vendorFTP, i.vendorFtpUsername, i.vendorFtpPassword, i.vendorSendOnFtp, i.vendorFirstName, i.vendorLastName, i.vendorAccountId, i.vendorCreatedOn, i.vendorCreatedBy, i.vendorCreatedIP);
//iBiz.Integration.FinWithErp.Vendors bIVendors = new Integration.FinWithErp.Vendors();
//bIVendors.Create_Account(vendorId);
}
private objVendor Select_Obj(IDataReader idr)
{
objVendor o = new objVendor();
bool rtNull = true;
if (idr != null)
{
while (idr.Read())
{
rtNull = false;
if (idr["vendorId"] != DBNull.Value)
{
o.vendorId = Convert.ToInt32(idr["vendorId"]);
}
if (idr["vendorCode"] != DBNull.Value)
{
o.vendorCode = Convert.ToString(idr["vendorCode"]);
}
if (idr["vendorURL"] != DBNull.Value)
{
o.vendorURL = Convert.ToString(idr["vendorURL"]);
}
if (idr["vendorTitle"] != DBNull.Value)
{
o.vendorTitle = Convert.ToString(idr["vendorTitle"]);
}
if (idr["vendorDescription"] != DBNull.Value)
{
o.vendorDescription = Convert.ToString(idr["vendorDescription"]);
}
if (idr["vendorProductType"] != DBNull.Value)
{
o.vendorProductType = Convert.ToInt32(idr["vendorProductType"]);
}
if (idr["vendorAddressLine1"] != DBNull.Value)
{
o.vendorAddressLine1 = Convert.ToString(idr["vendorAddressLine1"]);
}
if (idr["vendorAddressLine2"] != DBNull.Value)
{
o.vendorAddressLine2 = Convert.ToString(idr["vendorAddressLine2"]);
}
if (idr["vendorCity"] != DBNull.Value)
{
o.vendorCity = Convert.ToString(idr["vendorCity"]);
}
if (idr["vendorZip"] != DBNull.Value)
{
o.vendorZip = Convert.ToString(idr["vendorZip"]);
}
if (idr["vendorState"] != DBNull.Value)
{
o.vendorState = Convert.ToString(idr["vendorState"]);
}
if (idr["vendorStateShortcode"] != DBNull.Value)
{
o.vendorStateShortcode = Convert.ToString(idr["vendorStateShortcode"]);
}
if (idr["vendorCountry"] != DBNull.Value)
{
o.vendorCountry = Convert.ToString(idr["vendorCountry"]);
}
if (idr["vendorCountryShortcode"] != DBNull.Value)
{
o.vendorCountryShortcode = Convert.ToString(idr["vendorCountryShortcode"]);
}
if (idr["vendorIsActive"] != DBNull.Value)
{
o.vendorIsActive = Convert.ToBoolean(idr["vendorIsActive"]);
}
if (idr["vendorEmail"] != DBNull.Value)
{
o.vendorEmail = Convert.ToString(idr["vendorEmail"]);
}
if (idr["vendorEmailAlt"] != DBNull.Value)
{
o.vendorEmailAlt = Convert.ToString(idr["vendorEmailAlt"]);
}
if (idr["vendorPhone"] != DBNull.Value)
{
o.vendorPhone = Convert.ToString(idr["vendorPhone"]);
}
if (idr["vendorPhoneAlt"] != DBNull.Value)
{
o.vendorPhoneAlt = Convert.ToString(idr["vendorPhoneAlt"]);
}
if (idr["vendorMinQty"] != DBNull.Value)
{
o.vendorMinQty = Convert.ToInt32(idr["vendorMinQty"]);
}
if (idr["vendorMaxQty"] != DBNull.Value)
{
o.vendorMaxQty = Convert.ToInt32(idr["vendorMaxQty"]);
}
if (idr["vendorOrderIntimationEmal"] != DBNull.Value)
{
o.vendorOrderIntimationEmal = Convert.ToString(idr["vendorOrderIntimationEmal"]);
}
if (idr["vendorSampleIntimationEmail"] != DBNull.Value)
{
o.vendorSampleIntimationEmail = Convert.ToString(idr["vendorSampleIntimationEmail"]);
}
if (idr["vendorFTP"] != DBNull.Value)
{
o.vendorFTP = Convert.ToString(idr["vendorFTP"]);
}
if (idr["vendorFtpUsername"] != DBNull.Value)
{
o.vendorFtpUsername = Convert.ToString(idr["vendorFtpUsername"]);
}
if (idr["vendorFtpPassword"] != DBNull.Value)
{
o.vendorFtpPassword = Convert.ToString(idr["vendorFtpPassword"]);
}
if (idr["vendorSendOnFtp"] != DBNull.Value)
{
o.vendorSendOnFtp = Convert.ToBoolean(idr["vendorSendOnFtp"]);
}
if (idr["vendorFirstName"] != DBNull.Value)
{
o.vendorFirstName = idr["vendorFirstName"].ToString();
}
if (idr["vendorLastName"] != DBNull.Value)
{
o.vendorLastName = idr["vendorLastName"].ToString();
}
if (idr["vendorAccountId"] != DBNull.Value)
{
o.vendorAccountId = Convert.ToInt32(idr["vendorAccountId"]);
}
if (idr["vendorCreatedOn"] != DBNull.Value)
{
o.vendorCreatedOn = Convert.ToDateTime(idr["vendorCreatedOn"]);
}
if (idr["vendorCreatedBy"] != DBNull.Value)
{
o.vendorCreatedBy = Convert.ToInt32(idr["vendorCreatedBy"]);
}
if (idr["vendorCreatedIP"] != DBNull.Value)
{
o.vendorCreatedIP = Convert.ToString(idr["vendorCreatedIP"]);
}
}
}
if (rtNull)
{
o = null;
}
return(o);
}
public void Update(objVendor i)
{
db.Update(
i.vendorId, i.vendorCode, i.vendorURL, i.vendorTitle, i.vendorDescription, i.vendorProductType, i.vendorAddressLine1, i.vendorAddressLine2, i.vendorCity, i.vendorZip, i.vendorState, i.vendorStateShortcode, i.vendorCountry, i.vendorCountryShortcode, i.vendorIsActive, i.vendorEmail, i.vendorEmailAlt, i.vendorPhone, i.vendorPhoneAlt, i.vendorMinQty, i.vendorMaxQty, i.vendorOrderIntimationEmal, i.vendorSampleIntimationEmail, i.vendorFTP, i.vendorFtpUsername, i.vendorFtpPassword, i.vendorSendOnFtp, i.vendorFirstName, i.vendorLastName, i.vendorAccountId, i.vendorCreatedOn, i.vendorCreatedBy, i.vendorCreatedIP);
}
