public ModalitePaiement GetByClient(int id) { var res = new ModalitePaiement(); try { using (IDbConnection dbConnection = Connection) { string sQuery = @"select EMR_NO as Numero, EMR_Intitule as Intitule, EMR_Code as Code, EMR_Description as Description from F_MODELREGENT where EMR_NO =@Id and EMR_Code in (select distinct EMR_CODE from F_COMPTET); "; dbConnection.Open(); res = dbConnection.Query <ModalitePaiement>(sQuery, new { Id = id }).FirstOrDefault(); } } catch (Exception) { return(null); } return(res); }
public ModalitePaiement Put([FromBody] ModalitePaiement mdt) { if (ModelState.IsValid) { _ModalitePaiementService.Update(mdt); } return(mdt); }
public ModalitePaiement Update(ModalitePaiement mod) { try { _ModalitePaiementRepository.Update(mod); return(mod); } catch (Exception ex) { throw ex; } }
//public ModalitePaiement GetByClient(int id) //{ // var res = new ModalitePaiement(); // try // { // using (var db = new XSoftContext()) // { // var result = db.Clients.Where(r => r.ModalitePaiementId.Equals(id)).FirstOrDefault(); // } // } // catch (Exception) // { // return null; // } // return res; //} public ModalitePaiement Add(ModalitePaiement dvs) { try { _context.ModalitePaiements.Add(dvs); _context.SaveChanges(); } catch (Exception) { return(null); } return(dvs); }
public ModalitePaiement Update(ModalitePaiement ModalitePaiement) { try { _context.Update(ModalitePaiement); _context.SaveChanges(); } catch (Exception) { return(null); } return(ModalitePaiement); }
public ModalitePaiement Add(ModalitePaiement modalite) { try { _context.ModalitePaiements.Add(modalite); _context.SaveChanges(); return(modalite); } catch (Exception ex) { throw ex; } }
public ModalitePaiement Update(ModalitePaiement ModalitePaiement) { try { _context.Update(ModalitePaiement); _context.SaveChanges(); return(ModalitePaiement); } catch (Exception ex) { throw ex; } }
public ModalitePaiement Update(ModalitePaiement mlt) { try { using (IDbConnection dbConnection = Connection) { string sQuery = @"update F_MODELREGENT set EMR_Intitule=@Intitule,EMR_Code=@Code,EMR_Description=@Description where EMR_NO=@Numero"; dbConnection.Open(); dbConnection.Execute(sQuery, mlt); } } catch (Exception) { return(null); } return(mlt); }
public ModalitePaiement Add(ModalitePaiement mlt) { try { using (IDbConnection dbConnection = Connection) { string sQuery = @"INSERT INTO F_MODELREGENT ( EMR_Intitule,EMR_Code,EMR_Description ) VALUES (@Intitule,@Code,@Description )"; dbConnection.Open(); dbConnection.Execute(sQuery, mlt); } } catch (Exception) { return(null); } return(mlt); }
public ModalitePaiement Update(ModalitePaiement fat) { _ModalitePaiementRepository.Update(fat); return(fat); }
public ModalitePaiement Add(ModalitePaiement fat) { _ModalitePaiementRepository.Add(fat); return(fat); }