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);
}
