private static DonateProductEntity Get(string hospitalId, string unitId, string vendorId, string productId)
{
var sql = string.Format(@"select {0} from donate_product
where hospital_id=@p_hospital_id and unit_id=@p_unit_id and vendor_id=@p_vendor_id and product_id=@p_product_id", COLUMN);
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "p_hospital_id", DbType.String, hospitalId);
db.AddInParameter(cmd, "p_unit_id", DbType.String, unitId);
db.AddInParameter(cmd, "p_vendor_id", DbType.String, vendorId);
db.AddInParameter(cmd, "p_product_id", DbType.String, productId);
using (var reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
var entity = new DonateProductEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
public static void Get(string hospitalId, string unitId, string vendorId, string productId,
out DonateProductEntity donation, out IList <DonateProductItemEntity> items)
{
donation = Get(hospitalId, unitId, vendorId, productId);
if (donation == null)
{
items = new List <DonateProductItemEntity>();
return;
}
items = GetItems(donation.Id);
}
public bool InsertProduct(ProfilModel pf)
{
DonateProductEntity dpe = new DonateProductEntity();
dpe.IdUtilisateur = pf.IdUser;
dpe.IdAdresse = pf.IdAdresse;
dpe.Quantite = pf.DonateProduct.Quantite;
dpe.IdType = pf.DonateProduct.IdType;
dpe.NameProduct = pf.DonateProduct.Nom;
dpe.Bio = pf.DonateProduct.Bio;
dpe.DatePeremption = pf.DonateProduct.DatePeremption;
dpe.Description = pf.DonateProduct.Description;
dpe.LabelEtat = pf.DonateProduct.Etat;
dpe.Pays = pf.DonateProduct.Pays;
dpe.NomMarque = pf.DonateProduct.Marque;
return(_donateProductRepo.Insert(dpe));
}
public void Get(string hospitalId, string unitId, string vendorId, string productId,
out DonateProductEntity donation, out IList <DonateProductItemEntity> items)
{
DonateProductRepository.Get(hospitalId, unitId, vendorId, productId, out donation, out items);
}
