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); } }
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); } }