public CGeneralUser Login(string UserName, string PassWord)
        {
            CGeneralUser oResult = new CGeneralUser();

            try
            {
                string  ePassword = _sqlService.GetEncryptString(PassWord);
                DataSet dsLogin   = _sqlService.GetDataSet("TLogin", "uspLogin '" + UserName + "', '" + ePassword + "'");
                using (DataTable dtLogin = dsLogin.Tables["TLogin"])
                {
                    if (dtLogin != null && dtLogin.Rows.Count > 0)
                    {
                        if (Convert.ToBoolean(dtLogin.Rows[0]["Success"]))
                        {
                            // TRUE FOR ORGANIZATION
                            oResult.DisplayName   = dtLogin.Rows[0]["DisplayName"].ToString();
                            oResult.UserID        = Convert.ToInt32(dtLogin.Rows[0]["UserID"]);
                            oResult.LoginTypeCode = Convert.ToInt32(dtLogin.Rows[0]["LoginTypeCode"]);
                            oResult.LastLogged    = Convert.ToDateTime(dtLogin.Rows[0]["LastLogged"]);
                            oResult.Success       = Convert.ToBoolean(dtLogin.Rows[0]["Success"]);
                            oResult.WasSuccessful = Convert.ToInt32(dtLogin.Rows[0]["Success"]);
                            oResult.Exception     = dtLogin.Rows[0]["ErrorSuccessMsg"].ToString();
                        }
                        // FAILED TO LOGIN
                        else
                        {
                            oResult.Success       = Convert.ToBoolean(dtLogin.Rows[0]["Success"]);
                            oResult.WasSuccessful = Convert.ToInt32(dtLogin.Rows[0]["Success"]);
                            oResult.Exception     = dtLogin.Rows[0]["ErrorSuccessMsg"].ToString();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                oResult.Success       = false;
                oResult.WasSuccessful = 0;
                oResult.Exception     = ex.Message;
            }
            return(oResult);
        }