Esempio n. 1
0
        public ReturnAllStates GetUserEnrolledState(string User_ID)
        {
            ReturnAllStates rd = new ReturnAllStates();

            try
            {
                decimal id = Convert.ToDecimal(User_ID);

                var states = (from s in db.User_Profile
                              join c in db.State_Master on s.StateEnrolled equals c.ID
                              where s.ID == id
                              select new { c.ID, c.Name, c.ShortName }).ToList();

                if (states.Count <= 0)
                {
                    rd.Status     = "Failure";
                    rd.Message    = "State not found";
                    rd.Requestkey = "GetUserEnrolledState";
                    rd.States     = null;
                    return(rd);
                }

                List <StateMaster> stateList = new List <StateMaster>();

                for (int i = 0; i < states.Count; i++)
                {
                    StateMaster cm = new StateMaster();
                    cm.Id        = Convert.ToDecimal(states[i].ID);
                    cm.Name      = states[i].Name;
                    cm.ShortName = states[i].ShortName;
                    stateList.Add(cm);
                    rd.States = stateList;
                }

                rd.Status     = "Success";
                rd.Message    = "State found";
                rd.Requestkey = "GetUserEnrolledState";
                return(rd);
            }
            catch (Exception)
            {
                rd.Status     = "Failure";
                rd.Message    = "Something went wrong. Please try after some time.";
                rd.Requestkey = "GetUserEnrolledState";
                return(rd);
            }
        }
Esempio n. 2
0
        public ReturnAllStates GetAllStates(decimal countryId)
        {
            ReturnAllStates rd = new ReturnAllStates();

            try
            {
                var states = (from s in db.State_Master
                              where s.Country_ID == countryId
                              select new { s.ID, s.Name, s.ShortName }).ToList();

                if (states.Count <= 0)
                {
                    rd.Status     = "Failure";
                    rd.Message    = "States not found";
                    rd.Requestkey = "GetAllStates";
                    rd.States     = null;
                    return(rd);
                }

                List <StateMaster> stateList = new List <StateMaster>();

                for (int i = 0; i < states.Count; i++)
                {
                    StateMaster cm = new StateMaster();
                    cm.Id        = Convert.ToDecimal(states[i].ID);
                    cm.Name      = states[i].Name;
                    cm.ShortName = states[i].ShortName;
                    stateList.Add(cm);
                    rd.States = stateList;
                }

                rd.Status     = "Success";
                rd.Message    = "States found";
                rd.Requestkey = "GetAllStates";
                return(rd);
            }
            catch (Exception)
            {
                rd.Status     = "Failure";
                rd.Message    = "Something went wrong. Please try after some time.";
                rd.Requestkey = "GetAllStates";
                rd.States     = null;
                return(rd);
            }
        }