private static void Purge()
        {
            try
            {
                var sql1 = "Select coalesce(Count(\"SerialNumberKeeperId\")) FROM \"EnrollKiosk\".\"SerialNumberKeeper\";";

                var check = _repository.RepositoryContext().Database.SqlQuery <int>(sql1).ToList();
                if (check.IsNullOrEmpty())
                {
                    return;
                }
                if (check[0] > 100)
                {
                    sql1 = "Delete FROM \"EnrollKiosk\".\"SerialNumberKeeper\";";
                    _repository.RepositoryContext().Database.ExecuteSqlCommand(sql1);
                }
            }
            catch (Exception ex)
            {
                BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
            }
        }
        public bool DeleteUserRolesByRole(int roleId, out string msg)
        {
            try
            {
                var sql1 =
                    String.Format(
                        "Delete FROM \"ICASWebAdmin\".\"UserRole\"  WHERE \"RoleId\" = {0}", roleId);

                msg = "";
                return(_repository.RepositoryContext().Database.ExecuteSqlCommand(sql1) > 0);
            }
            catch (Exception ex)
            {
                msg = ex.Message;
                BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
                return(false);
            }
        }
示例#3
0
        private ClientStation GetStation(string stationId)
        {
            try
            {
                var sql = new StringBuilder();
                sql.Append(string.Format("SELECT * FROM \"EnrollKiosk\".\"ClientStation\" WHERE \"StationId\" = '{0}'", stationId));

                var retVal = _repository.RepositoryContext()
                             .Database.SqlQuery <ClientStation>(sql.ToString()).ToList();
                if (retVal.IsNullOrEmpty())
                {
                    return(null);
                }
                return(retVal[0]);
            }
            catch (Exception ex)
            {
                BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
                return(null);
            }
        }
示例#4
0
        private bool IsDuplicate(string roleName, out string msg)
        {
            try
            {
                var sql1 =
                    String.Format(
                        "Select * FROM \"EnrollKiosk\".\"Role\"  WHERE lower(\"Name\") = lower('{0}')", roleName.Replace("'", "''"));

                var check = _repository.RepositoryContext().Database.SqlQuery <Role>(sql1).ToList();
                msg = "";
                if (check.IsNullOrEmpty())
                {
                    return(false);
                }
                msg = "Duplicate Error! Item already exist";
                return(true);
            }
            catch (Exception ex)
            {
                msg = "Error: " + ex.Message;
                BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
                return(true);
            }
        }
        private bool doesBeneficiaryInfoExist(int surnameHashed, int dobHashed, int mobileHashed, int othernameHashed, int firstnameHashed, int sex, int calType, out string msg)
        {
            try
            {
                var sql = new StringBuilder();
                sql.Append(string.Format("SELECT * FROM \"EnrollKiosk\".\"Beneficiary\" WHERE 1 = 1"));

                if (Math.Abs(surnameHashed) > 0)
                {
                    sql.Append(string.Format(" AND \"SurnameHashed\" = {0}", surnameHashed));
                }

                if (Math.Abs(dobHashed) > 0)
                {
                    sql.Append(string.Format(" AND \"DateOfBirthHashed\" = {0}", dobHashed));
                }

                if (Math.Abs(mobileHashed) > 0)
                {
                    sql.Append(string.Format(" AND \"MobileNoHashed\" = {0}", mobileHashed));
                }

                if (Math.Abs(firstnameHashed) > 0)
                {
                    sql.Append(string.Format(" AND \"FirstNameHashed\" = {0}", firstnameHashed));
                }

                if (Math.Abs(othernameHashed) > 0)
                {
                    sql.Append(string.Format(" AND \"OtherNameHashed\" = {0}", othernameHashed));
                }

                if (sex > 0 && sex < 3)
                {
                    sql.Append(string.Format(" AND \"Sex\" = {0}", sex));
                }

                var retVal = _repository.RepositoryContext()
                             .Database.SqlQuery <Beneficiary>(sql.ToString()).ToList();
                if (retVal.IsNullOrEmpty())
                {
                    msg = "";
                    return(false);
                }
                if (calType == 2)
                {
                    if (retVal.Count == 1)
                    {
                        msg = "";
                        return(false);
                    }
                }
                msg = "";
                return(true);
            }
            catch (Exception ex)
            {
                msg = ex.Message;
                BugManager.LogApplicationBug(ex.StackTrace, ex.Source, ex.Message);
                return(true);
            }
        }