示例#1
0
 public static translate GetTranslateObj(string engMsg)
 {
     using (mydbEntities db = new mydbEntities())
     {
         return(db.translate.Where(t => t.eng == engMsg).FirstOrDefault());
     }
 }
示例#2
0
        public static void InserRememberIdPwdOption(bool isRemember)
        {
            using (mydbEntities db = new mydbEntities())
            {
                var rememberIdPwdOption = db.tdcode.Where(t => t.code_id == Params.codeIdRememberIdPwd &&
                                                          t.code_type == Params.codeTypeRememberIdPwd).FirstOrDefault();
                if (rememberIdPwdOption == null)
                {
                    //insert hide browser option
                    tdcode codeNew = new tdcode();
                    codeNew.code_id    = Params.codeIdRememberIdPwd;
                    codeNew.code_type  = Params.codeTypeRememberIdPwd;
                    codeNew.code_value = isRemember.ToString();

                    db.tdcode.Add(codeNew);
                    db.SaveChanges();
                }
                else
                {
                    //update hide browser option
                    rememberIdPwdOption.code_value = isRemember.ToString();
                    db.SaveChanges();
                }
            }
        }
示例#3
0
        public static void InsertUserLoginIdPwdToDB(string unEncryptedId, string unEncryptedPwd)
        {
            string codeId          = Params.codeIdLoginIdPwd;  // "UserLoginIdPwd";
            string codeType        = Params.codeTypeAutoLogin; // "AutoLogin";
            string notEncryptedStr = unEncryptedId + "," + unEncryptedPwd;
            string encryptedStr    = Common.CryptEncryptString(notEncryptedStr);

            using (mydbEntities db = new mydbEntities())
            {
                var loginObj = db.tdcode.Where(t => t.code_id == codeId && t.code_type == codeType).FirstOrDefault();

                //if not exist => insert
                if (loginObj == null)
                {
                    tdcode param = new tdcode();
                    param.code_id    = codeId;
                    param.code_type  = codeType;
                    param.code_value = encryptedStr;

                    db.tdcode.Add(param);
                }
                else
                {
                    //if exists => update
                    loginObj.code_value = encryptedStr;
                }


                db.SaveChanges();
            }
        }
示例#4
0
        public static void InserUpdateHideBrowserOption(bool isHide)
        {
            using (mydbEntities db = new mydbEntities())
            {
                var hideBrowserOption = db.tdcode.Where(t => t.code_id == Params.codeIdHideBrowser &&
                                                        t.code_type == Params.codeTypeHideBrowser).FirstOrDefault();
                if (hideBrowserOption == null)
                {
                    //insert hide browser option
                    tdcode codeNew = new tdcode();
                    codeNew.code_id    = Params.codeIdHideBrowser;
                    codeNew.code_type  = Params.codeTypeHideBrowser;
                    codeNew.code_value = isHide.ToString();

                    db.tdcode.Add(codeNew);
                    db.SaveChanges();
                }
                else
                {
                    //update hide browser option
                    hideBrowserOption.code_value = isHide.ToString();
                    db.SaveChanges();
                }
            }
        }
        public static string ToLanguage(this string engMsg, LanguageOption langOption)
        {
            string result = "";

            using (mydbEntities db = new mydbEntities())
            {
                var msgObj = db.translate.Where(t => t.eng == engMsg).FirstOrDefault();
                if (langOption == LanguageOption.English)
                {
                    result = msgObj.eng;
                }
                else if (langOption == LanguageOption.日本語)
                {
                    result = msgObj.jpn;
                }
                else if (langOption == LanguageOption.简体中文)
                {
                    result = msgObj.chs;
                }
                else if (langOption == LanguageOption.繁體中文)
                {
                    result = msgObj.cht;
                }
            }


            return(result);
        }
示例#6
0
 public static void DeleteUserFTP(string userId)
 {
     using (mydbEntities db = new mydbEntities())
     {
         var userFTP = db.tdcode.Where(t => t.code_id == userId && t.code_type == Params.codeTypeFTP).FirstOrDefault();
         if (userFTP != null)
         {
             db.tdcode.Remove(userFTP);
             db.SaveChanges();
         }
     }
 }
示例#7
0
        public static string GetUserTTE(string userId)
        {
            string userTTE = "0:30:00";

            using (mydbEntities db = new mydbEntities())
            {
                var userTTEObj = db.tdcode.Where(t => t.code_id == userId && t.code_type == Params.codeTypeTTE).FirstOrDefault();
                if (userTTE != null)
                {
                    userTTE = userTTEObj.code_value;
                }
            }
            return(userTTE);
        }
示例#8
0
        public static int GetUserFTP(string userId)
        {
            int ftp = 0;

            using (mydbEntities db = new mydbEntities())
            {
                var userFTP = db.tdcode.Where(t => t.code_id == userId && t.code_type == Params.codeTypeFTP).FirstOrDefault();
                if (userFTP != null)
                {
                    ftp = Convert.ToInt16(userFTP.code_value);
                }
            }
            return(ftp);
        }
示例#9
0
        public static bool GetRememberIdPwdOption()
        {
            bool isRemember = false;

            using (mydbEntities db = new mydbEntities())
            {
                var rememberIdPwdOption = db.tdcode.Where(t => t.code_id == Params.codeIdRememberIdPwd &&
                                                          t.code_type == Params.codeTypeRememberIdPwd).FirstOrDefault();
                if (rememberIdPwdOption != null)
                {
                    isRemember = Convert.ToBoolean(rememberIdPwdOption.code_value);
                }
            }
            return(isRemember);
        }
示例#10
0
        public static bool GetHideBrowserOption()
        {
            bool isHide = false;

            using (mydbEntities db = new mydbEntities())
            {
                var hideBrowserOption = db.tdcode.Where(t => t.code_id == Params.codeIdHideBrowser &&
                                                        t.code_type == Params.codeTypeHideBrowser).FirstOrDefault();
                if (hideBrowserOption != null)
                {
                    isHide = Convert.ToBoolean(hideBrowserOption.code_value);
                }
            }
            return(isHide);
        }
示例#11
0
        public static string GetDefaultLanguageFromDB()
        {
            string result = "";

            using (mydbEntities db = new mydbEntities())
            {
                var userSelectDefaultLanguageObj = db.tdcode
                                                   .Where(t => t.code_id == Params.langCodeId && t.code_type == Params.langCodeType).FirstOrDefault();
                if (userSelectDefaultLanguageObj != null)
                {
                    result = userSelectDefaultLanguageObj.code_value;
                }
            }
            return(result);
        }
示例#12
0
        public static void DeleteUserIdPwdFromDb()
        {
            string codeId   = Params.codeIdLoginIdPwd;  // "UserLoginIdPwd";
            string codeType = Params.codeTypeAutoLogin; // "AutoLogin";


            using (mydbEntities db = new mydbEntities())
            {
                var loginObj = db.tdcode.Where(t => t.code_id == codeId && t.code_type == codeType).FirstOrDefault();


                if (loginObj != null)
                {
                    db.tdcode.Remove(loginObj);
                    db.SaveChanges();
                }
            }
        }
示例#13
0
        public static void InserUpdateUserTTE(string userId, string newTTE)
        {
            using (mydbEntities db = new mydbEntities())
            {
                var userTTE = db.tdcode.Where(t => t.code_id == userId && t.code_type == Params.codeTypeTTE).FirstOrDefault();
                if (userTTE == null)
                {
                    //insert user TTE
                    tdcode codeNew = new tdcode();
                    codeNew.code_id    = userId;
                    codeNew.code_type  = Params.codeTypeTTE;
                    codeNew.code_value = newTTE;

                    db.tdcode.Add(codeNew);
                    db.SaveChanges();
                }
                else
                {
                    //update user FTP
                    userTTE.code_value = newTTE;
                    db.SaveChanges();
                }
            }
        }
示例#14
0
 public static void InserUpdateDefaultLanguage(string userSelectLanguage)
 {
     using (mydbEntities db = new mydbEntities())
     {
         //check if user select a default language
         var userSelectLanguageObj = db.tdcode
                                     .Where(t => t.code_id == Params.langCodeId && t.code_type == Params.langCodeType).FirstOrDefault();
         if (userSelectLanguageObj != null)
         {
             //data exist: update data
             userSelectLanguageObj.code_value = userSelectLanguage;
         }
         else
         {
             //data not exist: insert data
             tdcode langSetting = new tdcode();
             langSetting.code_id    = Params.langCodeId;
             langSetting.code_type  = Params.langCodeType;
             langSetting.code_value = userSelectLanguage;
             db.tdcode.Add(langSetting);
         }
         db.SaveChanges();
     }
 }