protected override object FillRecord(object[] fields)
{
CustomersVerticalBar record = new CustomersVerticalBar();
record.CustomerID = (string)fields[0];
record.CompanyName = (string)fields[1];
record.ContactName = (string)fields[2];
record.ContactTitle = (string)fields[3];
record.Address = (string)fields[4];
record.City = (string)fields[5];
record.Country = (string)fields[6];
return(record);
}
protected override object FillRecord(object[] fields)
{
CustomersVerticalBar record = new CustomersVerticalBar();
record.CustomerID = (string) fields[0];
record.CompanyName = (string) fields[1];
record.ContactName = (string) fields[2];
record.ContactTitle = (string) fields[3];
record.Address = (string) fields[4];
record.City = (string) fields[5];
record.Country = (string) fields[6];
return record;
}
public override object ValuesToRecord(object[] values)
{
CustomersVerticalBar res = new CustomersVerticalBar();
res.CustomerID = values[0].ToString();
res.CompanyName = values[1].ToString();
res.ContactName = values[2].ToString();
res.ContactTitle = values[3].ToString();
res.Address = values[4].ToString();
res.City = values[5].ToString();
res.Country = values[6].ToString();
return(res);
}
public override object ValuesToRecord(object[] values)
{
CustomersVerticalBar res = new CustomersVerticalBar();
res.CustomerID = values[0].ToString();
res.CompanyName = values[1].ToString();
res.ContactName = values[2].ToString();
res.ContactTitle = values[3].ToString();
res.Address = values[4].ToString();
res.City = values[5].ToString();
res.Country = values[6].ToString();
return res;
}
protected override string GetInsertSql(object record)
{
CustomersVerticalBar obj = (CustomersVerticalBar)record;
return(String.Format("INSERT INTO CustomersTemp (Address, City, CompanyName, ContactName, ContactTitle, Country, CustomerID) " +
" VALUES ( \"{0}\" , \"{1}\" , \"{2}\" , \"{3}\" , \"{4}\" , \"{5}\" , \"{6}\" ); ",
obj.Address,
obj.City,
obj.CompanyName,
obj.ContactName,
obj.ContactTitle,
obj.Country,
obj.CustomerID
));
}
public override object[] RecordToValues(object record)
{
CustomersVerticalBar rec = (CustomersVerticalBar)record;
object[] values = new object[7];
values[0] = rec.CustomerID;
values[1] = rec.CompanyName;
values[2] = rec.ContactName;
values[3] = rec.ContactTitle;
values[4] = rec.Address;
values[5] = rec.City;
values[6] = rec.Country;
return(values);
}
public bool IsEqualRecord(object record)
{
CustomersVerticalBar rec = (CustomersVerticalBar)record;
return(this.CustomerID == rec.CustomerID);
}