Esempio n. 1
0
    // event handler for the load event for the page
    protected void Page_Load(object sender, EventArgs e)
    {
        // clear any existing error messages
        lblError.Text = "";
        // if this is the first time the page has been displayed
        if (IsPostBack == false)
        {
            // populate the list
            DisplayOrders();
        }


        //on load get the current state from the session
        Sec = (clsSecurity)Session["Sec"];
        //if the object is null then it needs initialising
        if (Sec == null)
        {
            //initialise the object
            Sec = new clsSecurity();
            //update the session
            Session["Sec"] = Sec;
        }
        //set the state of the linsk based on the cureent state of authentication
        SetLinks(Sec.Authenticated);
    }
Esempio n. 2
0
    //clsOrderCollection OrderBook = new clsOrderCollection();

    protected void Page_Load(object sender, EventArgs e)
    {
        //get the security data from the session
        Sec = (clsSecurity)Session["Sec"];
        //if it is null then this is the first run of the site
        if (Sec == null)
        {
            //initialise the object
            Sec = new clsSecurity();
            //save it to the session
            Session["Sec"] = Sec;
        }
        //create an object
        clsCustomer customer = new clsCustomer();
        Boolean     Found    = false;

        //get customerNo by email
        Found = customer.GetCustomerNoByEmail(Sec.UserEMail);
        //Get CustomerNo
        CustomerNo = customer.CustomerNo;

        //Check if login
        if (CustomerNo == 0)
        {
            lblError.Text = "Please Sign-In first.";
        }
        else
        {
            DisplayAllOrders(CustomerNo);
        }
    }
        //dateReviewed
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec    = (clsSecurity)Session["Sec"];
            MyCart = (clsCart)Session["MyCart"];
            //if the cart is null then we need to initialise it
            if (MyCart == null)
            {
                MyCart = new clsCart();
            }

            txtEmail.Text = Sec.UserEMail;

            reviewId     = Convert.ToString(Request.QueryString["reviewId"].Trim());
            email        = Convert.ToString(Request.QueryString["Email"].Trim());
            description  = Convert.ToString(Request.QueryString["Description"].Trim());
            rating       = Convert.ToString(Request.QueryString["Rating"].Trim());
            productId    = Convert.ToString(Request.QueryString["ProductId"].Trim());
            dateReviewed = Convert.ToString(Request.QueryString["DateReviewed"].Trim());

            lblReviewId.Text     = reviewId;
            txtEmail.Text        = email;
            txtDescription.Text  = description.ToUpper();
            txtRating.Text       = Convert.ToString(rating);
            txtProductId.Text    = Convert.ToString(productId);
            txtDateReviewed.Text = dateReviewed.ToUpper();
        }
 public SecurityController()
 {
     _clsSecurity = new clsSecurity();
     _clsGlobal   = new clsGlobal();
     _clsCRM      = new clsCRM();
     _clsAsset    = new clsAsset();
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec = (clsSecurity)Session["Sec"];
            //upon loading the page you need to read in the cart from the session object
            MyCart = (clsCart)Session["MyCart"];

            //you also need to get the product id from the query string
            InventoryId = Convert.ToInt32(Request.QueryString["InventoryId"].Trim());

            Name        = Convert.ToString(Request.QueryString["Name"].Trim());
            Price       = Convert.ToDecimal(Request.QueryString["Price"].Trim());
            Description = Convert.ToString(Request.QueryString["Description"].Trim());
            active      = Convert.ToBoolean(Request.QueryString["Active"].Trim());

            txtName.Text        = Convert.ToString(Name);
            txtPrice.Text       = Convert.ToString(Price);
            txtDescription.Text = Convert.ToString(Description);

            if (active == true)
            {
                chkAge.Visible = true;
                Label5.Visible = true;
            }

            else
            {
                chkAge.Visible = false;
                Label5.Visible = false;
            }
        }
    protected void btnSignUp_Click(object sender, EventArgs e)
    {
        //create a new instance of the security class
        clsSecurity Sec = new clsSecurity();
        //var to store the data
        string Name            = txtName.Text;
        string Phone           = txtPhone.Text;
        string Email           = txtEmail.Text;
        string Username        = txtUsername.Text;
        string Password        = txtPassword.Text;
        string PasswordConfirm = txtConfirm.Text;
        string PasswordType    = txtPaymentType.Text;
        string SecurityMsg     = txtSecurityMsg.Text;

        //validate the data
        lblError.Text = Sec.SignUp(Name, Phone, Email, Username, Password, PasswordConfirm, PasswordType, SecurityMsg);
        //if the username isnt taken

        //if there is no error
        if (lblError.Text == "")
        {
            //go to sign up success page
            Response.Redirect("HomePage.aspx");
        }
        else
        {
            //show error
            lblError.Text = lblError.Text;
        }

        Session["Sec"] = Sec;
    }
Esempio n. 7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //if this is the first time the page is displayed
            if (IsPostBack == false)
            {
                //update the list box
                // lblError.Text = DisplayInventories("") + " records in the database";
            }

            //on load get the current state from the session
            Sec = (clsSecurity)Session["Sec"];
            //if the object is null then it needs initialising
            if (Sec == null)
            {
                //initialize the object
                Sec = new clsSecurity();
                //update the session
                Session["Sec"] = Sec;
            }



            //set the state of the link based on the current state of authentication
            SetLinks(Sec.Authenticated);
        }
Esempio n. 8
0
    protected void btnSignUp_Click(object sender, EventArgs e)
    {
        //create a new instance of the security class
        clsSecurity Sec      = new clsSecurity();
        clsCustomer customer = new clsCustomer();
        //try to sign up using the supplied credentials
        string Outcome  = Sec.SignUp(txtEMail.Text, txtPassword1.Text, txtPassword2.Text, false);
        string Outcome1 = "";

        //If the Valid result is OK
        if (Outcome == "An email has been sent to your account allowing you to activate the account")
        {
            //Valid the information for customer
            Outcome1 = customer.Valid(1, txtEMail.Text, txtFirstName.Text, txtLastName.Text, txtPostcode.Text, txtTelephone.Text, ddlTitle.SelectedValue);
            //If the Valid result is OK
            if (Outcome1 == "")
            {
                ////Get the AccountNo
                //int AccountNo = Sec.GetAccountNoByEmail(txtEMail.Text);
                //insert customer details and stroe the value for primary key
                int PrimaryKey = customer.Add(txtEMail.Text, txtFirstName.Text, txtLastName.Text, txtPostcode.Text, txtTelephone.Text, ddlTitle.SelectedValue);
                //put the value for primary key into tblAccount
                Sec.UpdateCustomerNo(txtEMail.Text, PrimaryKey);
            }
        }

        //report the outcome of the operation
        lblError.Text = Outcome + Outcome1;
        //store the object in the session objec for other pages to access
        Session["Sec"] = Sec;
    }
Esempio n. 9
0
 protected void Page_Load(object sender, EventArgs e)
 {
     //get the temp pw from the query string
     TempPW = Request.QueryString["TempPW"];
     //get the email address from the query string
     EMail = Request.QueryString["EMail"];
     //if the temp password isn't null
     if (TempPW != null)
     {
         //initialise the sceurity object
         Sec = new clsSecurity();
         //hide the current password label and text box (this is a user who has forgotten their password)
         lblCurrentPassword.Visible = false;
         txtCurrentPassword.Visible = false;
     }
     else
     {
         //get the security state from the session
         Sec = (clsSecurity)Session["Sec"];
         //if it isn't authenticated
         if (IsAuthenticated(Sec) == false)
         {
             //redirect back to the main page as the user hasn't got permission to use this page
             Response.Redirect("Default.aspx");
         }
     }
 }
Esempio n. 10
0
    Boolean IsAuthenticated(clsSecurity Sec)
    {
        //tests to see if the current login is authenticated to use this page

        //var to store the state of authentication assume all is well i.e. true
        Boolean Auth = true;

        //if the security object is not null
        if (Sec != null)
        {
            //if the user isn't authenticated
            if (Sec.Authenticated == false)
            {
                //set state to false
                Auth = false;
            }
        }
        else
        {
            //else set authenticated to false
            Auth = false;
        }
        //return the authentication state
        return(Auth);
    }
Esempio n. 11
0
        //variables to store the values of the fields being passed from the FindCustomer page

        protected void Page_Load(object sender, EventArgs e)
        {
            Sec    = (clsSecurity)Session["Sec"];
            MyCart = (clsCart)Session["MyCart"];

            SellerShopLineID = Convert.ToInt32(Request.QueryString["SellerShopLineId"].Trim());
            productName      = Convert.ToString(Request.QueryString["ProductName"].Trim());

            lblProductName.Text = Convert.ToString(productName);
            lblProductId.Text   = Convert.ToString(mSellerShopLineId);
        }
        //variables to store the values of the fields being passed from the FindCustomer page

        protected void Page_Load(object sender, EventArgs e)
        {
            Sec    = (clsSecurity)Session["Sec"];
            MyCart = (clsCart)Session["MyCart"];

            ShopID   = Convert.ToInt32(Request.QueryString["ShopId"].Trim());
            shopName = Convert.ToString(Request.QueryString["ShopName"].Trim());

            lblShopName.Text = Convert.ToString(shopName);
            lblShopId.Text   = Convert.ToString(mShopId);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec                = (clsSecurity)Session["Sec"];
            MyCart             = (clsCart)Session["MyCart"];
            MyCartList         = (clsCartItem)Session["MyCartList"];
            txtOrderTotal.Text = Session["Ordertotal"].ToString();

            MyCart.Email          = Sec.UserEMail;
            txtEmail.Text         = Sec.UserEMail;
            txtDatePurchased.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec    = (clsSecurity)Session["Sec"];
            MyCart = (clsCart)Session["MyCart"];

            InventoryId       = Convert.ToInt32(Request.QueryString["InventoryId"].Trim());
            txtProductId.Text = InventoryId.ToString();

            txtEmail.Text        = Sec.UserEMail;
            txtDateReviewed.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");
        }
Esempio n. 15
0
    protected void btnReSet_Click(object sender, EventArgs e)
    {
        //create an instance of the security class
        clsSecurity Sec = new clsSecurity();
        //initiate the password re-set process
        string Outcome = Sec.ReSet(txtEMail.Text);

        //update the session variable
        Session["Sec"] = Sec;
        //display the outcome of the operation
        lblError.Text = Outcome;
    }
Esempio n. 16
0
    protected void btnSignUp_Click(object sender, EventArgs e)
    {
        //create a new instance of the security class
        clsSecurity Sec = new clsSecurity();
        //try to sign up using the supplied credentials
        string Outcome = Sec.SignUp(txtEMail.Text, txtPassword1.Text, txtPassword2.Text, false);

        //report the outcome of the operation
        lblError.Text = Outcome;
        //store the object in the session objec for other pages to access
        Session["Sec"] = Sec;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        //get the email from the query string
        string EMail = Request.QueryString["EMail"];
        //get the temp password from the query string
        string TempPW = Request.QueryString["TempPW"];
        //create an instance of the security class
        clsSecurity Sec = new clsSecurity();

        //activate the account
        lblError.Text = Sec.ActivateAccount(EMail, TempPW);
    }
Esempio n. 18
0
        private void changePasswordToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //display the change password form
            frmChangePassword Change = new frmChangePassword();

            //set the mode using a specific user
            Change.SetMode(Sec, Sec.UserEMail);
            //show the form as a dialogue
            Change.ShowDialog();
            //get the state of the scurity once done
            Sec = Change.Sec;
        }
        private void btnAdd_Click(object sender, EventArgs e)
        {
            //create an instance of the security class
            clsSecurity Sec = new clsSecurity();
            //get the new users details
            string EMail     = txtEMail.Text;
            string Password1 = txtEMail.Text;
            string Password2 = txtPassword2.Text;

            //try to sign up the new user
            lblError.Text = Sec.SignUp(EMail, Password1, Password2, true);
        }
Esempio n. 20
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec    = (clsSecurity)Session["Sec"];
            MyCart = (clsCart)Session["MyCart"];
            //if the cart is null then we need to initialise it
            if (MyCart == null)
            {
                MyCart = new clsCart();
            }

            txtEmail.Text = Sec.UserEMail;
        }
Esempio n. 21
0
        private void reSetPasswordToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //resets the password
            //create a instance of the chnage passord form
            frmChangePassword Change = new frmChangePassword();

            //set the mode to change any user password (admin only)
            Change.SetMode(Sec, "");
            //show the form as a dialogue
            Change.ShowDialog();
            //get the new security state
            Sec = Change.Sec;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec    = (clsSecurity)Session["Sec"];
            MyCart = (clsCart)Session["MyCart"];
            //if the cart is null then we need to initialise it
            if (MyCart == null)
            {
                MyCart = new clsCart();
            }

            txtEmail.Text        = Sec.UserEMail;
            txtDateReviewed.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");
        }
Esempio n. 23
0
 protected void Page_Load(object sender, EventArgs e)
 {
     //get the security data from the session
     Sec = (clsSecurity)Session["Sec"];
     //if it is null then this is the first run of the site
     if (Sec == null)
     {
         //initialise the object
         Sec = new clsSecurity();
         //save it to the session
         Session["Sec"] = Sec;
     }
 }
Esempio n. 24
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec = (clsSecurity)Session["Sec"];
            Int32 Index;

            //upon loading the page you need to read in the cart from the session object
            MyCart = (clsCart)Session["MyCart"];
            //get the index of the item to remove
            Index = Convert.ToInt32(Request.QueryString["Index"]);
            //remove the item in the query string
            MyCart.Products.RemoveAt(Index);
            //go back to view cart
            Response.Redirect("ViewCart.aspx");
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            clsSecurity clsSecurity = new clsSecurity();

            if (clsSecurity.LoginGroup.ToLower() != "admin" && clsSecurity.LoginGroup.ToLower() != "hr")
            {
                ucColorBox1.Redirect("/", "กรุณาล็อคอินก่อน", PreloaderImage: ucColorBox.Preloaders.Recycle);
            }

            MenuBuilder();
        }
    }
Esempio n. 26
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec = (clsSecurity)Session["Sec"];
            //upon loading the page you need to read in the cart from the session object
            MyCart = (clsCart)Session["MyCart"];
            //if the cart is null then we need to initialise it
            if (MyCart == null)
            {
                MyCart = new clsCart();
            }
            //then you can display how many items are in your cart

            userEmail = Convert.ToString(Request.QueryString["Email"]);
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            clsSecurity clsSecurity = new clsSecurity();

            if (clsSecurity.LoginGroup.ToLower() != "admin" && clsSecurity.LoginGroup.ToLower() != "hr")
            {
                ucColorBox1.Redirect("/", "กรุณาล็อคอินก่อน", PreloaderImage: ucColorBox.Preloaders.Recycle);
            }

            MenuBuilder();
        }
    }
Esempio n. 28
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //get the security data from the session
        Sec = (clsSecurity)Session["Sec"];
        //if it is null then this is the first run of the site
        if (Sec == null)
        {
            //initialise the object
            Sec = new clsSecurity();
            //save it to the session
            Session["Sec"] = Sec;
        }

        lblComfirmText.Text = "Are you sure you want to cancel the order?";
    }
Esempio n. 29
0
 protected void Page_Load(object sender, EventArgs e)
 {
     //on load get the current state from the session
     Sec = (clsSecurity)Session["Sec"];
     //if the object is null then it needs initialising
     if (Sec == null)
     {
         //initialise the object
         Sec = new clsSecurity();
         //update the session
         Session["Sec"] = Sec;
     }
     //set the state of the linsk based on the cureent state of authentication
     SetLinks(Sec.Authenticated);
 }
Esempio n. 30
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //get the security data from the session
        Sec = (clsSecurity)Session["Sec"];
        //if it is null then this is the first run of the site
        if (Sec == null)
        {
            //initialise the object
            Sec = new clsSecurity();
            //save it to the session
            Session["Sec"] = Sec;
        }

        lblResultOfQuote.Text = "Congratulations, order was created. Our staff will collect your package next working day with invoice.";
    }
        protected void Page_Load(object sender, EventArgs e)
        {
            Sec    = (clsSecurity)Session["Sec"];
            MyCart = (clsCart)Session["MyCart"];

            SellerShopLineID = Convert.ToInt32(Request.QueryString["SellerShopLineId"].Trim());
            productName      = Convert.ToString(Request.QueryString["ProductName"].Trim());
            email            = Convert.ToString(Request.QueryString["Email"].Trim());
            description      = Convert.ToString(Request.QueryString["Description"].Trim());
            quantity         = Convert.ToString(Request.QueryString["Quantity"].Trim());
            price            = Convert.ToString(Request.QueryString["Price"].Trim());


            txtEmail.Text       = email.ToString();
            txtProductName.Text = productName.ToString();
            txtPrice.Text       = price.ToString();
        }
Esempio n. 32
0
 private void setDefault()
 {
     #region Variable
     var clsSQL = new clsSQL();
     #endregion
     #region Procedure
     lblHeader.Text = clsGlobal.ApplicationName+" v."+clsGlobal.ApplicationVersion;
     lblSubHeader.Text = "ศูนย์รวมบริหารและจัดการเซิฟเวอร์สำหรับรีโมท";
     lblFooterDetail.Text = string.Format("Server : {0}", clsSQL.getAppSettingServerName(clsGlobal.cs));
     ttDefault.SetToolTip(btMinimize, "ย่อหน้าต่าง");
     ttDefault.SetToolTip(btClose, "ออกจากโปรแกรม");
     ttDefault.SetToolTip(btMove, "ย้ายตำแหน่งหน้าต่าง");
     ttDefault.SetToolTip(btReport, "ดูรายงาน");
     if (!getAdminChecker()) btReport.Visible = false;
     txtUsername.Text = System.Net.NetworkInformation.IPGlobalProperties.GetIPGlobalProperties().DomainName+@"\"+clsGlobal.WindowsLogonBuilder();
     var savePassword = System.Configuration.ConfigurationManager.AppSettings["savePassword"];
     if (savePassword.Trim() != "")
     {
         var clsSecurity = new clsSecurity();
         txtPassword.Text = clsSecurity.Decrypt(savePassword);
     }
     if (clsGlobal.ServerMode)
     {
         try
         {
             txtUsername.Enabled = false; txtPassword.Enabled = false;
             lvServerList.Visible = false;
             tbContent.RowStyles[1].Height = 0;
             tmDefault.Enabled = true;
             tmDefault.Start();
         }
         catch(Exception ex)
         {
             try
             {
                 wsDefault.ServiceSoapClient wsDefault = new wsDefault.ServiceSoapClient();
                 wsDefault.MailSend(System.Configuration.ConfigurationManager.AppSettings["mailTo"],
                     clsGlobal.ApplicationName,
                     "<h2>" + clsGlobal.IPAddress() + "</h2>" + ex.Message,
                     "*****@*****.**",
                     System.Configuration.ConfigurationManager.AppSettings["siteCode"] + " : " + clsGlobal.ApplicationName,
                     "", "", "", false);
             }
             catch (Exception) { }
         }
     }
     else
     {
         lvSession.Visible = false;
         tbContent.RowStyles[0].Height = 0;
         tmClient.Enabled = true;
         tmClient.Start();
     }
     #endregion
 }
Esempio n. 33
0
 private void setSavePassword()
 {
     if (txtPassword.Text.Trim() != "")
     {
         var clsData = new clsDataNative();
         var clsSecurity = new clsSecurity();
         clsData.AppConfigUpdater("savePassword", clsSecurity.Encrypt(txtPassword.Text.Trim()));
     }
 }
    protected void btSave_Click(object sender, EventArgs e)
    {
        clsSecurity security = new clsSecurity();
        clsIO IO = new clsIO();

        string strDetailSub = string.Empty;
        string strDetail = txtDetail.Text.Replace("<p>", "");
        strDetail = strDetail.Replace("</p>", "");
        string PicFull = "null";
        string PicThumb = "null";
        string pathPhoto = "/Images/Article/";
        string pathImages = @"\Images\Article\";
        string outError;

        //upload Photo to server
        if (txtImanges.HasFile)
        {
            //Full Images
            if (IO.UploadPhoto(txtImanges, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 5120, 0, 0, "", 0, out outError, out PicFull) == false)
            {
                ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
                return;
            }
            else
            {
                PicFull = pathImages + "" + PicFull;
            }
            //Thumb Images
            if (IO.UploadPhoto(txtImanges, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 1024, 100, 100, "", 0, out outError, out PicThumb) == false)
            {
                ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
                return;
            }
            else
            {
                PicThumb = pathImages + "" + PicThumb;
            }

        }
        else
        {
            PicFull = lblImagesFull.Text.Trim();
            PicThumb = lblImagesThumb.Text.Trim();
        }

        //insert data to database
        try
        {
            if (txtDetail.Text.Length >= 200)
            {
                strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
            }
            else
            {
                strDetailSub = "<p>" + strDetail + ".....</p>";
            }

            //Insert new Article
            if (string.IsNullOrEmpty(lblUID.Text) == true)
            {
                Article tbarticle = new Article();

                //Assign values for insert into database
                tbarticle.Subject = txtSubject.Text.Trim();
                tbarticle.Detail = txtDetail.Text;
                tbarticle.PicFull = PicFull;
                tbarticle.PicThumbnail = PicThumb;
                tbarticle.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
                tbarticle.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
                tbarticle.Remark = txtRemark.Text.Trim();
                tbarticle.CWhen = DateTime.Now;
                tbarticle.CUser = Convert.ToInt32(security.LoginUID);
                tbarticle.MWhen = DateTime.Now;
                tbarticle.MUser = Convert.ToInt32(security.LoginUID);
                tbarticle.StatusFlag = rdbActive.Checked == true ? "A" : "D";
                tbarticle.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
                tbarticle.DetailSub = strDetailSub;
                tbarticle.NumberDislike = 0;
                tbarticle.NumberLike = 0;
                tbarticle.NumberView = 0;
                tbarticle.Score = 0;
                tbarticle.SampleSize = 0;
                tbarticle.MetaKeywords = txtMetaKeywords.Text.Trim();
                tbarticle.MetaDescription = txtMetaDescription.Text.Trim();

                //Insert data of Event to database
                db.Articles.InsertOnSubmit(tbarticle);
            }
            else //Update existing Event
            {
                var tbarticle = from a in db.Articles
                              where a.UID == Convert.ToInt32(lblUID.Text.Trim())
                              select a;
                foreach (Article a in tbarticle)
                {
                    a.Subject = txtSubject.Text.Trim();
                    a.Detail = txtDetail.Text;
                    a.PicFull = PicFull;
                    a.PicThumbnail = PicThumb;
                    a.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
                    a.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
                    a.Remark = txtRemark.Text.Trim();
                    a.MWhen = DateTime.Now;
                    a.MUser = Convert.ToInt32(security.LoginUID);
                    a.StatusFlag = rdbActive.Checked == true ? "A" : "D";
                    a.MetaKeywords = txtMetaKeywords.Text.Trim();
                    a.MetaDescription = txtMetaDescription.Text.Trim();
                    try
                    {
                        a.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
                    }
                    catch (Exception ex)
                    {
                        ex.ToString();
                    }
                    a.DetailSub = strDetailSub;
                }
            }
            db.SubmitChanges();
            clsColorBox clsColorBox = new clsColorBox();
            clsColorBox.Refresh();
            //Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
        }
        catch (Exception ex)
        {
            clsColorBox clsColorBox = new clsColorBox();
            clsColorBox.Refresh();
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
        }
    }
    private void MenuBuilder()
    {
        ucMenuMega.Item item = new ucMenuMega.Item();
        clsSecurity clsSecurity = new clsSecurity();

        item = new ucMenuMega.Item();
        item.UID = 1;
        //item.ParentUID = 1;
        item.Name = "จัดการข้อมูลเว็บไซต์";
        item.Detail = "";
        item.URL = "";
        ucMenuMega1.Items.Add(item);

        item = new ucMenuMega.Item();
        item.UID = 27;
        item.ParentUID = 1;
        item.Name = "IntroPage Manage";
        item.Detail = "";
        item.URL = "IntroPage.aspx";
        if (clsSecurity.LoginChecker("admin"))
        { 
            ucMenuMega1.Items.Add(item);
        }
        /*
        item = new ucMenuMega.Item();
        item.UID = 11;
        item.ParentUID = 1;
        item.Name = "Template Manage";
        item.Detail = "";
        item.URL = "Template.aspx";
        ucMenuMega1.Items.Add(item);
        */
        item = new ucMenuMega.Item();
        item.UID = 12;
        item.ParentUID = 1;
        item.Name = "Content Manage";
        item.Detail = "";
        item.URL = "Content.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 13;
        item.ParentUID = 1;
        item.Name = "Medical Center Manage";
        item.Detail = "";
        item.URL = "MedicalCenterGroup.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 14;
        item.ParentUID = 1;
        item.Name = "Service Manage";
        item.Detail = "";
        item.URL = "ServiceGroup.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 15;
        item.ParentUID = 1;
        item.Name = "Slider Manage";
        item.Detail = "";
        item.URL = "Slider.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 26;
        item.ParentUID = 1;
        item.Name = "Highlight Manage";
        item.Detail = "";
        item.URL = "Highlight.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 16;
        item.ParentUID = 1;
        item.Name = "E-Mail Template";
        item.Detail = "";
        item.URL = "EmailTemplate.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 17;
        item.ParentUID = 1;
        item.Name = "E-Mail Manage";
        item.Detail = "";
        item.URL = "EmailList.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 2;
        //item.ParentUID = 1;
        item.Name = "จัดการข้อมูลการติดต่อกับลูกค้า";
        item.Detail = "";
        item.URL = "";
        ucMenuMega1.Items.Add(item);

        item = new ucMenuMega.Item();
        item.UID = 21;
        item.ParentUID = 2;
        item.Name = "User Manage";
        item.Detail = "";
        item.URL = "User.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 22;
        item.ParentUID = 2;
        item.Name = "Inquire Manage";
        item.Detail = "";
        item.URL = "Inquiry.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 23;
        item.ParentUID = 2;
        item.Name = "Doctor Appointment Manage";
        item.Detail = "";
        item.URL = "DoctorAppointment.aspx";
        if (clsSecurity.LoginChecker("admin"))
        {
            ucMenuMega1.Items.Add(item);
        }

        item = new ucMenuMega.Item();
        item.UID = 24;
        item.ParentUID = 2;
        item.Name = "Jobs Manage";
        item.Detail = "";
        item.URL = "Jobs.aspx";
        ucMenuMega1.Items.Add(item);

        item = new ucMenuMega.Item();
        item.UID = 25;
        item.ParentUID = 2;
        item.Name = "Jobs History Manage";
        item.Detail = "";
        item.URL = "JobsHistory.aspx";
        ucMenuMega1.Items.Add(item);
    }
Esempio n. 36
0
    /// <summary>
    /// บันทึก Log การส่งอีเมล์จากระบบ Template
    /// </summary>
    /// <param name="UID">EmailTemplateUID</param>
    /// <param name="From">จากเมล์</param>
    /// <param name="To">ถึงเมล์</param>
    /// <param name="Cc">แนบเมล์</param>
    /// <param name="Bcc">ไม่เปิดเผยเมล์</param>
    /// <param name="Result">ผลการส่ง</param>
    /// <returns>true=บันทึกสำเร็จ , false=บันทึกไม่สำเร็จ</returns>
    private bool SendTemplateLog(string UID, string From, string To, string Cc, string Bcc, string Result)
    {
        #region Variable
        bool rtnValue = false;
        clsSQL clsSQL = new clsSQL();
        clsSecurity clsSecurity=new clsSecurity();
        clsNet clsNet = new clsNet();
        string outSQL;
        #endregion

        #region SQL Query
        if(clsSQL.Insert(
            "EmailTemplateLog",
            new string[,]{
                {"UID",clsSQL.GetNewID("UID","EmailTemplateLog","",dbType,cs).ToString()},
                {"EmailTemplateUID",UID},
                {"EmailFrom","'"+clsSQL.CodeFilter(From)+"'"},
                {"EmailTo","'"+clsSQL.CodeFilter(To)+"'"},
                {"EmailCc","'"+clsSQL.CodeFilter(Cc)+"'"},
                {"EmailBcc","'"+clsSQL.CodeFilter(Bcc)+"'"},
                {"Result","'"+clsSQL.CodeFilter(Result)+"'"},
                {"CWhen","GETDATE()"},
                {"CUser","0"},
                {"CIP","'"+clsNet.IPGet()+"'"},
                {"CHostname","'"+clsNet.ComNameGet()+"'"}},
            new string[,]{{}},
            dbType,
            cs,
            out outSQL))
        {
            rtnValue = true;
        }
        #endregion

        return rtnValue;
    }
    private void ContentBuilder()
    {
        #region Variable
        StringBuilder strSQL = new StringBuilder();
        StringBuilder strScript = new StringBuilder();
        DataTable dt = new DataTable();
        bool foundChecker = false;
        int dtIndex=0;

        clsSQL clsSQL = new clsSQL();
        clsLanguage clsLanguage = new clsLanguage();
        clsSecurity clsSecurity = new clsSecurity();
        #endregion

        #region SQL Query
        strSQL.Append("SELECT ");
        strSQL.Append("Language.UID LanguageUID,");
        strSQL.Append("Language.Name LanguageName,");
        strSQL.Append("Content.UID,");
        strSQL.Append("Content.Name,");
        strSQL.Append("Content.Detail,");
        strSQL.Append("Content.Content ");
        strSQL.Append("FROM ");
        strSQL.Append("Content ");
        strSQL.Append("INNER JOIN Language ON Content.LanguageUID=Language.UID ");
        strSQL.Append("AND Language.Active='1' ");
        strSQL.Append("WHERE ");
        strSQL.Append("Content.Active='1' ");
        strSQL.Append("AND Content.Name='"+_contentName.Trim()+"' ");
        strSQL.Append("ORDER BY ");
        strSQL.Append("Language.Sort ASC");
        #endregion

        dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);

        if (dt != null && dt.Rows.Count > 0)
        {
            strScript.Append("<div class='" + (clsSecurity.LoginChecker("Admin") ? "dvContent" : "dvContentNormal") + "'>");

            #region Find Language
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i]["LanguageName"].ToString() == clsLanguage.LanguageCurrent)
                {
                    foundChecker = true;
                    dtIndex=i;

                    #region Content Builder
                    if (dt.Rows[i]["Content"] != DBNull.Value)
                    {
                        strScript.Append(dt.Rows[i]["Content"].ToString());
                    }
                    #endregion

                    break;
                }
            }
            #endregion
            #region Default Builder
            if (!foundChecker)
            {
                if (dt.Rows[0]["Content"] != DBNull.Value)
                {
                    strScript.Append(dt.Rows[0]["Content"].ToString());
                }
            }
            #endregion
            #region Admin Builder
            if (clsSecurity.LoginChecker("Admin"))
            {
                strScript.Append("<div class='dvContentMenu'>");
                strScript.Append("<a href='/Management/ContentManage.aspx?id="+dt.Rows[dtIndex]["UID"].ToString()+"&command=edit' ");
                strScript.Append("title='แก้ไขข้อมูล' ");
                if (_modalRefreshOnClose)
                {
                    strScript.Append("class='cbIFrameRefreshOnClose'");
                }
                else
                {
                    strScript.Append("class='cbIFrame'");
                }
                strScript.Append(">");
                strScript.Append("<span class='Icon16 Edit' />");
                strScript.Append("</a>");
                strScript.Append("</div>");
            }
            #endregion

            strScript.Append("</div>");
            lblContent.Text = strScript.ToString();
        }
    }
    protected void btSave_Click(object sender, EventArgs e)
    {
        clsSecurity security = new clsSecurity();
        clsIO IO = new clsIO();

        string strDetailSub = string.Empty;
        string strDetail = txtDetail.Text.Replace("<p>", "");
        strDetail = strDetail.Replace("</p>", "");
        string PicFull = "null";
        string PicThumb = "null";
        string pathPhoto = "/Images/Package/";
        string pathImages = @"\Images\Package\";
        string outError;
        
        //upload Photo to server
        if (txtImgFull.HasFile)
        {
            //Full Images
            if (IO.UploadPhoto(txtImgFull, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 4096, 0, 0, "", 0, out outError, out PicFull) == false)
            {
                ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
                return;
            }
            else
            {
                PicFull = pathImages + "" + PicFull;
            }
        }
        else
        {
            PicFull = lblImagesFull.Text.Trim();
        }

        if (txtImgThum.HasFile)
        {
            //Thumb Images
            if (IO.UploadPhoto(txtImgThum, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 2048, 0, 0, "", 0, out outError, out PicThumb) == false)
            {
                ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
                return;
            }
            else
            {
                PicThumb = pathImages + "" + PicThumb;
            }

        }
        else
        {
            PicThumb = lblImagesThumb.Text.Trim();
        }

        //insert data to database
        try
        {
            if (txtDetail.Text.Length >= 200)
            {
                strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
            }
            else
            {
                strDetailSub = "<p>" + strDetail + ".....</p>";
            }

            //Insert new Package
            if (string.IsNullOrEmpty(lblUID.Text) == true)
            {
                Package tbpackage = new Package();

                //Assign values for insert into database
                tbpackage.PackageName = txtSubject.Text.Trim();
                tbpackage.Detail = txtDetail.Text;
                tbpackage.PicFull = PicFull;
                tbpackage.PicThumbnail = PicThumb;
                tbpackage.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
                if (!string.IsNullOrEmpty(txtDateTo.Text))
                {
                    tbpackage.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
                }
                else
                {
                    tbpackage.ActiveDateTo = null;
                }
                tbpackage.Remark = txtRemark.Text.Trim();
                tbpackage.CWhen = DateTime.Now;
                tbpackage.CUser = Convert.ToInt32(security.LoginUID);
                tbpackage.MWhen = DateTime.Now;
                tbpackage.MUser = Convert.ToInt32(security.LoginUID);
                tbpackage.StatusFlag = rdbActive.Checked == true ? "A" : "D";
                tbpackage.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
                tbpackage.DepartmentUID = Convert.ToInt32(ddlDepartment.SelectedValue);
                tbpackage.DetailSub = strDetailSub;
                tbpackage.MetaKeywords = txtMetaKeywords.Text.Trim();
                tbpackage.MetaDescription = txtMetaDescription.Text.Trim();
                tbpackage.PackageCode = txtPackagecode.Text.Trim();
                if (!string.IsNullOrEmpty(txtUnitPrice.Text))
                {
                    tbpackage.UnitPrice = Convert.ToDouble(txtUnitPrice.Text.Trim());
                }
                else
                {
                    tbpackage.UnitPrice = 0;
                }

                //Insert data of Event to database
                db.Packages.InsertOnSubmit(tbpackage);
            }
            else //Update existing Event
            {
                var tbpackage = from p in db.Packages
                              where p.UID == Convert.ToInt32(lblUID.Text.Trim())
                              select p;
                foreach (Package p in tbpackage)
                {
                    p.PackageName = txtSubject.Text.Trim();
                    p.Detail = txtDetail.Text;
                    p.PicFull = PicFull;
                    p.PicThumbnail = PicThumb;
                    p.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
                    if (!string.IsNullOrEmpty(txtDateTo.Text))
                    {
                        p.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
                    }
                    else
                    {
                        p.ActiveDateTo = null;
                    }
                    p.Remark = txtRemark.Text.Trim();
                    p.MWhen = DateTime.Now;
                    p.MUser = Convert.ToInt32(security.LoginUID);
                    p.StatusFlag = rdbActive.Checked == true ? "A" : "D";
                    try
                    {
                        p.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
                        p.DepartmentUID = Convert.ToInt32(ddlDepartment.SelectedValue);
                    }
                    catch (Exception ex)
                    {
                        ex.ToString();
                    }
                    p.DetailSub = strDetailSub;
                    p.MetaKeywords = txtMetaKeywords.Text.Trim();
                    p.MetaDescription = txtMetaDescription.Text.Trim();
                    p.PackageCode = txtPackagecode.Text.Trim();
                    if (!string.IsNullOrEmpty(txtUnitPrice.Text))
                    {
                        p.UnitPrice = Convert.ToDouble(txtUnitPrice.Text.Trim());
                    }
                    else
                    {
                        p.UnitPrice = 0;
                    }
                }
            }
            db.SubmitChanges();
            clsColorBox clsColorBox = new clsColorBox();
            clsColorBox.Refresh();
            //Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
        }
        catch (Exception ex)
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
        }
    }
    protected void btSave_Click(object sender, EventArgs e)
    {
        System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");

        clsSecurity security = new clsSecurity();
        clsIO IO = new clsIO();

        string strDetailSub = string.Empty;
        string strDetail = txtDetail.Text.Replace("<p>", "");
        strDetail = strDetail.Replace("</p>", "");
        string PicFull = "null";
        string PicThumb = "null";
        string pathPhoto = "/Images/Event/";
        string pathImages = @"\Images\Event\";
        string outError;

        //upload Photo to server
        if(txtImgFull.HasFile)
        {
            //Full Images
            if (IO.UploadPhoto(txtImgFull, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 5120, 0, 0, "", 0, out outError, out PicFull) == false)
            {
                ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
                return;
            }
            else
            {
                PicFull = pathImages + "" + PicFull;
            }
        }
        else
        {
            PicFull = lblImagesFull.Text.Trim();
        }
        if (txtImgThum.HasFile)
        {
            //Thumb Images
            if (IO.UploadPhoto(txtImgThum, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 2048, 0, 0, "", 0, out outError, out PicThumb) == false)
            {
                ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
                return;
            }
            else
            {
                PicThumb = pathImages + "" + PicThumb;
            }
        }
        else
        {
            PicThumb = lblImagesThumb.Text.Trim();
        }

        //insert data to database
        try
        {
            if (txtDetail.Text.Length >= 200)
            {
                strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
            }
            else
            {
                strDetailSub = "<p>" + strDetail + ".....</p>";
            }

            //Insert new Event
            if (string.IsNullOrEmpty(lblUID.Text) == true)
            {
                Event tbevent = new Event();

                //Assign values for insert into database
                tbevent.Subject = txtSubject.Text.Trim();
                tbevent.Detail = txtDetail.Text;
                tbevent.PicFull = PicFull;
                tbevent.PicThumbnail = PicThumb;
                tbevent.DepartmentUID = 1;
                tbevent.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
                tbevent.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
                tbevent.Remark = txtRemark.Text.Trim();
                tbevent.CWhen = DateTime.Now;
                tbevent.CUser = Convert.ToInt32(security.LoginUID);
                tbevent.MWhen = DateTime.Now;
                tbevent.MUser = Convert.ToInt32(security.LoginUID);
                tbevent.StatusFlag = rdbActive.Checked == true ? "A" : "D";
                tbevent.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
                tbevent.DetailSub = strDetailSub;
                tbevent.MetaKeywords = txtMetaKeywords.Text.Trim();
                tbevent.MetaDescription = txtMetaDescription.Text.Trim();

                //Insert data of Event to database
                db.Events.InsertOnSubmit(tbevent);
            }
            else //Update existing Event
            {
                var tbEvent = from ev in db.Events
                              where ev.UID == Convert.ToInt32(lblUID.Text.Trim())
                              select ev;
                foreach (Event ev in tbEvent)
                {
                    ev.Subject = txtSubject.Text.Trim();
                    ev.Detail = txtDetail.Text;
                    ev.PicFull = PicFull;
                    ev.PicThumbnail = PicThumb;
                    ev.DepartmentUID = 1;
                    ev.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
                    ev.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
                    ev.Remark = txtRemark.Text.Trim();
                    ev.MWhen = DateTime.Now;
                    ev.MUser = Convert.ToInt32(security.LoginUID);
                    ev.StatusFlag = rdbActive.Checked == true ? "A" : "D";
                    ev.MetaKeywords = txtMetaKeywords.Text.Trim();
                    ev.MetaDescription = txtMetaDescription.Text.Trim();
                    try
                    {
                       ev.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue); 
                    }
                    catch(Exception ex)
                    {
                        ex.ToString();
                    }
                    ev.DetailSub = strDetailSub;
                }
            }
            db.SubmitChanges();
            clsColorBox clsColorBox = new clsColorBox();
            clsColorBox.Refresh();
            //Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
        }
        catch (Exception ex)
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
        }
        
    }