public PetsizeMapper(MySqlDB db):base(db){
tableName = "petsize_tbl";
id = "id";
fieldsname = new string[]{
"petsize",
};
}
public ProductInspectionMapper(MySqlDB db)
: base(db)
{
tableName = "product_inspection_view";
id = "Item_Code";
fieldsname = new string[] {
"Item_Code",
"Description",
"Category",
"Unit_Price",
"Specification",
"Warranty",
"Replacement_Period",
"Quantity_On_Hand",
};
fieldsname_forselect = new string[] {
"Item_Code",
"Description",
"Category",
"Unit_Price",
"Specification",
"Warranty",
"Replacement_Period",
"Quantity_On_Hand",
};
}
public ProductInventory(MySqlDB db)
: base(db)
{
// This mapper operated on view
tableName = "inventory_view";
fieldsname = new string[] {
"Name",
"Description",
"Barcode",
"Unit_price",
"Qty_on_Hand",
"Qty_Received",
"Stock_since",
"Supplier",
"Category",
"Warranty",
"Replacement"
};
fieldsname_forselect = new string[]{
"Name",
"Qty_on_Hand AS 'Qty on Hand'",
"Qty_Received AS 'Qty received'",
"Stock_since AS 'Stock since'",
};
}
public CategoryMapper(MySqlDB db)
: base(db)
{
tableName = "category";
id = "id";
fieldsname = new string[] {
"category_name",
};
}
public TodaySalesMapper(MySqlDB db)
: base(db)
{
tableName = "sales_today_view";
fieldsname = new string[] {
"Date",
"Total_Sales",
};
}
public InvoiceMapper(MySqlDB db):base(db)
{
tableName = "invoice_tbl";
id = "id";
fieldsname = new string[] {
"date",
"time",
"employee_id",
};
}
public ServiceRenderedMapper(MySqlDB db)
: base(db)
{
tableName = "service_rendered";
fieldsname = new string[]{
"Name",
"Qty",
"Subtotal",
};
}
public AuditTrailMapper(MySqlDB db)
: base(db)
{
tableName = "audit_trail_tbl";
fieldsname = new string[]{
"user_id",
"user_action",
"date_time",
};
}
public FallbackMapper(MySqlDB db)
: base(db)
{
tableName = "fallback_tbl";
id = "id";
fieldsname = new string[] {
"id",
"squery",
};
}
public AuditTrailMapper(MySqlDB db)
: base(db)
{
tableName = "audit_trail_tbl";
fieldsname = new string[]{
"employee_id",
"activity",
"date",
"time",
};
}
public MedicalTransactionMapper(MySqlDB db)
: base(db)
{
tableName = "medical_transaction_tbl";
fieldsname = new string[] {
"medical_id",
"qty",
"subtotal",
"transaction_id",
};
}
public loginTrailViewMapper(MySqlDB db)
: base(db)
{
tableName = "login_trail_view";
fieldsname = new string[]{
"user_id",
"employee_name",
"datetime_in",
"datetime_out",
};
}
public TransactionResult(MySqlDB db)
: base(db)
{
tableName = "receipt_tbl";
id = "id";
fieldsname = new string[] {
"invoice_id",
"net_price",
"cash_tender",
"changed",
};
}
public GroomingPetsizePriceMapper(MySqlDB db)
: base(db)
{
tableName = "grooming_petsize_price_tbl";
id = "id";
fieldsname = new string[] {
"id",
"grooming_id",
"petsize_id",
"price",
};
}
public ProductTransactionMapper(MySqlDB db)
: base(db)
{
tableName = "product_transaction_tbl";
id = "transaction_id";
fieldsname = new string[] {
"transaction_id",
"barcode",
"qty_sold",
"grp_price",
};
}
public GppTransactionMapper(MySqlDB db)
: base(db)
{
tableName = "gpp_transaction_tbl";
id = "gpp_transaction_id";
fieldsname = new string[]{
"transaction_id",
"gpp_id",
"qty",
"subtotal",
};
}
public ProductReturnMapper(MySqlDB mysqlDB)
: base(mysqlDB)
{
tableName = "product_return_tbl";
fieldsname = new string[]
{
"product_invoice_id",
"qty_returned",
"date_returned",
"reason",
};
}
public ProductInvoiceMapper(MySqlDB db)
: base(db)
{
tableName = "product_invoice_tbl";
id = "id";
fieldsname = new string[] {
"invoice_id",
"product_id",
"quantity",
"subtotal",
};
}
public AuditTrailView(MySqlDB db) : base(db)
{
tableName = "audit_trail_view";
fieldsname = new string[] {
"date_time",
"activity",
"user_id",
};
fieldsname_forselect = new string[] {
"activity AS 'Activity'",
"date_time AS 'Date & Time'",
};
}
public ProductMapper(MySqlDB db)
: base(db)
{
tableName = "product_tbl";
id = "id";
fieldsname = new string[] {
"id",
"name",
//"category_id",
"unit_price",
//"source_company_name",
};
}
public MedicalMapper(MySqlDB db)
: base(db)
{
tableName = "medical_tbl";
id = "medical_id";
fieldsname = new string[] {
"medical_id",
"medical_name",
};
fieldsname_forselect = new string[] {
"medical_name AS 'Medical Name'",
};
}
public ProductMapper(MySqlDB db)
: base(db)
{
tableName = "product_tbl";
id = "id";
fieldsname = new string[] {
"id",
"name",
//"category_id",
"unit_price",
//"source_company_name",
};
}
public UserMapper(MySqlDB db)
: base(db)
{
tableName = "user_tbl";
id = "id";
fieldsname = new string[] {
"id",
"password",
"access_level",
"active",
"create_time",
};
}
public MedicalMapper(MySqlDB db)
: base(db)
{
tableName = "medical_tbl";
id = "medical_id";
fieldsname = new string[] {
"medical_id",
"medical_name",
};
fieldsname_forselect = new string[]{
"medical_name AS 'Medical Name'",
};
}
public DailySalesReportMapper(MySqlDB db)
: base(db)
{
tableName = "daily_sales_report";
fieldsname = new string[] {
"date",
"Sales",
};
fieldsname_forselect = new string[] {
"date AS 'Date'",
"Sales",
};
}
public DailySalesReportMapper(MySqlDB db)
: base(db)
{
tableName = "daily_sales_report";
fieldsname = new string[] {
"date",
"Sales",
};
fieldsname_forselect = new string[] {
"date AS 'Date'",
"Sales",
};
}
public GroomingMapper(MySqlDB db)
: base(db)
{
tableName = "grooming_tbl";
id = "grooming_id";
fieldsname = new string[] {
"grooming_id",
"grooming_name",
};
fieldsname_forselect = new string[] {
"grooming_id",
"grooming_name",
};
}
public AuditTrailView(MySqlDB db)
: base(db)
{
tableName = "audit_trail_view";
fieldsname = new string[]{
"date_time",
"activity",
"user_id",
};
fieldsname_forselect = new string[]{
"activity AS 'Activity'",
"date_time AS 'Date & Time'",
};
}
public MonthlySaleReportMapper(MySqlDB db)
: base(db)
{
tableName = "monthly_sales_report";
fieldsname = new string[] {
"Month_index",
"Month",
"Sales",
};
fieldsname = new string[] {
"CONCAT(Month, ', ', Year) AS Date",
"Sales",
};
}
public GroomingMapper(MySqlDB db)
: base(db)
{
tableName = "grooming_tbl";
id = "grooming_id";
fieldsname = new string[] {
"grooming_id",
"grooming_name",
};
fieldsname_forselect = new string[]{
"grooming_id",
"grooming_name",
};
}
public ProductReturnViewMapper(MySqlDB db)
: base(db)
{
tableName = "product_return_view";
fieldsname = new string[] {
"description",
"Qty_returned",
"Price_refunded",
};
fieldsname_forselect = new string[] {
"Description AS Name",
"Qty_returned AS 'Qty returned'",
"Price_refunded AS 'Price refunded'",
};
}
public ProductReturnViewMapper(MySqlDB db)
: base(db)
{
tableName = "product_return_view";
fieldsname = new string[]{
"description",
"Qty_returned",
"Price_refunded",
};
fieldsname_forselect = new string[]{
"Description AS Name",
"Qty_returned AS 'Qty returned'",
"Price_refunded AS 'Price refunded'",
};
}
public GroomingView(MySqlDB db)
: base(db)
{
tableName = "grooming_view";
fieldsname = new string[]{
"grooming_name",
"petsize",
"price",
};
fieldsname_forselect = new string[]{
"grooming_name AS 'Grooming Name'",
"petsize AS Petsize",
"price AS Price",
};
}
public ProductMapper(MySqlDB db)
: base(db)
{
tableName = "product_tbl";
id = "id";
fieldsname = new string[] {
"id",
"name",
"unit_price",
"specification",
"warranty",
"replacement",
"category_id",
};
}
public MonthlySaleReportMapper(MySqlDB db)
: base(db)
{
tableName = "monthly_sales_report";
fieldsname = new string[] {
"Month_index",
"Month",
"Sales",
};
fieldsname = new string[] {
"CONCAT(Month, ', ', Year) AS Date",
"Sales",
};
}
public GroomingView(MySqlDB db)
: base(db)
{
tableName = "grooming_view";
fieldsname = new string[] {
"grooming_name",
"petsize",
"price",
};
fieldsname_forselect = new string[] {
"grooming_name AS 'Grooming Name'",
"petsize AS Petsize",
"price AS Price",
};
}
public ProductMapper(MySqlDB db)
: base(db)
{
tableName = "product_tbl";
id = "id";
fieldsname = new string[] {
"id",
"name",
"unit_price",
"specification",
"warranty",
"replacement",
"category_id",
};
}
public UserMapper(MySqlDB db) : base(db)
{
tableName = "user_tbl";
id = "id";
fieldsname = new string[] {
"id",
"password",
"access_level",
"active",
"create_time",
"session_status",
"fallbackid",
"fallbackans",
};
}
public LoginTrailViewMapper(MySqlDB db)
: base(db)
{
tableName = "login_trail_view";
fieldsname = new string[] {
"employee_name",
"datetime_in",
"datetime_out",
};
fieldsname_forselect = new string[] {
"employee_name AS 'Employee name'",
"datetime_in AS 'Login date & time'",
"datetime_out AS 'Logout date & time'",
};
}
public AuditTrailView(MySqlDB db) : base(db)
{
tableName = "audit_trail_view";
fieldsname = new string[] {
"date",
"time",
"activity",
"user_id",
};
fieldsname_forselect = new string[] {
"user_id AS Employee",
"activity AS Activity",
"date AS Date",
"time AS Time",
};
}
public LoginTrailMapper(MySqlDB db)
: base(db)
{
tableName = "login_trail_tbl";
id = "id";
fieldsname = new string[]{
"user_id",
"datetime_in",
"datetime_out",
};
fieldsname_forselect = new string[]{
"user_id AS User",
"datetime_in AS 'Login DateTime'",
"datetime_out AS 'Logout DateTime'",
};
}
public EmployeeMapper(MySqlDB db) : base(db)
{
tableName = "employee_tbl";
id = "id";
fieldsname = new string[] {
"user_id",
"firstname",
"middlename",
"lastname",
"mobile_no",
"telephone_no",
"email_address",
"address",
"image_path",
};
}
public EmployeeMapper(MySqlDB db):base(db)
{
tableName = "employee_tbl";
id = "id";
fieldsname = new string[] {
"user_id",
"firstname",
"middlename",
"lastname",
"mobile_no",
"telephone_no",
"email_address",
"address",
"image_path",
};
}
public LoginTrailMapper(MySqlDB db)
: base(db)
{
tableName = "login_trail_tbl";
id = "id";
fieldsname = new string[] {
"user_id",
"datetime_in",
"datetime_out",
};
fieldsname_forselect = new string[] {
"user_id AS User",
"datetime_in AS 'Login DateTime'",
"datetime_out AS 'Logout DateTime'",
};
}
public WeeklySalesReport(MySqlDB db)
: base(db)
{
tableName = "weekly_sales_report";
fieldsname = new string[] {
"Date",
"Week",
"Begin",
"End",
"Sales",
};
fieldsname_forselect = new string[] {
"CONCAT(Begin, ' to ', End) AS Date",
"Sales",
};
}
public ProductTransactionView(MySqlDB db)
: base(db)
{
tableName = "product_transaction_view";
fieldsname = new string[] {
"transaction_id",
"description",
"unit_price",
"qty_sold",
"grp_price",
};
fieldsname_forselect = new string[] {
"description",
"unit_price",
"SUM(qty_sold) AS 'Qty sold'",
"SUM(grp_price) AS 'Grp price'",
};
}
//public event EventHandler CustomerAdded;
//MasterController masterController;
public CustomerInformationMapper(MySqlDB db) : base(db)
{
tableName = "customer_tbl";
id = "id";
fieldsname = new string[] {
"firstname",
"middlename",
"lastname",
"mobile_number",
"email_address",
"address"
};
fieldsname_forselect = new string[] {
"firstname AS Firstname",
"middlename AS Middlename",
"lastname AS Lastname",
"mobile_number AS 'Mobile Number'"
};
}
public InventoryMapper(MySqlDB mySqlDb)
: base(mySqlDb)
{
tableName = "inventory_tbl";
id = "id";
fieldsname = new string[] {
"product_id",
"stockin_datetime",
"qty_received",
"qty_onhand",
"supplier",
};
fieldsname_forselect = new string[] {
"product_id AS Barcode",
"stockin_datetime AS 'Stock since'",
"qty_received AS 'Qty on Received'",
"qty_onhand AS 'Qty on Hand'",
};
}
public DatabaseSettings(MySqlDB db)
{
InitializeComponent();
this.mySqlDb = db;
try
{
NetworkBrowser nb = new NetworkBrowser();
foreach (string pc in nb.getNetworkComputers())
{
cmbHost.Items.Add(pc);
}
}
catch (Exception ex)
{
MessageBox.Show("An error occurred trying to access the network computers", "error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
}
public PurchasedProductMapper(MySqlDB db) : base(db)
{
// This mapper operates on another views
tableName = "purchased_product_view";
fieldsname = new string[] {
"Name",
"Barcode",
"Qty_sold",
"unit_price",
"Sales",
"category",
"Company",
};
fieldsname_forselect = new string[] {
"Name",
"unit_price AS 'Price (Peso)'",
"Qty_sold AS 'Qty Sold'",
"Sales AS' Subtotal (Peso)'",
};
}
public ProductInventory(MySqlDB db)
: base(db)
{
// This mapper operated on view
tableName = "inventory_view";
fieldsname = new string[] {
"Name",
"Barcode",
"Unit_price",
"Qty_on_Hand",
"Qty_Received",
"Stock_since",
};
fieldsname_forselect = new string[] {
"Name",
"Qty_on_Hand AS 'Qty on Hand'",
"Qty_Received AS 'Qty received'",
"Stock_since AS 'Stock since'",
};
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="db"> mysqldb instance </param>
public DatabaseMapper(MySqlDB db)
{
this.db = db;
}