public bool Chk_UserID_Exist(string UserID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
// check all users
return(myDP.chk_UserByID(UserID, "0", "0"));
}
public bool Chk_User_Login(string Email, string UserPass)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
// IsLockOut=0, IsDelete=0
return(myDP.chk_UserLogin(Email, UserPass, "0", "0"));
}
public bool Chk_UserName_Exist_ALL(string UserName)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
// check all users
return(myDP.chk_UserByUserName(UserName, "ALL", "ALL"));
}
private List <PageIndex> Build_PageIndex_Tree(List <PageIndex> list, string PageIndexID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataRow myDR = myDP.Get_PageIndex(PageIndexID);
PageIndex myPageIndex = new PageIndex(myDR);
if (DataEval.IsEmptyQuery(myPageIndex.PageIndexID))
{
return(list);
}
else
{
if (myPageIndex.PageIndexID == "-1" ||
myPageIndex.Parent_PageIndexID == "-1")
{
list.Insert(0, myPageIndex);
return(list);
}
else
{
list.Insert(0, myPageIndex);
return(Build_PageIndex_Tree(list, myPageIndex.Parent_PageIndexID));
}
}
}
// User Login on Site
public void Add_UserCookie(Page myPage, string Email, string Password, bool RememberMe)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
HttpCookie cookieUserInfo = new HttpCookie("UserInfo");
// Add Value
cookieUserInfo["Email"] = Email;
cookieUserInfo["Password"] = Password;
cookieUserInfo["RememberMe"] = RememberMe.ToString();
Login_Users myLogin_User = new Login_Users(myDP.Get_UserDetail_ByEmail(Email, "0", "0"));
// Add UserInfo to Coookie
cookieUserInfo["UserID"] = myLogin_User.UserID;
cookieUserInfo["Username"] = myLogin_User.UserName;
// Add Misc
cookieUserInfo.Domain = ConfigurationManager.AppSettings["Cookie_Domain"];
//cookieUserInfo.Path = "/";
if (RememberMe)
{
cookieUserInfo.Expires = DateTime.Now.AddDays(30);
}
else
{
cookieUserInfo.Expires = DateTime.Now.AddDays(1);
}
myPage.Response.Cookies.Add(cookieUserInfo);
}
public bool Chk_Email_Exist_ALL(string Email)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
// check all users
return(myDP.chk_UserByEmail(Email, "ALL", "ALL"));
}
public static string Get_UserNameByID(string UserID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
Login_Users myLogin_User = new Login_Users(myDP.Get_UserDetail_ByUserID(UserID, "ALL", "ALL"));
return(myLogin_User.UserName);
}
public static string Get_Phrase_Value(string VarName, string Language)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
Phrase myPhrase = new Phrase(myDP.Get_Phrase(VarName, Language));
return(myPhrase.PhraseValue);
}
public static bool Validate_UserGroup(Page myPage, UserGroup myUserGroup)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
UserMgr myUserMgr = new UserMgr();
Login_Users myUsers = myUserMgr.Get_Login_Users(myPage);
return(myDP.Chk_UserInGroup(myUsers.UserID, StringEnum.GetStringValue(myUserGroup)));
}
public Currency Get_Currency(string CurrencyID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
if (DataEval.IsEmptyQuery(CurrencyID))
{
CurrencyID = "69669DE1-974A-41D6-8F36-7F853586B609";
}
return(new Currency(myDP.Get_Currency(CurrencyID)));
}
public static List <Module> sGet_Modules(string SortOrder, string Module_Types = "'System Addon', 'Customer Addon'")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Modules(SortOrder, Module_Types);
List <Module> list = new List <Module>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Module(myDR));
}
return(list);
}
public List <ProductIndex> Get_ProductIndexes(string Title, string SortOrder = "LastUpdate_Date", string Direction = "ASC")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_ProductIndexes(Title, SortOrder, Direction);
List <ProductIndex> list = new List <ProductIndex>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new ProductIndex(myDR, true));
}
return(list);
}
public List <Product> Get_Products(string SortOrder = "Product_Title")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Products(SortOrder);
List <Product> list = new List <Product>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Product(myDR));
}
return(list);
}
public List <WebMedia> Get_WebMedia(string ProductID, string SortOrder = "SortOrder")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_WebMedia(ProductID, SortOrder);
List <WebMedia> list = new List <WebMedia>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new WebMedia(myDR));
}
return(list);
}
public List <Manufacturer> Get_Manufacturers(string SortOrder = "Name", string IsActive = "ALL")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Manufacturers(SortOrder, IsActive);
List <Manufacturer> list = new List <Manufacturer>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Manufacturer(myDR));
}
return(list);
}
public List <Variant> Get_Product_Variants(string SortOrder = "Variant_Name", string SortDirection = "ASC")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Product_Variants(SortOrder);
List <Variant> list = new List <Variant>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Variant(myDR));
}
return(list);
}
public List <UserInGroups> Get_UserIngroups_ByUserID(string UserID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_UserInGroups_ByUserID(UserID);
List <UserInGroups> list = new List <UserInGroups>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new UserInGroups(myDR));
}
return(list);
}
public List <Page_Privacy_Full> Get_Page_Privacy_FullList(string PageIndexID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Page_Privacy_FullList(PageIndexID);
List <Page_Privacy_Full> list = new List <Page_Privacy_Full>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Page_Privacy_Full(myDR));
}
return(list);
}
public static List <Phrase> Get_Phrases(string FieldName, string Language, string SortOrder, string ModuleID)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Phrases(FieldName, Language, SortOrder, ModuleID);
List <Phrase> list = new List <Phrase>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Phrase(myDR));
}
return(list);
}
public List <Currency_Rate> Get_Currency_TargetRates(string CurrencyID, string SortOrder = "")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Currency_TargetRates(CurrencyID, SortOrder);
List <Currency_Rate> list = new List <Currency_Rate>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Currency_Rate(myDR));
}
return(list);
}
public List <Product_Attribute> Get_Product_Attributes(string Attribute_IndexID, string SortOrder = "SortOrder")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Product_Attributes(Attribute_IndexID, SortOrder);
List <Product_Attribute> list = new List <Product_Attribute>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Product_Attribute(myDR));
}
return(list);
}
public List <Attribute_Type> Get_Product_Attribute_Types(string Product_VariantID, string SortOrder = "Attribute_Name")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Product_Attribute_Types(Product_VariantID, SortOrder);
List <Attribute_Type> list = new List <Attribute_Type>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Attribute_Type(myDR));
}
return(list);
}
public List <AttributeIndex> Get_Product_AttributeIndexes(string ProductID, bool isView, string SortOrder = "SortOrder")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Product_AttributeIndexes(ProductID, isView, SortOrder);
List <AttributeIndex> list = new List <AttributeIndex>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new AttributeIndex(myDR, isView));
}
return(list);
}
public List <PageTag> Get_PageTags(string SortOrder = "Tag_Name")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_PageTags(SortOrder);
List <PageTag> list = new List <PageTag>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new PageTag(myDR));
}
return(list);
}
public static List <Component> sGet_Components(string ModuleID, string Parent_ComponentID, Component_Type Component_Type, string SortOrder)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Components(ModuleID, Parent_ComponentID, StringEnum.GetStringValue(Component_Type), SortOrder);
List <Component> list = new List <Component>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Component(myDR));
}
return(list);
}
public List <Toolbox_Tool> Get_Toolbox_Tools(string GroupID, string SortOrder)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Toolbox_Tools(GroupID, SortOrder);
List <Toolbox_Tool> list = new List <Toolbox_Tool>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Toolbox_Tool(myDR));
}
return(list);
}
public List <Property_Option> Get_Product_Variant_Property_Options(string Variant_PropertyID, string SortOrder = "SortOrder", string IsActive = "ALL")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Product_Variant_Property_Options(Variant_PropertyID, SortOrder, IsActive);
List <Property_Option> list = new List <Property_Option>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Property_Option(myDR));
}
return(list);
}
public List <Product_Mapping> Get_Product_Mappings(string ProductID, bool isView)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Product_Mappings(ProductID, isView);
List <Product_Mapping> list = new List <Product_Mapping>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Product_Mapping(myDR, isView));
}
return(list);
}
public List <Variant_Property> Get_Product_Variant_Properties_BySpliterID(string Variant_SpliterID, string SortOrder = "SortOrder")
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_Product_Variant_Properties_BySpliterID(Variant_SpliterID, SortOrder);
List <Variant_Property> list = new List <Variant_Property>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new Variant_Property(myDR));
}
return(list);
}
public List <PageTag_Full> Get_ComponentInTags_Full_ByPageTagID(string PageTagID, string SortOrder)
{
MySQL_DataConn myDP = new MySQL_DataConn(ConfigurationManager.ConnectionStrings["e2CMS"].ConnectionString);
DataSet myDS = myDP.Get_ComponentInTag_Full_ByPageTagID(PageTagID, SortOrder);
List <PageTag_Full> list = new List <PageTag_Full>();
foreach (DataRow myDR in myDS.Tables[0].Rows)
{
list.Add(new PageTag_Full(myDR));
}
return(list);
}
