public override global::System.Data.DataTable Clone()
{
CustomerDataTable cln = ((CustomerDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private void UpdateCustomerDataTable()
{
try {
string connectionString = ConfigurationManager.ConnectionStrings["db-connection"].ConnectionString;
using (MySqlConnection connection = new MySqlConnection(connectionString)) {
connection.Open();
using (MySqlCommand command = new MySqlCommand("SELECT * FROM customer")) {
using (MySqlDataAdapter customerDataAdapter = new MySqlDataAdapter()) {
command.Connection = connection;
customerDataAdapter.SelectCommand = command;
using (DataTable table = new DataTable()) {
customerDataAdapter.Fill(table);
CustomerDataTable.DataSource = table;
CustomerDataTable.DataBind();
CustomerDataTable.HeaderRow.Cells[0].Text = "Customer ID";
CustomerDataTable.HeaderRow.Cells[1].Text = "Company";
CustomerDataTable.HeaderRow.Cells[2].Text = "Billing Address";
CustomerDataTable.HeaderRow.Cells[3].Text = "Shipping Address";
CustomerDataTable.HeaderRow.Cells[4].Text = "Contact Email";
CustomerDataTable.HeaderRow.Cells[5].Text = "Contact Phone";
CustomerDataTable.HeaderRow.Cells[6].Text = "Sales YTD";
}
}
}
connection.Close();
}
} catch (MySqlException err) {
Response.Write("<script>alert('Connection was interrupted.');</script>");
}
}
public override DataTable Clone()
{
CustomerDataTable cln = ((CustomerDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
internal void InitVars()
{
this.tableCustomer = ((CustomerDataTable)(this.Tables["Customer"]));
if ((this.tableCustomer != null))
{
this.tableCustomer.InitVars();
}
}
private void InitClass()
{
this.DataSetName = "Database";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Database.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomer = new CustomerDataTable();
base.Tables.Add(this.tableCustomer);
}
private void InitClass()
{
this.DataSetName = "custListSet";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/custListSet.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableCustomer = new CustomerDataTable();
this.Tables.Add(this.tableCustomer);
}
internal void InitVars(bool initTable)
{
this.tableCustomer = ((CustomerDataTable)(base.Tables["Customer"]));
if ((initTable == true))
{
if ((this.tableCustomer != null))
{
this.tableCustomer.InitVars();
}
}
}
internal void InitVars()
{
this.tableCustomer = ((CustomerDataTable)(this.Tables["Customer"]));
if ((this.tableCustomer != null))
{
this.tableCustomer.InitVars();
}
this.tableInvoice = ((InvoiceDataTable)(this.Tables["Invoice"]));
if ((this.tableInvoice != null))
{
this.tableInvoice.InitVars();
}
this.relationCustomerInvoice = this.Relations["CustomerInvoice"];
}
internal CustomerRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableCustomer = ((CustomerDataTable)(this.Table));
}
internal CustomerRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableCustomer = ((CustomerDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "CustomersDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/ExcelSampleDataSchema.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomer = new CustomerDataTable();
base.Tables.Add(this.tableCustomer);
}
internal void InitVars(bool initTable) {
this.tableCustomer = ((CustomerDataTable)(base.Tables["Customer"]));
if ((initTable == true)) {
if ((this.tableCustomer != null)) {
this.tableCustomer.InitVars();
}
}
}
internal CustomerRow(DataRowBuilder rb) :
base(rb)
{
this.tableCustomer = ((CustomerDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableCustomer = ((CustomerDataTable)(base.Tables["Customer"]));
if ((initTable == true)) {
if ((this.tableCustomer != null)) {
this.tableCustomer.InitVars();
}
}
this.tableTransaction = ((TransactionDataTable)(base.Tables["Transaction"]));
if ((initTable == true)) {
if ((this.tableTransaction != null)) {
this.tableTransaction.InitVars();
}
}
this.tableAccount = ((AccountDataTable)(base.Tables["Account"]));
if ((initTable == true)) {
if ((this.tableAccount != null)) {
this.tableAccount.InitVars();
}
}
this.relationAccountTransaction = this.Relations["AccountTransaction"];
this.relationCustomerAccount = this.Relations["CustomerAccount"];
}
private void InitClass() {
this.DataSetName = "datasetRetailStore";
this.Prefix = "";
this.Namespace = "http://tempuri.org/datasetRetailStore.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableWarehouse = new WarehouseDataTable();
base.Tables.Add(this.tableWarehouse);
this.tableStock = new StockDataTable();
base.Tables.Add(this.tableStock);
this.tableVendor = new VendorDataTable();
base.Tables.Add(this.tableVendor);
this.tablePurchase = new PurchaseDataTable();
base.Tables.Add(this.tablePurchase);
this.tableProduct = new ProductDataTable();
base.Tables.Add(this.tableProduct);
this.tableCustomer = new CustomerDataTable();
base.Tables.Add(this.tableCustomer);
this.tableSales = new SalesDataTable();
base.Tables.Add(this.tableSales);
this.tablePurchase_Reciept = new Purchase_RecieptDataTable();
base.Tables.Add(this.tablePurchase_Reciept);
}
internal void InitVars(bool initTable) {
this.tableWarehouse = ((WarehouseDataTable)(base.Tables["Warehouse"]));
if ((initTable == true)) {
if ((this.tableWarehouse != null)) {
this.tableWarehouse.InitVars();
}
}
this.tableStock = ((StockDataTable)(base.Tables["Stock"]));
if ((initTable == true)) {
if ((this.tableStock != null)) {
this.tableStock.InitVars();
}
}
this.tableVendor = ((VendorDataTable)(base.Tables["Vendor"]));
if ((initTable == true)) {
if ((this.tableVendor != null)) {
this.tableVendor.InitVars();
}
}
this.tablePurchase = ((PurchaseDataTable)(base.Tables["Purchase"]));
if ((initTable == true)) {
if ((this.tablePurchase != null)) {
this.tablePurchase.InitVars();
}
}
this.tableProduct = ((ProductDataTable)(base.Tables["Product"]));
if ((initTable == true)) {
if ((this.tableProduct != null)) {
this.tableProduct.InitVars();
}
}
this.tableCustomer = ((CustomerDataTable)(base.Tables["Customer"]));
if ((initTable == true)) {
if ((this.tableCustomer != null)) {
this.tableCustomer.InitVars();
}
}
this.tableSales = ((SalesDataTable)(base.Tables["Sales"]));
if ((initTable == true)) {
if ((this.tableSales != null)) {
this.tableSales.InitVars();
}
}
this.tablePurchase_Reciept = ((Purchase_RecieptDataTable)(base.Tables["Purchase Reciept"]));
if ((initTable == true)) {
if ((this.tablePurchase_Reciept != null)) {
this.tablePurchase_Reciept.InitVars();
}
}
}
private void InitClass() {
this.DataSetName = "AFIPartsDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/AFIPartsDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomer = new CustomerDataTable();
base.Tables.Add(this.tableCustomer);
this.tablePartCustLink = new PartCustLinkDataTable();
base.Tables.Add(this.tablePartCustLink);
this.tablePO = new PODataTable();
base.Tables.Add(this.tablePO);
this.tableSTATES = new STATESDataTable();
base.Tables.Add(this.tableSTATES);
this.tableCustBillShipAddr = new CustBillShipAddrDataTable();
base.Tables.Add(this.tableCustBillShipAddr);
this.tableColor = new ColorDataTable();
base.Tables.Add(this.tableColor);
this.tableParts = new PartsDataTable();
base.Tables.Add(this.tableParts);
this.tableLINESPEED = new LINESPEEDDataTable();
base.Tables.Add(this.tableLINESPEED);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
}
internal void InitVars(bool initTable) {
this.tableCustomer = ((CustomerDataTable)(base.Tables["Customer"]));
if ((initTable == true)) {
if ((this.tableCustomer != null)) {
this.tableCustomer.InitVars();
}
}
this.tablePartCustLink = ((PartCustLinkDataTable)(base.Tables["PartCustLink"]));
if ((initTable == true)) {
if ((this.tablePartCustLink != null)) {
this.tablePartCustLink.InitVars();
}
}
this.tablePO = ((PODataTable)(base.Tables["PO"]));
if ((initTable == true)) {
if ((this.tablePO != null)) {
this.tablePO.InitVars();
}
}
this.tableSTATES = ((STATESDataTable)(base.Tables["STATES"]));
if ((initTable == true)) {
if ((this.tableSTATES != null)) {
this.tableSTATES.InitVars();
}
}
this.tableCustBillShipAddr = ((CustBillShipAddrDataTable)(base.Tables["CustBillShipAddr"]));
if ((initTable == true)) {
if ((this.tableCustBillShipAddr != null)) {
this.tableCustBillShipAddr.InitVars();
}
}
this.tableColor = ((ColorDataTable)(base.Tables["Color"]));
if ((initTable == true)) {
if ((this.tableColor != null)) {
this.tableColor.InitVars();
}
}
this.tableParts = ((PartsDataTable)(base.Tables["Parts"]));
if ((initTable == true)) {
if ((this.tableParts != null)) {
this.tableParts.InitVars();
}
}
this.tableLINESPEED = ((LINESPEEDDataTable)(base.Tables["LINESPEED"]));
if ((initTable == true)) {
if ((this.tableLINESPEED != null)) {
this.tableLINESPEED.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
}
private void InitClass() {
this.DataSetName = "ATM";
this.Prefix = "";
this.Namespace = "http://tempuri.org/ATM.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomer = new CustomerDataTable();
base.Tables.Add(this.tableCustomer);
this.tableTransaction = new TransactionDataTable();
base.Tables.Add(this.tableTransaction);
this.tableAccount = new AccountDataTable();
base.Tables.Add(this.tableAccount);
this.relationAccountTransaction = new System.Data.DataRelation("AccountTransaction", new System.Data.DataColumn[] {
this.tableAccount.AccountNumberColumn}, new System.Data.DataColumn[] {
this.tableTransaction.AccountNumberColumn}, false);
this.Relations.Add(this.relationAccountTransaction);
this.relationCustomerAccount = new System.Data.DataRelation("CustomerAccount", new System.Data.DataColumn[] {
this.tableCustomer.CustomerNumberColumn}, new System.Data.DataColumn[] {
this.tableAccount.CustomerNumberColumn}, false);
this.Relations.Add(this.relationCustomerAccount);
}
