public OfferUser GetOfferUser(int idoffer, string idUser)
{
OfferUserRepository <OfferUser> offeruserrepo = new OfferUserRepository <OfferUser>();
OfferUser offeruser = offeruserrepo.GetOfferUser(idoffer, idUser);
return(offeruser);
}
public virtual Entities.Offer GetOfferUser <Offer, OfferUser>(int idoffer)
{
SqlConnection _connection;
Entities.Offer result;
using (_connection = Utilities.GetOpenConnection())
{
//result = _connection.GetListPaged<TEntity>(pagenumber, itemsperpage, conditions, order);
var sql = "";
if (idoffer != -1)
{
sql = "Select Offer.Id, Offer.PrecioFijo, Offer.Sale, Offer.ValueFixedProject, Offer.NumberPhases, Offer.AutomaticValuePhases, Offer.IdUser, Offer.CategoryId, Offer.TitleOffer, Offer.[Description], Offer.RangoValor, Offer.DateOffer" +
",OfferUser.Id, OfferUser.IdOffer, OfferUser.IdUser " +
" FROM Offer inner join OfferUser on Offer.Id=OfferUser.IdOffer inner join AspnetUsers on AspnetUsers.id=OfferUser.IdUser where Offer.Id=" + idoffer + " and Offer.Id NOT IN(SELECT Project.idoffer from project)";
}
else
{
sql = "Select Offer.Id, Offer.PrecioFijo, Offer.Sale, Offer.ValueFixedProject, Offer.NumberPhases, Offer.AutomaticValuePhases, Offer.IdUser, Offer.CategoryId, Offer.TitleOffer, Offer.[Description], Offer.RangoValor, Offer.DateOffer" +
",OfferUser.Id, OfferUser.IdOffer, OfferUser.IdUser " +
" FROM Offer inner join OfferUser on Offer.Id=OfferUser.IdOffer inner join AspnetUsers on AspnetUsers.id=OfferUser.IdUser where Offer.Id NOT IN(SELECT Project.idoffer from project)";
}
result = _connection.Query <Entities.Offer, List <Entities.OfferUser>, Entities.Offer>(
sql,
(offer, offerusers) =>
{
offer.OfferUsers = offerusers;
return(offer);
}
).FirstOrDefault();
// result = _connection.Query<Entities.Offer, Entities.OfferUser, Entities.Offer>(
//sql,
//(offer, offerusers) =>
//{
// offer.OfferUser = offerusers;
// return offer;
//}
//).FirstOrDefault();
OfferUserRepository <OfferUser> offerUrepo = new OfferUserRepository <OfferUser>();
var offerusersre = offerUrepo.GetList(new { IdOffer = idoffer });
if (offerusersre.Count() > 0 && result != null)
{
result.OfferUsers = offerusersre.ToList();
}
return(result);
}
}
