}// //retrieve startup products from store public List <MDB_ProductModel> getStartUpProductsFromStore() { try { string q = "SELECT * FROM pos_items WHERE deleted=0 ORDER BY last_updated_trans DESC LIMIT 30"; DBResults = DBManager.getListFromQuery(q, "MDB_ProductModel"); if (DBResults.status == 0) { List <MDB_ProductModel> list = new List <MDB_ProductModel>(DBResults.result_data.Cast <MDB_ProductModel>()); return(list); } else { MessageBox.Show(DBResults.sys_message); return(new List <MDB_ProductModel>()); } } catch (Exception ex) { return(new List <MDB_ProductModel>()); } }//
//get list of all sales0 public List <MDB_Sale> get_my_sales_list() { try { string q = "SELECT * FROM pos_sales WHERE (amt_paid NOT LIKE '%e%' AND amt_change NOT LIKE '%e%') AND worker_id=" + this.getCurrentUser().id + " ORDER BY id DESC LIMIT 800";//AND worker_id=" + this.getCurrentUser().id + " //MessageBox.Show(q); DBResults = DBManager.getListFromQuery(q, "MDB_Sale"); if (DBResults.status == 0) { return(new List <MDB_Sale>(DBResults.result_data.Cast <MDB_Sale>())); } else { MessageBox.Show("ERR : " + DBResults.sys_message); return(new List <MDB_Sale>()); } } catch (Exception ex) { this.AlertCustomMsg("", "FAIL TO LOAD SALES LIST", 1, ex.Message); return(new List <MDB_Sale>()); } }//
}// //login public MDB_UserModel login_user(MDB_UserModel user) { try { string q = "SELECT * FROM workers WHERE username= '******' AND password='******' LIMIT 1;"; DBResults = DBManager.getListFromQuery(q, "MDB_UserModel"); // System.Windows.Forms.MessageBox.Show(DBResults.sys_message); if (DBResults.status == 0) { var li = new List <MDB_UserModel>(DBResults.result_data.Cast <MDB_UserModel>()); return(li[0]); } else { MessageBox.Show("" + DBResults.sys_message); //System.Windows.Forms.MessageBox.Show(DBResults.sys_message); return(null); } }catch (Exception ex) { return(null); } }
//get list of all customers public List <MDB_CustomerModel> get_customers_list() { try { DBResults = DBManager.getListFromQuery("SELECT * FROM customers" + " ORDER BY id", "MDB_CustomerModel"); if (DBResults.status == 0) { return(new List <MDB_CustomerModel>(DBResults.result_data.Cast <MDB_CustomerModel>())); } else { MessageBox.Show("ERR : " + DBResults.sys_message); return(new List <MDB_CustomerModel>()); } } catch (Exception ex) { this.AlertCustomMsg("", "FAIL TO LOAD CUSTOMERS LIST", 1, ex.Message); return(new List <MDB_CustomerModel>()); } }//
//get list of all companies public MDB_CompanyModel get_company_details() { try { DBResults = DBManager.getListFromQuery("SELECT * FROM companies" + " ORDER BY id", "MDB_CompanyModel"); if (DBResults.status == 0) { var list = new List<MDB_CompanyModel>(DBResults.result_data.Cast<MDB_CompanyModel>()); if(list.Count >= 1) return list[0]; return new MDB_CompanyModel(); } else { MessageBox.Show("ERR : " + DBResults.sys_message); return new MDB_CompanyModel(); } } catch (Exception ex) { this.AlertCustomMsg("", "FAIL TO LOAD COMPANY DETAILS", 1, ex.Message); return new MDB_CompanyModel(); } }