public DataSet StandardAPI(StandardAPIRequestModel model) { SqlParameter[] sqlParam = new SqlParameter[] { new SqlParameter() { ParameterName = "@Id", Value = CommonHelper.ToDB(model.Id) }, new SqlParameter() { ParameterName = "@ProviderId", Value = CommonHelper.ToDB(model.ProviderId) }, new SqlParameter() { ParameterName = "@OffSet", Value = CommonHelper.ToDB(model.OffSet) }, new SqlParameter() { ParameterName = "@FetchNext", Value = CommonHelper.ToDB(model.FetchNext) }, new SqlParameter() { ParameterName = "@DateTimeSince", Value = CommonHelper.ToDB(model.DateTimeSince) }, }; return(new DatabaseHelper(_connection).GetDatasetData("API_GetStandardProviderList", sqlParam)); }
public HttpResponseMessage StandardAPI(StandardAPIRequestModel model) { try { if (IsValidRequest(Request.Headers)) { if (model != null && ModelState.IsValid) { var RecordList = BLL.StandardAPI(model); if (RecordList.Count > 0) { return(ProvideResponse(RecordList)); } else { return(ProvideResponse <string>(null, HttpStatusCode.NotFound, true, Constants.NotFound)); } } else { return(ProvideResponse <List <KeyMessage> >(GetModelstateErrors(ModelState), HttpStatusCode.BadRequest, false, Constants.BadRequest)); } } else { return(ProvideResponse <string>(null, HttpStatusCode.OK, false, Constants.InvalidAPIKey)); } } catch (Exception ex) { return(ProvideResponse <string>(objCommonHelper.HandleError(ex), HttpStatusCode.InternalServerError, false, Constants.InternalServerError)); } }
public List <APIProvider> StandardAPI(StandardAPIRequestModel model) { List <APIProvider> lstmodel = new List <APIProvider>(); DataSet ds = DAL.StandardAPI(model); if (ds == null) { return(lstmodel); } #region Bind CustomerAPI table field TblCustomerAPI objCustomerAPI = new TblCustomerAPI(); if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow tblCustomerAPI in ds.Tables[0].Rows) { #region fill CustomerAPI table property objCustomerAPI.APIId = SafeValue <int>(tblCustomerAPI["APIId"]); objCustomerAPI.WelcomeTitle = SafeValue <string>(tblCustomerAPI["WelcomeTitle"]); objCustomerAPI.Instruction = SafeValue <string>(tblCustomerAPI["Instruction"]); objCustomerAPI.PrivacyPolicyValue = SafeValue <string>(tblCustomerAPI["PrivacyPolicyValue"]); objCustomerAPI.TermsOfServiceValue = SafeValue <string>(tblCustomerAPI["TermsOfServiceValue"]); objCustomerAPI.FromDate = SafeValue <DateTime>(tblCustomerAPI["FromDate"]); objCustomerAPI.ToDate = SafeValue <DateTime>(tblCustomerAPI["ToDate"]); #endregion } } #endregion #region Bind provider table field if (ds != null && ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { foreach (DataRow row in ds.Tables[1].Rows) { #region Fill Result Set APIProvider obj = new APIProvider(); obj.ProviderId = SafeValue <string>(row["ProviderId"]); obj.PartyId = SafeValue <int>(row["Partyid"]); obj.CreatedDate = SafeValue <DateTime>(row["CreatedDate"]); obj.ModifiedDate = SetModifiedDate(SafeValue <DateTime>(row["ModifiedDate"])); obj.UntilDate = SetModifiedDate(SafeValue <DateTime>(row["UntilDate"])); obj.FKAName = SafeValue <string>(row["FKAName"]); obj.LAName = SafeValue <string>(row["LAName"]); var _Addresses = GetProviderAddresses(ds, obj.ProviderId); obj.Addresses = _Addresses.Count > 0 ? _Addresses : null; var _Memberships = GetProviderMemberShip(ds, obj.ProviderId); obj.Memberships = _Memberships.Count > 0 ? _Memberships : null; var _Phones = GetProviderPhones(ds, obj.ProviderId); obj.Phones = _Phones.Count > 0 ? _Phones : null; var _Questions = GetProviderQuestions(ds, obj.ProviderId); obj.Questions = _Questions.Count > 0 ? _Questions : null; var _Category = GetProviderCategory(ds, obj.ProviderId); obj.Category = _Category.Count > 0 ? _Category : null; obj.WelcomeTitle = objCustomerAPI.WelcomeTitle; obj.Instruction = objCustomerAPI.Instruction; obj.TermsOfServiceValue = objCustomerAPI.TermsOfServiceValue; obj.PrivacyPolicyValue = objCustomerAPI.PrivacyPolicyValue; lstmodel.Add(obj); #endregion } } #endregion return(lstmodel); }