示例#1
0
 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",
     };
 }
示例#3
0
        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'",
            };
        }
示例#4
0
 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",
     };
 }
示例#6
0
 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",
     };
 }
示例#8
0
 public AuditTrailMapper(MySqlDB db)
     : base(db)
 {
     tableName = "audit_trail_tbl";
     fieldsname = new string[]{
         "user_id",
         "user_action",
         "date_time",
     };
 }
示例#9
0
 public FallbackMapper(MySqlDB db)
     : base(db)
 {
     tableName = "fallback_tbl";
     id = "id";
     fieldsname = new string[] {
         "id",
         "squery",
     };
 }
示例#10
0
 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",
     };
 }
示例#12
0
 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",
     };
 }
示例#19
0
 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'",
     };
 }
示例#20
0
 public ProductMapper(MySqlDB db)
     : base(db)
 {
     tableName = "product_tbl";
     id = "id";
     fieldsname = new string[] {
         "id",
         "name",
         //"category_id",
         "unit_price",
         //"source_company_name",
     };
 }
示例#21
0
 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'",
     };
 }
示例#22
0
 public ProductMapper(MySqlDB db)
     : base(db)
 {
     tableName  = "product_tbl";
     id         = "id";
     fieldsname = new string[] {
         "id",
         "name",
         //"category_id",
         "unit_price",
         //"source_company_name",
     };
 }
示例#23
0
 public UserMapper(MySqlDB db)
     : base(db)
 {
     tableName = "user_tbl";
     id = "id";
     fieldsname = new string[] {
         "id",
         "password",
         "access_level",
         "active",
         "create_time",
     };
 }
示例#24
0
 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",
            };
        }
示例#26
0
        public DailySalesReportMapper(MySqlDB db)
            : base(db)
        {
            tableName  = "daily_sales_report";
            fieldsname = new string[] {
                "date",
                "Sales",
            };

            fieldsname_forselect = new string[] {
                "date AS 'Date'",
                "Sales",
            };
        }
示例#27
0
 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",
     };
 }
示例#28
0
 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",
     };
 }
示例#30
0
 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'",
     };
 }
示例#33
0
 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",
     };
 }
示例#34
0
 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",
            };

        }
示例#36
0
 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",
     };
 }
示例#37
0
 public ProductMapper(MySqlDB db)
     : base(db)
 {
     tableName = "product_tbl";
     id = "id";
     fieldsname = new string[] {
         "id",
         "name",
         "unit_price",
         "specification",
         "warranty",
         "replacement",
         "category_id",
     };
 }
示例#38
0
 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'",
            };
        }
示例#40
0
 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",
     };
 }
示例#41
0
 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'",
     };
 }
示例#42
0
 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",
     };
 }
示例#43
0
 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",
     };
 }
示例#44
0
 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'",
     };
 }
示例#45
0
        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'"
            };
        }
示例#48
0
        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'",
            };
        }
示例#49
0
        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();
            }
        }
示例#50
0
        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)'",
            };
        }
示例#51
0
        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'",
            };
        }
示例#52
0
 /// <summary>
 /// Constructor
 /// </summary>
 /// <param name="db"> mysqldb instance </param>
 public DatabaseMapper(MySqlDB db)
 {
     this.db = db;
 }