public HttpResponseMessage sp_createIssue_Result(int IDCommunity, string titleIssue, string descriptionIssue, string img1Issue, string img2Issue, int typeIssue)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_createIssue_Result> obtorercord = objdemoentity.sp_createIssue(IDCommunity, titleIssue, descriptionIssue, img1Issue, img2Issue, typeIssue).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_changePassword_Result(int IDUser, string newPassword)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_changePassword_Result> obtorercord = objdemoentity.sp_changePassword(IDUser, newPassword).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_typeBusiness_Result()
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_typeBusiness_Result> obtorercord = objdemoentity.sp_typeBusiness().ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getNotificationsByID_Result(int IDNotification, int IDUser)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getNotificationsByID_Result> obtorercord = objdemoentity.sp_getNotificationsByID(IDNotification, IDUser).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getCommunitiesByUser_Result(int idUser)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getCommunitiesByUser_Result> obtorercord = objdemoentity.sp_getCommunitiesByUser(idUser).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getProvidersByType_Result(int IDType)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getProvidersByType_Result> obtorercord = objdemoentity.sp_getProvidersByType(IDType).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getPlacesToReserve_Result(int IDCommunity)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getPlacesToReserve_Result> obtorercord = objdemoentity.sp_getPlacesToReserve(IDCommunity).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getCitiesbyCountry_Result(string IDCountry)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getCitiesbyCountry_Result> obtorercord = objdemoentity.sp_getCitiesbyCountry(IDCountry).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getProvidersFound_Result(string searchtext)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getProvidersFound_Result> obtorercord = objdemoentity.sp_getProvidersFound(searchtext).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getPlans_Result(int cityApply)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getPlans_Result> obtorercord = objdemoentity.sp_getPlans(cityApply).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_validateUserWithMail_Result(string emailUser, string passwordUser)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_validateUserWithMail_Result> obtorercord = objdemoentity.sp_validateUserWithMail(emailUser, passwordUser).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_getTypes_Result1(string applyTypes)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_getTypes_Result1> obtorercord = objdemoentity.sp_getTypes(applyTypes).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_setAnswerIssue_Result(int IDIssue, string IDUser, string messageAnswer)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_setAnswerIssue_Result> obtorercord = objdemoentity.sp_setAnswerIssue(IDIssue, IDUser, messageAnswer).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_setDataUser_Result(int idUser, string newPassword, int notifyMail, string emailUser, string phoneNumber)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_setDataUser_Result> obtorercord = objdemoentity.sp_setDataUser(idUser, newPassword, notifyMail, emailUser, phoneNumber).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_setReservations_Result(int IDPlace, int IDUSer, DateTime dateReserved, DateTime dateEvent, string reason, int numberPeople, string time, string notes)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_setReservations_Result> obtorercord = objdemoentity.sp_setReservations(IDPlace, IDUSer, dateReserved, dateEvent, reason, numberPeople, time, notes).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}
public HttpResponseMessage sp_setProvider_Result(string nameProvider, int typeProvider, string emailProvider,
string addressProvider, string latitudeProvider, string altitudeProvider, string desriptionProvider, string imageProvider,
int cityProvider, string contactProvider, int typephone1Provider, string numberphone1Provider, int typephone2Provider,
string numberphone2Provider)
{
var objdemoentity = new EcoPropiedadEntities();
List <sp_setProvider_Result> obtorercord = objdemoentity.sp_setProvider(nameProvider, typeProvider, emailProvider,
addressProvider, latitudeProvider, altitudeProvider, desriptionProvider, imageProvider,
cityProvider, contactProvider, typephone1Provider, numberphone1Provider, typephone2Provider,
numberphone2Provider).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, obtorercord.ToList()));
}