public static DataTable AllCategoriesDrugsByParent(int? p_ParentCategoryID, bool p_isShowAll)
{
StoredProcedure sp = new StoredProcedure("p_CategoriesDrugs_sl_ByParent");
sp["@CategoryID"].Value = p_ParentCategoryID == null ? DBNull.Value : (object)p_ParentCategoryID;
sp["@ShowAll"].Value = p_isShowAll;
return sp.ExecuteDataTable();
}
public static DataTable GetCategory(int p_CategoryID)
{
StoredProcedure sp = new StoredProcedure("p_Categories_s");
sp["@CategoryID"].Value = p_CategoryID;
return sp.ExecuteDataTable();
}
public static DataTable AllByParent(int? p_ParentCategoryID, bool p_ShowDisable)
{
StoredProcedure sp = new StoredProcedure("p_Categories_sl_ByParent");
sp["@ParentCategoryID"].Value = p_ParentCategoryID==null?DBNull.Value:(object)p_ParentCategoryID;
sp["@ShowDisable"].Value = p_ShowDisable;
return sp.ExecuteDataTable();
}
public static DataRow GetBanner(int p_BannerID)
{
StoredProcedure sp = new StoredProcedure("p_Banners_s");
sp["@BannerID"].Value = p_BannerID;
DataTable l_dtRes = sp.ExecuteDataTable();
if (l_dtRes.Rows.Count<=0) return null;
return l_dtRes.Rows[0];
}
public static DataRow GetCategoryByCode(string p_CategoryCode)
{
StoredProcedure sp = new StoredProcedure("p_Categories_s_byCategoryCode");
sp["@CategoryCode"].Value = p_CategoryCode;
DataTable l_dtRes = sp.ExecuteDataTable();
if (l_dtRes.Rows.Count>0)
{
return l_dtRes.Rows[0];
}else {return null;}
}
public static DataTable All()
{
StoredProcedure sp = new StoredProcedure("p_Banners_sl");
return sp.ExecuteDataTable();
}
public static DataTable GetPossibleDeliveries(string p_DrugIDs)
{
StoredProcedure sp = new StoredProcedure("p_DeliveryMethods_s_ByDrugs");
sp["@DrugIDs"].Value = p_DrugIDs;
return sp.ExecuteDataTable();
}
public static DataTable GetCategoryByDrugId(int p_DrugID)
{
StoredProcedure sp = new StoredProcedure("p_Category_sl_byDrugID");
sp["@DrugID"].Value = p_DrugID;
return sp.ExecuteDataTable();
}
public static DataTable All(bool p_ShowDisable)
{
StoredProcedure sp = new StoredProcedure("p_Categories_sl");
sp["@ShowDisable"].Value = p_ShowDisable;
return sp.ExecuteDataTable();
}
public static DataRow GetCategoryParentByID(int p_CategoryID)
{
StoredProcedure sp = new StoredProcedure("p_Categories_s_ParentbyCategoryID");
sp["@CategoryID"].Value = p_CategoryID;
DataTable l_dtRes = sp.ExecuteDataTable();
if (l_dtRes.Rows.Count > 0)
{
return l_dtRes.Rows[0];
}
else { return null; }
}
public static DataTable GetCustomerAddresses(int p_CustomerID)
{
StoredProcedure sp = new StoredProcedure("p_CustomerAddresses_sl");
sp["@CustomerID"].Value = p_CustomerID;
return sp.ExecuteDataTable();
}
private static DataTable GetCustomerByCredentials(string p_Login, string p_Password, bool p_isCheckPass)
{
StoredProcedure sp = new StoredProcedure("p_Customers_s_byLogin");
sp["@Login"].Value = p_Login.Trim();
sp["@Password"].Value = p_Password.Trim();
sp["@isCheckPass"].Value = p_isCheckPass;
return sp.ExecuteDataTable();
}
