public static List <DeliveryDetail> LoadAll() { return(HelperDal <DeliveryDetail> .LoadAll("SELECT * FROM delivery_detail")); }
public static bool Update(Site sit) { return(HelperDal <Site> .Update(sit, "SELECT * FROM site WHERE sit_id=" + sit.sit_id)); }
public static void Delete(UInt32 sit_id) { HelperDal <Site> .Delete("DELETE FROM site WHERE sit_id=" + sit_id); }
public static UInt32 Insert(Stockout som) { return(HelperDal <Stockout> .Insert(som, "SELECT * FROM stockout WHERE som_id=0")); }
public static Stockout Load(String som_id) { return(HelperDal <Stockout> .Load("SELECT * FROM stockout WHERE som_id=" + som_id)); }
public static Supplier Load(UInt32 sup_id) { return(HelperDal <Supplier> .Load("SELECT * FROM supplier WHERE sup_id=" + sup_id)); }
public static List <Stockout> LoadAll(UInt32 sit_id) { return(HelperDal <Stockout> .LoadAll("SELECT * FROM stockout WHERE sit_id=" + sit_id)); }
public static List <Product> LoadAll() { return(HelperDal <Product> .LoadAll("SELECT * FROM product")); }
public static List <Product> LoadAll(UInt32 sup_id) { return(HelperDal <Product> .LoadAll("SELECT * FROM product WHERE sup_id=" + sup_id)); }
public static void Delete(UInt32 dlm_id, UInt32 prd_id) { HelperDal <DeliveryDetail> .Delete("DELETE FROM delivery_detail WHERE dlm_id=" + dlm_id + " AND prd_id=" + prd_id); }
public static DeliveryDetail Load(UInt32 dlm_id, UInt32 prd_id) { return(HelperDal <DeliveryDetail> .Load("SELECT * FROM delivery_detail WHERE dlm_id=" + dlm_id + " AND prd_id=" + prd_id)); }
public static UInt32 Insert(DeliveryDetail dld) { return(HelperDal <DeliveryDetail> .Insert(dld, "SELECT * FROM delivery_detail WHERE dlm_id=0 AND prd_id=0")); }
public static bool Update(DeliveryDetail dld) { return(HelperDal <DeliveryDetail> .Update(dld, "SELECT * FROM delivery_detail WHERE dlm_id=" + dld.dlm_id + " AND prd_id=" + dld.prd_id)); }
public static List <DeliveryDetail> LoadAll(UInt32 dlm_id) { return(HelperDal <DeliveryDetail> .LoadAll("SELECT * FROM delivery_detail WHERE dlm_id=" + dlm_id)); }
public static UInt32 Insert(Supplier sup) { return(HelperDal <Supplier> .Insert(sup, "SELECT * FROM supplier WHERE sup_id=0")); }
public static bool Update(Product prd) { return(HelperDal <Product> .Update(prd, "SELECT * FROM product WHERE prd_id=" + prd.prd_id)); }
public static void Delete(UInt32 sup_id) { HelperDal <Supplier> .Delete("DELETE FROM supplier WHERE sup_id=" + sup_id); }
public static UInt32 Insert(Product prd) { return(HelperDal <Product> .Insert(prd, "SELECT * FROM product WHERE prd_id=0")); }
public static List <Stockout> LoadAll() { return(HelperDal <Stockout> .LoadAll("SELECT * FROM stockout")); }
public static void Delete(UInt32 prd_id) { HelperDal <Product> .Delete("DELETE FROM product WHERE prd_id=" + prd_id); }
public static bool Update(Stockout som) { return(HelperDal <Stockout> .Update(som, "SELECT * FROM stockout WHERE som_id=" + som.som_id)); }
public static Product Load(UInt32 prd_id) { return(HelperDal <Product> .Load("SELECT * FROM product WHERE prd_id=" + prd_id)); }
public static void Delete(String som_id) { HelperDal <Stockout> .Delete("DELETE FROM stockout WHERE som_id=" + som_id); }
public static List <Supplier> LoadAll() { return(HelperDal <Supplier> .LoadAll("SELECT * FROM supplier")); }
public static List <Site> LoadAll() { return(HelperDal <Site> .LoadAll("SELECT * FROM site")); }
public static List <Supplier> LoadAll(UInt32 sit_id) { return(HelperDal <Supplier> .LoadAll("SELECT * FROM supplier where ")); }
public static UInt32 Insert(Site sit) { return(HelperDal <Site> .Insert(sit, "SELECT * FROM site WHERE sit_id=0")); }
public static bool Update(Supplier sup) { return(HelperDal <Supplier> .Update(sup, "SELECT * FROM supplier WHERE sup_id=" + sup.sup_id)); }
public static Site Load(UInt32 sit_id) { return(HelperDal <Site> .Load("SELECT * FROM site WHERE sit_id=" + sit_id)); }
public static SiteSupplier Load(UInt32 sit_id, UInt32 sup_id) { return(HelperDal <SiteSupplier> .Load("SELECT * FROM site_supplier WHERE sit_id=" + sit_id + " AND sup_id=" + sup_id)); }