Example #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="mData"></param>
        /// <returns>-1: false; 0: success; 1: Can't connect DB; 2: Can't sendmail</returns>
        public int ReplySupportRequest(UserSupport_Model mData)
        {
            int result = -1;

            try
            {
                //Ghi DB voi thong tin username
                if (DBHandler.updateDataBase(ref conn, "`order_user_support`", "`isreplied`=" + true.ToString() + ",`repliedsubject`='" + mData.repliedsubject + "',`repliedmessage`='" + mData.repliedmessage + "'", "`id`= " + mData.id))
                {
                    //Gui mai :
                    SMPTGMail mail            = new SMPTGMail(AppConfig.UserGmailSupport, AppConfig.PasswordGmailSupport);
                    bool      sendmailSuccess = false;
                    for (int i = 0; i < 5; i++)
                    {
                        if (mail.SendMailOnlyOne(mData.mail, mData.repliedsubject, mData.repliedmessage.Replace("\n", "<br/>")))
                        {
                            sendmailSuccess = true;
                            break;
                        }
                    }
                    result = (sendmailSuccess) ? 0 : 2;
                    if (result == 2)
                    {
                        DBHandler.updateDataBase(ref conn, "`order_user_support`", "`isreplied`=" + false.ToString() + ",`repliedsubject`='',`repliedmessage`=''", "`id`= " + mData.id);
                    }
                }
                else
                {
                    result = 1;
                }
            }
            catch (Exception ex)
            {
                LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
            }

            return(result);
        }
        /// <summary>
        /// Add User
        /// </summary>
        /// <param name="UserName">User name need add</param>
        /// <returns>0: success; -1: Unknown; 1: Can't not DB; 2: Can not send mail; 3: User đã được sử dụng; 4: Dinh dang mail khong dung</returns>
        public int AddUser(string UserName)
        {
            int result = -1;

            try
            {
                System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");


                bool check = regex.IsMatch(UserName);
                if (check == false)
                {
                    result = 4;
                    return(result);
                }

                bool IsHave = false;
                // Kiểm tra username có được sử dụng hay chưa
                using (DataTable dt = DBHandler.selectDataBase(ref conn, "`order_user`", "*", "`username` = '" + UserName + "'"))
                {
                    if (dt.Rows.Count > 0)
                    {
                        IsHave = true;
                    }
                }
                if (IsHave)
                {
                    result = 3;
                }
                else
                {
                    //Ghi DB voi thong tin username
                    if (DBHandler.insertDataBase(ref conn, "`order_user`", "(`username`,`usernamemd5`,`email`)", "('" + UserName + "','" + Functions.GetMD5(UserName) + "','" + UserName + "')"))
                    {
                        //Gui mai :
                        SMPTGMail mail            = new SMPTGMail(AppConfig.UserGmailNoReply, AppConfig.PasswordGmailNoReply);
                        bool      sendmailSuccess = false;
                        for (int i = 0; i < 5; i++)
                        {
                            if (mail.SendMailOnlyOne(UserName, getSubject(), getContent(UserName)))
                            {
                                sendmailSuccess = true;
                                break;
                            }
                        }
                        result = (sendmailSuccess) ? 0 : 2;
                        if (result == 2)
                        {
                            DBHandler.deleteDataBase(ref conn, "`order_user`", "`username` = '" + UserName + "'");
                        }
                    }
                    else
                    {
                        result = 1;
                    }
                }
            }
            catch (Exception ex)
            {
                LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
            }

            return(result);
        }