public SellerDTO ReadById(int id)
{
using (InfoSellersEntities data = new InfoSellersEntities())
{
var entity = data.Seller.Find(id);
if (entity != null)
{
return(new SellerDTO()
{
ID = entity.ID,
FullName = entity.FullName,
Active = entity.Active,
CurrentCommission = entity.CurrentCommission,
Nit = entity.Nit,
PenaltyPercentage = entity.PenaltyPercentage,
Phone = entity.Phone,
RolID = entity.RolID,
SellerAddress = entity.SellerAddress
});
}
else
{
return(null);
}
}
}
public void Delete(int id)
{
using (InfoSellersEntities data = new InfoSellersEntities())
{
data.Seller.Remove(data.Seller.Find(id));
data.SaveChanges();
}
}
public SellerDTO Update(SellerDTO entity)
{
using (InfoSellersEntities data = new InfoSellersEntities())
{
var d = data.Seller.Find(entity.ID);
d.Nit = entity.Nit;
d.FullName = entity.FullName;
d.PenaltyPercentage = entity.PenaltyPercentage;
d.Phone = entity.Phone;
d.RolID = entity.RolID;
d.SellerAddress = entity.SellerAddress;
d.Active = entity.Active;
d.CurrentCommission = entity.CurrentCommission;
data.SaveChanges();
}
return(entity);
}
public List <SellerDTO> Read()
{
using (InfoSellersEntities data = new InfoSellersEntities())
{
return(data.Seller.Select(q => new SellerDTO()
{
ID = q.ID,
FullName = q.FullName,
Active = q.Active,
CurrentCommission = q.CurrentCommission,
Nit = q.Nit,
PenaltyPercentage = q.PenaltyPercentage,
Phone = q.Phone,
RolID = q.RolID,
SellerAddress = q.SellerAddress
}).ToList());
}
}
public SellerDTO Create(SellerDTO entity)
{
using (InfoSellersEntities data = new InfoSellersEntities())
{
var newSeller = new Seller()
{
Nit = entity.Nit,
Active = entity.Active,
CurrentCommission = entity.CurrentCommission,
FullName = entity.FullName,
PenaltyPercentage = entity.PenaltyPercentage,
Phone = entity.Phone,
RolID = entity.RolID,
SellerAddress = entity.SellerAddress
};
data.Seller.Add(newSeller);
data.SaveChanges();
entity.ID = newSeller.ID;
}
return(entity);
}