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));
}