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