Exemplos de SQL.DataDaigramDataContext em C# (CSharp)

Exemplo n.º 1

Arquivo: Login.cs Projeto: puentepr/thuctapvietinsoft

 private void btnLogin_Click(object sender, EventArgs e)
 {
     HPA.SQL.DataDaigramDataContext dt = new SQL.DataDaigramDataContext();
     string pa = HPA.Common.Encryption.EncryptText(txtPassword.Text, true);
     if (!HPA.Common.StaticVars.UserName.Trim().Equals(string.Empty))
     {
         if (!txtUserName.Text.Trim().Equals(HPA.Common.StaticVars.UserName.Trim()))
         {
             LOGIN_FAILURE.Text = string.Format(Methods.GetMessage("SESSION_CONFLICT"), HPA.Common.StaticVars.UserName); ;
         }
     }
     int Loginid = dt.SC_Login_CheckLogin(txtUserName.Text.Trim(), pa);
     if (Loginid == -1 || Loginid == -2)
     {
         LOGIN_FAILURE.Text = Methods.GetMessage(LOGIN_FAILURE.Name);
         LOGIN_FAILURE.Visible = true;
         txtUserName.Focus();
         LoginSuccess = false;
     }
     else
     {
         LOGIN_FAILURE.Visible = false;
         HPA.Common.StaticVars.LoginID = Loginid;
         HPA.Common.StaticVars.UserName = txtUserName.Text;
         LoginSuccess = true;
         this.Visible = false;
     }
 }

Exemplo n.º 2

Arquivo: Login.cs Projeto: thachgiasoft/thuctapvietinsoft

        private void btnLogin_Click(object sender, EventArgs e)
        {
            HPA.SQL.DataDaigramDataContext dt = new SQL.DataDaigramDataContext();
            string pa = HPA.Common.Encryption.EncryptText(txtPassword.Text, true);

            if (!HPA.Common.StaticVars.UserName.Trim().Equals(string.Empty))
            {
                if (!txtUserName.Text.Trim().Equals(HPA.Common.StaticVars.UserName.Trim()))
                {
                    LOGIN_FAILURE.Text = string.Format(Methods.GetMessage("SESSION_CONFLICT"), HPA.Common.StaticVars.UserName);;
                }
            }
            int Loginid = dt.SC_Login_CheckLogin(txtUserName.Text.Trim(), pa);

            if (Loginid == -1 || Loginid == -2)
            {
                LOGIN_FAILURE.Text    = Methods.GetMessage(LOGIN_FAILURE.Name);
                LOGIN_FAILURE.Visible = true;
                txtUserName.Focus();
                LoginSuccess = false;
            }
            else
            {
                LOGIN_FAILURE.Visible          = false;
                HPA.Common.StaticVars.LoginID  = Loginid;
                HPA.Common.StaticVars.UserName = txtUserName.Text;
                LoginSuccess = true;
                this.Visible = false;
            }
        }

Exemplo n.º 3

Arquivo: Methods.cs Projeto: thachgiasoft/thuctapvietinsoft

 public static bool HasAccessRight(string fullCalssName)
 {
     HPA.SQL.DataDaigramDataContext sqlcon = new SQL.DataDaigramDataContext();
     if (sqlcon.SC_USEROBJECTRIGHT_GET(fullCalssName, HPA.Common.StaticVars.LoginID) <= 0)
     {
         return(false);
     }
     else
     {
         return(true);
     }
 }

Exemplo n.º 4

Arquivo: Methods.cs Projeto: thachgiasoft/thuctapvietinsoft

        public static string GetMessage(string MessID)
        {
            string retVal = string.Empty;

            if (HPA.Common.StaticVars.LanguageID.Equals(string.Empty))
            {
                HPA.Common.StaticVars.LanguageID = "VN";
            }
            HPA.SQL.DataDaigramDataContext sqlcon = new SQL.DataDaigramDataContext();
            sqlcon.Get_Message(MessID, HPA.Common.StaticVars.LanguageID, ref retVal);
            if (retVal.Equals(string.Empty))
            {
                retVal = string.Format("{0} {1}", MessID, HPA.Common.StaticVars.LanguageID);
            }

            return(retVal);
        }

Exemplo n.º 5

Arquivo: Methods.cs Projeto: puentepr/thuctapvietinsoft

        public static string GetMessage(string MessID)
        {
            string retVal = string.Empty;
            if (HPA.Common.StaticVars.LanguageID.Equals(string.Empty))
                HPA.Common.StaticVars.LanguageID = "VN";
            HPA.SQL.DataDaigramDataContext sqlcon = new SQL.DataDaigramDataContext();
            sqlcon.Get_Message(MessID, HPA.Common.StaticVars.LanguageID,ref retVal);
            if (retVal.Equals(string.Empty))
                retVal = string.Format("{0} {1}", MessID, HPA.Common.StaticVars.LanguageID);

            return retVal;
        }

Exemplo n.º 6

Arquivo: Methods.cs Projeto: puentepr/thuctapvietinsoft

 public static bool HasAccessRight(string fullCalssName)
 {
     HPA.SQL.DataDaigramDataContext sqlcon = new SQL.DataDaigramDataContext();
     if (sqlcon.SC_USEROBJECTRIGHT_GET(fullCalssName, HPA.Common.StaticVars.LoginID) <= 0)
         return false;
     else
         return true;
 }