public Guid InsertUpdateRecord(State objState)
        {
            Guid objReturn = new Guid();

            try
            {
                using (State_DAL objDAL = new State_DAL())
                {
                    objReturn = objDAL.InsertUpdateRecord(objState);
                }
            }
            catch (Exception ex)
            {
                log.Error("InsertUpdateRecord Error: ", ex);
            }
            return(objReturn);
        }
        public State Validate(string email, string password)
        {
            State objReturn = null;

            try
            {
                using (State_DAL objDAL = new State_DAL())
                {
                    objReturn = objDAL.Validate(email, password);
                }
            }
            catch (Exception ex)
            {
                log.Error("Validate Error: ", ex);
            }
            return(objReturn);
        }
        public State GetRecordById(Guid iId)
        {
            State objReturn = null;

            try
            {
                using (State_DAL objDAL = new State_DAL())
                {
                    objReturn = objDAL.GetRecordById(iId);
                }
            }
            catch (Exception ex)
            {
                log.Error("GetRecordById Error: ", ex);
            }
            return(objReturn);
        }
        public StatePage GetRecordPage(int iPageNo, int iPageSize)
        {
            StatePage objReturn = new StatePage();

            try
            {
                using (State_DAL objDAL = new State_DAL())
                {
                    objReturn = objDAL.GetRecordPage(iPageNo, iPageSize);
                }
            }
            catch (Exception ex)
            {
                log.Error("GetRecordPage Error: ", ex);
            }
            return(objReturn);
        }
        public List <State> GetAllRecord()
        {
            List <State> objReturn = null;

            try
            {
                using (State_DAL objDAL = new State_DAL())
                {
                    objReturn = objDAL.GetAllRecord();
                }
            }
            catch (Exception ex)
            {
                log.Error("GetAllRecord Error: ", ex);
            }
            return(objReturn);
        }
        public bool DeleteRecord(int iId)
        {
            bool objReturn = false;

            try
            {
                using (State_DAL objDAL = new State_DAL())
                {
                    objReturn = objDAL.DeleteRecord(iId);
                }
            }
            catch (Exception ex)
            {
                log.Error("DeleteRecord Error: ", ex);
            }
            return(objReturn);
        }