public async Task <IList <oJournal> > GetJournasByProjectCode(DateTime from, DateTime to) { try { if (GlobalInstance.Instance.SqlObject.State == System.Data.ConnectionState.Closed) { GlobalInstance.Instance.SqlObject.Open(); } if (GlobalInstance.Instance.SqlObject.State == System.Data.ConnectionState.Broken || GlobalInstance.Instance.SqlObject.State == System.Data.ConnectionState.Closed) { errMsg = "Unable to connect to server."; var resp = new HttpResponseMessage(HttpStatusCode.Conflict); resp.Content = new StringContent(errMsg); resp.ReasonPhrase = "No Server Connection"; throw new HttpResponseException(resp); } return(await repo.GetByDateRange(from, to)); } catch (HttpResponseException ex) { throw new HttpResponseException(HttpStatusCode.BadRequest); } }