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