public IActionResult FetchLookup([FromRoute] string ApiKey, [FromBody] LookupObj Param) { IActionResult response; LookupResponse resp = new LookupResponse(); try { #region Call Get_Data_Set LookupDAO ObjResponseDAO = new LookupDAO(_ConStr); DataSet ds = ObjResponseDAO.FetchLookup(ApiKey, Param); #endregion var lookups = (from r in ds.Tables[0].AsEnumerable() select new Lookup() { lookup_id = r.Field <int>("lookup_id"), lookup_code = r.Field <string>("lookup_code"), lookup_description = r.Field <string>("lookup_description"), lookup_name = r.Field <string>("lookup_name") }).ToList(); resp.statuscode = (int)Common.ResponseStatusCode.Success; resp.message = "success"; resp.rows = lookups; response = Ok(resp); } catch (Exception ex) { Common c = new Common(); ExceptionObj exobj = c.GetExceptionObjBase(ex); exobj.form_name = "BodyController"; exobj.page_url = "api/Body/List"; int ReturnVal; string ReturnMsg; ExceptionDAO exd = new ExceptionDAO(_ConStr); exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg); resp.statuscode = (int)Common.ResponseStatusCode.Exception; resp.message = ex.Message.ToString(); response = BadRequest(resp); } return(response); }
/// <summary> Get Loookup By LookupId </summary> /// <param name="LookupId">The Integer object</param> /// <returns>LookupObj object</returns> public LookupObj GetLookupById(int LookupId) { Logging.LogDebugMessage("Method: GetLookupById, MethodType: Get, Layer: LookupsDAL, Parameters: LookupId = " + LookupId.ToString()); var dataSet = new DataSet(); LookupObj lookupObj = new LookupObj(); try { using (var command = new SqlCommand()) { command.Connection = new SqlConnection(this.ConnectionString); command.CommandText = "USP_GetLookupById"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter() { ParameterName = "@LookupId", Value = LookupId }); using (SqlDataAdapter adapter = new SqlDataAdapter(command)) { adapter.Fill(dataSet); if (dataSet != null && dataSet.Tables.Count > 0) { lookupObj = EntityCollectionHelper.ConvertTo <LookupObj>(dataSet.Tables[0]).FirstOrDefault(); lookupObj.lookupDetails = EntityCollectionHelper.ConvertTo <LookupDetails>(dataSet.Tables[1]).ToList(); } } } } catch (SqlException sqlEx) { Logging.LogErrorMessage("Method: GetLookupById, Layer: LookupsDAL, Stack Trace: " + sqlEx.ToString()); throw; } catch (Exception ex) { Logging.LogErrorMessage("Method: GetLookupById, Layer: LookupsDAL, Stack Trace: " + ex.ToString()); throw; } return(lookupObj); }
public DataSet FetchLookup(string ApiKey, LookupObj Param) { DataSet ds = null; try { List <DBParameter> pList = new List <DBParameter>(); pList.Add(new DBParameter("api_Key", SqlDbType.VarChar, 255, ParameterDirection.Input, ApiKey)); pList.Add(new DBParameter("studio_id", SqlDbType.BigInt, 0, ParameterDirection.Input, Param.studio_id)); pList.Add(new DBParameter("lookup_group_id", SqlDbType.BigInt, 0, ParameterDirection.Input, Param.lookup_group_id)); pList.Add(new DBParameter("parent_lookup_id", SqlDbType.BigInt, 0, ParameterDirection.Input, Param.parent_lookup_id)); pList.Add(new DBParameter("lookup_id", SqlDbType.BigInt, 0, ParameterDirection.Input, Param.lookup_id)); objDAO = new DAO(_constr); ds = objDAO.GetDataSet("dbo.Get_LOOKUP", DAO.QueryType.StoredProcedure, pList); return(ds); } catch (Exception) { throw; } }