private void DtpDePose_SelectedDateChanged_1(object sender, SelectionChangedEventArgs e)
{
if (((DatePicker)sender).SelectedDate.Value != null)
{
CsDetailCampagnePrecontentieux leDetail = (CsDetailCampagnePrecontentieux)lvwResultat.SelectedItem;
leDetail.DATERDV = ((DatePicker)sender).SelectedDate.Value;
}
}
private void dgMyDataGrid_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
DataGrid dg = (sender as DataGrid);
var allObjects = dg.ItemsSource as ObservableCollection <CsDetailCampagnePrecontentieux>;
if (dg.SelectedItem != null)
{
CsDetailCampagnePrecontentieux SelectedObject = (CsDetailCampagnePrecontentieux)dg.SelectedItem;
if (SelectedObject.IsSelect == false)
{
SelectedObject.IsSelect = true;
}
else
{
SelectedObject.IsSelect = false;
}
}
}
public static List <CsDetailCampagnePrecontentieux> RetourneDistinctReglement(List <CsDetailCampagnePrecontentieux> _LstLot)
{
try
{
List <CsDetailCampagnePrecontentieux> _lstLotriDistinct = new List <CsDetailCampagnePrecontentieux>();
var ListLotriTemp = (from p in _LstLot
group new { p } by new { p.CENTRE, p.CLIENT, p.ORDRE, p.NOMABON, p.LIBELLECENTRE, p.PORTE, p.RUE, p.DATERESILIATION, p.SOLDEDUE } into pResult
select new
{
pResult.Key.CENTRE,
pResult.Key.CLIENT,
pResult.Key.ORDRE,
pResult.Key.NOMABON,
pResult.Key.LIBELLECENTRE,
pResult.Key.PORTE,
pResult.Key.RUE,
pResult.Key.DATERESILIATION,
pResult.Key.SOLDEDUE,
MONTANTPAYE = (decimal?)pResult.Sum(o => o.p.SOLDECLIENT)
});
foreach (var item in ListLotriTemp)
{
CsDetailCampagnePrecontentieux leLot = new CsDetailCampagnePrecontentieux()
{
CENTRE = item.CENTRE,
CLIENT = item.CLIENT,
ORDRE = item.ORDRE,
NOMABON = item.NOMABON,
LIBELLECENTRE = item.LIBELLECENTRE,
PORTE = item.PORTE,
RUE = item.RUE,
DATERESILIATION = item.DATERESILIATION,
SOLDEDUE = item.SOLDEDUE,
SOLDECLIENT = item.MONTANTPAYE,
};
_lstLotriDistinct.Add(leLot);
}
return(_lstLotriDistinct);
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsDetailCampagnePrecontentieux> RechercherAbonnemtPrepayePrecontentieux(CsDetailCampagnePrecontentieux leClient)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var query = (
from cli in context.CLIENT
from abon in cli.ABON
where
cli.AG.PORTE.Contains(leClient.RUE) && cli.AG.PORTE.Contains(leClient.PORTE)
//&& cli.CENTRE != leClient.CENTRE && cli.REFCLIENT != leClient.CLIENT && cli.ORDRE != leClient.ORDRE
select new
{
cli.CENTRE,
abon.CLIENT,
cli.ORDRE,
cli.AG.TOURNEE,
cli.AG.ORDTOUR,
cli.CATEGORIE,
cli.NOMABON,
ADRESSE = cli.ADRMAND1,
cli.AG.RUE,
cli.AG.PORTE,
CODESITE = cli.CENTRE1.SITE.CODE,
FK_IDSITE = cli.CENTRE1.FK_IDCODESITE,
LIBELLECENTRE = cli.CENTRE1.LIBELLE,
LIBELLESITE = cli.CENTRE1.SITE.LIBELLE,
});
var dt = Galatee.Tools.Utility.ListToDataTable <object>(query);
return(Entities.GetEntityListFromQuery <CsDetailCampagnePrecontentieux>(dt).Distinct().ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
