public static DataTable RetourneListeValidation()
{
//cmd.CommandText = "SPX_GUI_RETOURNE_DABON";
try
{
using (galadbEntities context = new galadbEntities())
{
IEnumerable <object> query = null;
var _RCL_Validation = context.RCL_Validation;
query =
from p in _RCL_Validation
select new
{
PK_ID = p.id,
p.Code,
p.Libelle
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void ValiderReclamation(CsDemandeReclamation pDemandeRecl, galadbEntities pContext)
{
try
{
galadbEntities contextinter = new galadbEntities();
RCL_Reclamation _Reclamation = new RCL_Reclamation();
if (pDemandeRecl.ReclamationRcl != null)
{
_Reclamation = Entities.ConvertObject <RCL_Reclamation, CsReclamationRcl>(pDemandeRecl.ReclamationRcl);
}
Entities.UpdateEntity <RCL_Reclamation>(_Reclamation, pContext);
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
//var errorMessages = ex.EntityValidationErrors
// .SelectMany(x => x.ValidationErrors)
// .Select(x => x.ErrorMessage);
//// Join the list to a single string.
//var fullErrorMessage = string.Join("; ", errorMessages);
//// Combine the original exception message with the new one.
//var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
////return exceptionMessage;
//// Throw a new DbEntityValidationException with the improved exception message.
//throw new System.Data.Entity.Validation.DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
throw ex;
}
}
public static bool UpdateEntity <T>(List <T> pEntity, galadbEntities pContext) where T : class
{
try
{
foreach (T _entity in pEntity)
{
try
{
if (pContext.Entry(_entity).State == EntityState.Detached)
{
pContext.Set <T>().Attach(_entity);
}
pContext.Entry(_entity).State = EntityState.Modified;
}
catch
{
continue;
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable ListeMenuSousMenu(string pModuleName, int Fk_idProfil)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var admMenu = context.ADMMENU;
var MenuProfil = context.MENUSDUPROFIL;
IEnumerable <object> query =
from _MenuProfil in MenuProfil
where _MenuProfil.ADMMENU.MODULE1.CODE == pModuleName && _MenuProfil.FK_IDPROFIL == Fk_idProfil
select new
{
Module = _MenuProfil.ADMMENU.MODULE,
MenuID = _MenuProfil.ADMMENU.PK_ID, //PK_MENUID,
MenuText = _MenuProfil.ADMMENU.MENUTEXT,
MainMenuID = _MenuProfil.ADMMENU.MAINMENUID,
FormName = _MenuProfil.ADMMENU.FORMENAME,
IsDock = _MenuProfil.ADMMENU.ISDOCK,
IsControl = _MenuProfil.ADMMENU.ISCONTROLE,
IdGroupProgram = _MenuProfil.ADMMENU.MODULE1.FK_IDGROUPPROGRAM,
MenuOrder = _MenuProfil.ADMMENU.MENUORDER,
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CsTypeCompte> RetourneTypeCompte()
{
try
{
using (galadbEntities context = new galadbEntities())
{
var _TypeCompte = context.COMPTA_TYPE_COMPTE;
IEnumerable <object> query =
from x in _TypeCompte
select new
{
x.CODE,
x.LIBELLE,
x.PK_ID,
x.AVECFILTRE,
x.TABLEFILTRE,
x.TABLEFILTRE1,
x.TABLEFILTRE2,
x.SIGNE,
x.SOUSCOMPTE,
x.VALEURMONTANT,
x.USERCREATION,
x.USERMODIFICATION,
x.DATECREATION,
x.DATEMODIFICATION
};
DataTable dt = Galatee.Tools.Utility.ListToDataTable(query);
return(Entities.GetEntityListFromQuery <CsTypeCompte>(dt));
}
}
catch (Exception ex)
{
throw;
}
}
public static List <CsCentreCompte> RetourneParamCentre()
{
try
{
using (galadbEntities context = new galadbEntities())
{
var _TBanqueCompte = context.COMPTA_CENTRE;
IEnumerable <object> query =
from x in _TBanqueCompte
select new
{
x.PK_ID,
x.CODEACTIVITE,
x.CODECENTRE,
x.DC,
x.LIBELLEACTIVITE,
x.CODECOMPTA,
x.CI
};
DataTable dt = Galatee.Tools.Utility.ListToDataTable(query);
return(Entities.GetEntityListFromQuery <CsCentreCompte>(dt));
}
}
catch (Exception ex)
{
throw;
}
}
public static List <CsOperationComptable> RetourneOperationComptable()
{
try
{
using (galadbEntities context = new galadbEntities())
{
var _Operation = context.COMPTA_OPERATIONCOMPTABLE;
IEnumerable <object> query =
from x in _Operation
select new
{
x.CODE,
x.LIBELLE,
x.PK_ID,
x.COPERIDENTIFIANT,
x.FK_IDCOPER,
x.COPER.DC,
x.USERCREATION,
x.USERMODIFICATION,
x.DATECREATION,
x.DATEMODIFICATION,
x.LIBELLECOMPTABLE
};
DataTable dt = Galatee.Tools.Utility.ListToDataTable(query);
return(Entities.GetEntityListFromQuery <CsOperationComptable>(dt));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int MAJImportFichier(Galatee.Structure.aImportFichier leParametrage)
{
try
{
using (galadbEntities context = new galadbEntities())
{
PARAMETRAGEIMPORT import = context.PARAMETRAGEIMPORT.FirstOrDefault(c => c.CODE == leParametrage.CODE);
if (import != null)
{
PARAMETRAGEIMPORT _limport = Entities.ConvertObject <PARAMETRAGEIMPORT, Galatee.Structure.aImportFichier>(leParametrage);
Entities.UpdateEntity <PARAMETRAGEIMPORT>(_limport);
return(_limport.CODE);
}
else
{
PARAMETRAGEIMPORT _limport = Entities.ConvertObject <PARAMETRAGEIMPORT, Galatee.Structure.aImportFichier>(leParametrage);
Entities.InsertEntity <PARAMETRAGEIMPORT>(_limport);
return(_limport.CODE);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable RetourneListeModeReception()
{
//cmd.CommandText = "SPX_GUI_RETOURNE_DABON";
try
{
using (galadbEntities context = new galadbEntities())
{
IEnumerable <object> query = null;
var _SousControle = context.MODERECEPTION;
query =
from p in _SousControle
select new
{
p.PK_ID,
p.LIBELLE
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveAgent(List <Structure.CsAgent> agenttosynchro, string Requette)
{
using (galadbEntities Context = new galadbEntities())
{
PARAMETRESGENERAUX PARAMETRESGENERAUX = Context.PARAMETRESGENERAUX.FirstOrDefault(p => p.CODE == "000406");
if (PARAMETRESGENERAUX != null)
{
PARAMETRESGENERAUX.LIBELLE = Requette;
List <CsAgent> NouveauAgent = agenttosynchro.Where(a => a.ACTIF == true) != null?agenttosynchro.Where(a => a.ACTIF == true).ToList() : new List <CsAgent>();
List <AGENT> AgentToInsert = ConvertAgent(NouveauAgent);
List <string> MatriculeAgent_a_Desactiver = agenttosynchro.Where(a => a.ACTIF == false).Select(a => a.MATRICULE).ToList();
List <ADMUTILISATEUR> UTILISATEUR = Context.ADMUTILISATEUR.Where(u => MatriculeAgent_a_Desactiver.Contains(u.MATRICULE)) != null?Context.ADMUTILISATEUR.Where(u => MatriculeAgent_a_Desactiver.Contains(u.MATRICULE)).ToList() : new List <ADMUTILISATEUR>();
foreach (var item in UTILISATEUR)
{
item.STATUSCOMPTE = Enumere.StatusSupprimer;
}
Entities.UpdateEntity <ADMUTILISATEUR>(UTILISATEUR, Context);
Entities.UpdateEntity <PARAMETRESGENERAUX>(PARAMETRESGENERAUX, Context);
bool result = Entities.InsertEntity <AGENT>(AgentToInsert, Context);
Context.SaveChanges();
return(result);
}
else
{
return(false);
}
}
}
public static string LoadRequest()
{
using (galadbEntities Context = new galadbEntities())
{
return(Context.PARAMETRESGENERAUX.FirstOrDefault(p => p.CODE == "000406").LIBELLE);
}
}
public static bool DeleteImportFichier(int CodeImport)
{
try
{
using (galadbEntities context = new galadbEntities())
{
PARAMETRAGEIMPORT import = context.PARAMETRAGEIMPORT.FirstOrDefault(c => c.CODE == CodeImport);
if (import != null)
{
List <IMPORTCOLONNE> lstcolon = context.IMPORTCOLONNE.Where(c => c.ID_PARAMETRAGE == CodeImport).ToList();
foreach (IMPORTCOLONNE colon in lstcolon)
{
context.IMPORTCOLONNE.Remove(colon);
context.SaveChanges();
}
context.PARAMETRAGEIMPORT.Remove(import);
context.SaveChanges();
return(true);
}
else
{
return(false);
}
};
}
catch (Exception ex)
{
return(false);
throw ex;
}
}
public static DataTable GetProfilUserByLoginName(int pIdUSer)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var profiluser = context.PROFILSUTILISATEUR;
IEnumerable <object> query =
from c in profiluser
join a in context.MODULESDEFONCTION on c.PROFIL.FK_IDFONCTION equals a.FK_IDFONCTION
where c.FK_IDADMUTILISATEUR == pIdUSer
//&& c.DATEDEBUT.Value <= System.DateTime.Today.Date
// && (c.DATEFIN >= System.DateTime.Today || c.DATEFIN == null)
select new
{
c.PROFIL.CODE,
c.PROFIL.FK_IDFONCTION,
c.PROFIL.LIBELLE,
c.PK_ID,
c.DATEDEBUT,
c.DATEFIN,
CODEFONCTION = c.PROFIL.FONCTION.CODE,
c.PROFIL.FONCTION.ROLENAME,
MODULE = a.MODULE.CODE,
c.FK_IDPROFIL,
c.FK_IDADMUTILISATEUR
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static decimal?RetourneSoldeInitialDocumentCampagne(string centre, string client, string ordre, string ndoc, string campagne)
{
using (galadbEntities context = new galadbEntities())
{
decimal?sommeDebit = null;
decimal?sommeCredit = null;
var _lclientDebiteur = context.LCLIENT.Where(cl => cl.CENTRE == centre && cl.CLIENT == client && cl.ORDRE == ordre && cl.NDOC == ndoc && cl.DC == Enumere.Debit && cl.IDCOUPURE == campagne);
if (_lclientDebiteur != null && _lclientDebiteur.Count() > 0)
{
sommeDebit = _lclientDebiteur.Sum(cl => cl.MONTANT);
}
else
{
sommeDebit = 0;
}
var _lclientCrediteur = context.LCLIENT.Where(cl => cl.CENTRE == centre && cl.CLIENT == client && cl.ORDRE == ordre && cl.NDOC == ndoc && cl.DC == Enumere.Credit && cl.IDCOUPURE == campagne);
if (_lclientCrediteur != null && _lclientCrediteur.Count() > 0)
{
sommeCredit = _lclientCrediteur.Sum(cl => cl.MONTANT);
}
else
{
sommeCredit = 0;
}
sommeDebit = sommeDebit == null ? 0 : sommeDebit;
sommeCredit = sommeCredit == null ? 0 : sommeCredit;
decimal?difference = (sommeDebit - sommeCredit);
return((difference < 0) ? 0 : difference);
}
}
public static DataTable GetCentreAffectation(int pIdUSer)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var CentreAffectation = context.CENTREAFFECTATION;
IEnumerable <object> query =
from c in CentreAffectation
where c.FK_IDADMUTILISATEUR == pIdUSer
select new
{
c.PK_ID,
c.FK_IDCENTRE,
c.FK_IDADMUTILISATEUR,
c.DATEFINVALIDITE,
c.DATEDEBUTVALIDITE
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable ListeMenuParHabilitationProfil(string module)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var admMenu = context.ADMMENU;
var Program = context.MODULE;
IEnumerable <object> query =
from _admMenu in admMenu
join _Program in Program on _admMenu.MODULE.ToLower() equals _Program.CODE.ToLower()
where _admMenu.MODULE.ToUpper() == module.ToUpper()
select new
{
Module = _admMenu.MODULE,
MenuID = _admMenu.PK_ID, //PK_MENUID,
MenuText = _admMenu.MENUTEXT,
MainMenuID = _admMenu.MAINMENUID,
FormName = _admMenu.FORMENAME,
IsDock = _admMenu.ISDOCK,
IsControl = _admMenu.ISCONTROLE,
IdGroupProgram = _Program.FK_IDGROUPPROGRAM,
MenuOrder = _admMenu.MENUORDER,
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetCentreDesProfilsUserByLoginName(int pIdUSer, int pIdrofil)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var Centreuser = context.CENTREDUPROFIL;
IEnumerable <object> query =
from c in Centreuser
where c.FK_IDADMUTILISATEUR == pIdUSer && c.FK_IDPROFIL == pIdrofil && c.DATEFINVALIDITE == null
select new
{
c.PK_ID,
c.FK_IDADMUTILISATEUR,
c.FK_IDPROFIL,
c.FK_IDCENTRE,
c.DATEDEBUTVALIDITE,
c.DATEFINVALIDITE,
FK_IDSITE = c.CENTRE1.SITE.PK_ID
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool MAJImportColonne(Galatee.Structure.aImportFichierColonne lacolonne)
{
try
{
using (galadbEntities context = new galadbEntities())
{
IMPORTCOLONNE colon = context.IMPORTCOLONNE.FirstOrDefault(c => c.ID_COLONNE == lacolonne.ID_COLONNE);
if (colon != null)
{
IMPORTCOLONNE _lacolonne = Entities.ConvertObject <IMPORTCOLONNE, Galatee.Structure.aImportFichierColonne>(lacolonne);
return(Entities.UpdateEntity <IMPORTCOLONNE>(_lacolonne));
}
else
{
IMPORTCOLONNE _lacolonne = Entities.ConvertObject <IMPORTCOLONNE, Galatee.Structure.aImportFichierColonne>(lacolonne);
return(Entities.InsertEntity <IMPORTCOLONNE>(_lacolonne));
}
};;
}
catch (Exception ex)
{
throw ex;
}
}
public static bool RemoveInsertEntity <T>(List <T> pEntity) where T : class
{
try
{
using (galadbEntities context = new galadbEntities())
{
foreach (T _entity in pEntity) // suppression des habilitation dans la base
{
if (context.Entry(_entity).State == EntityState.Detached)
{
context.Set <T>().Attach(_entity);
context.Set <T>().Remove(_entity);
}
}
context.SaveChanges();
foreach (T _entity in pEntity) // suppression des habilitation dans la base
{
if (context.Entry(_entity).State == EntityState.Detached)
{
context.Set <T>().Attach(_entity);
context.Set <T>().Remove(_entity);
}
}
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable ListeDesClientPourEnvoieMailDiffusion(int pidCentre, int pidSite, int pidCategorie, int pidTourne, bool sms, bool email)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var _Ag = context.AG;
var query = (
from t in _Ag
from x in t.CLIENT1
from br in t.BRT
where
(t.FK_IDTOURNEE == pidTourne || pidTourne == 0) &&
(x.FK_IDCENTRE == pidCentre || pidCentre == 0) &&
(x.CENTRE1.SITE.PK_ID == pidSite || pidSite == 0) &&
(x.FK_IDCATEGORIE == pidCategorie || pidCategorie == 0) &&
(x.EMAIL != null || x.TELEPHONE != null)
select new
{
x.CENTRE,
client = x.REFCLIENT,
numfact = "",
periode = "",
x.ORDRE,
NomClient = x.NOMABON,
x.EMAIL
,
x.ISFACTUREEMAIL,
x.ISFACTURESMS,
x.TELEPHONE
});
var lst = query.ToList();
if (!sms && !email && query != null)
{
query = (from x in query
where x.ISFACTUREEMAIL.Value || x.ISFACTURESMS.Value
select x);
}
else if (sms && query != null)
{
query = (from x in query
where x.ISFACTURESMS.Value
select x);
}
else if (email && query != null)
{
query = (from x in query
where x.ISFACTUREEMAIL.Value
select x);
}
return(Galatee.Tools.Utility.ListToDataTable(query.ToList()));
}
}
catch (Exception ex)
{
throw ex;
}
}
private static DataTable RetournReglementByCrytere(int IdCentre, List <int> lstIdcaisse, List <string> OperationSelect, DateTime?DateCaisseDebut, DateTime?DateCaisseFin, DateTime?Date)
{
using (galadbEntities context = new galadbEntities())
{
IEnumerable <object> query;
query = ReglementByCrytere(IdCentre, lstIdcaisse, OperationSelect, DateCaisseDebut, DateCaisseFin, Date, context);
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
public static DataTable GetUserByLoginName(string pLogin)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var AdmUtilisateur = context.ADMUTILISATEUR;
IEnumerable <object> query =
from admUtilisateur in AdmUtilisateur
where admUtilisateur.LOGINNAME.ToUpper() == pLogin.ToUpper()
select new
{
CENTRE = admUtilisateur.CENTRE,
admUtilisateur.MATRICULE,
admUtilisateur.LIBELLE,
admUtilisateur.PASSE,
admUtilisateur.DMAJ,
admUtilisateur.TRANS,
admUtilisateur.LOGINNAME,
admUtilisateur.E_MAIL,
admUtilisateur.DATEDERNIEREMODIFICATION,
admUtilisateur.DATEDEBUTVALIDITE,
admUtilisateur.DATEFINVALIDITE,
admUtilisateur.STATUSCOMPTE,
admUtilisateur.DATEDERNIEREMODIFICATIONPASSWORD,
admUtilisateur.INITUSERPASSWORD,
admUtilisateur.NOMBREECHECSOUVERTURESESSION,
admUtilisateur.DATEDERNIERECONNEXION,
admUtilisateur.DERNIERECONNEXIONREUSSIE,
admUtilisateur.DATEDERNIERVERROUILLAGE,
admUtilisateur.BRANCHE,
admUtilisateur.PERIMETREACTION,
admUtilisateur.ESTSUPPRIMER,
admUtilisateur.USERCREATION,
admUtilisateur.DATEMODIFICATION,
admUtilisateur.USERMODIFICATION,
admUtilisateur.DATECREATION,
////admUtilisateur.FK_IDFONCTION,
admUtilisateur.FK_IDCENTRE,
FK_IDANCIENCENTRE = admUtilisateur.FK_IDCENTRE,
PK_ID = admUtilisateur.PK_ID,
admUtilisateur.FK_IDSTATUS,
admUtilisateur.COMPTEWINDOW,
NOM = admUtilisateur.LIBELLE,
admUtilisateur.TELEPHONE,
LIBELLESTATUSCOMPTE = admUtilisateur.ADMSTATUSCOMPTE.LIBELLE,
LIBELLECENTRE = admUtilisateur.CENTRE1.LIBELLE,
////LIBELLEFONCTION = admUtilisateur.FONCTION1.ROLENAME,
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static decimal?RetourneSoldeClientDate(int?Pk_Id, DateTime?date)
{
try
{
using (galadbEntities context = new galadbEntities())
{
string centre = string.Empty;
string client = string.Empty;
string ordre = string.Empty;
decimal?sommeDebit = null;
decimal?sommeCredit = null;
decimal?paiement = null;
List <LCLIENT> _lclientDebiteur = context.LCLIENT.Where(cl => cl.FK_IDCLIENT == Pk_Id && cl.DC == Enumere.Debit && cl.DENR <= date && cl.TOP1 != "2").ToList();
if (_lclientDebiteur != null)
{
centre = _lclientDebiteur[0].CENTRE;
client = _lclientDebiteur[0].CLIENT;
ordre = _lclientDebiteur[0].ORDRE;
sommeDebit = _lclientDebiteur.GroupBy(cl => new { cl.FK_IDCLIENT, cl.DC }).Select(cl => cl.Sum(x => x.MONTANT).Value).FirstOrDefault();
}
else
{
sommeDebit = 0;
}
IEnumerable <LCLIENT> _lclientCrediteur = context.LCLIENT.Where(cl => cl.FK_IDCLIENT == Pk_Id && cl.DC == Enumere.Credit && cl.DENR <= date && cl.TOP1 != "2");
if (_lclientCrediteur != null)
{
sommeCredit = _lclientDebiteur.GroupBy(cl => new { cl.FK_IDCLIENT, cl.DC }).Select(cl => cl.Sum(x => x.MONTANT).Value).FirstOrDefault();
}
else
{
sommeCredit = 0;
}
IEnumerable <TRANSCAISB> _paiementLclient = context.TRANSCAISB.Where(cl => cl.CLIENT == centre && cl.CLIENT == client && cl.ORDRE == ordre && cl.TOPANNUL == null && cl.DTRANS <= date);
if (_paiementLclient != null)
{
paiement = _paiementLclient.GroupBy(p => new { p.CENTRE, p.CLIENT, p.ORDRE }).Select(p => p.Sum(x => (Char.Parse(x.DC) - 'D') * x.MONTANT - ('C' - Char.Parse(x.DC)) * x.MONTANT) +
p.Sum(x => (Char.Parse(x.DC) - 'D') * x.ECART - ('C' - Char.Parse(x.DC)) * x.ECART)).FirstOrDefault();
}
else
{
paiement = 0;
}
return(sommeDebit - sommeCredit - paiement);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int RetourneEtatCaisse(string matricule, int?Fk_IdCaisse)
{
try
{
using (galadbEntities context = new galadbEntities())
{
var clientT = context.TRANSCAISSE.Where(c => c.MATRICULE == matricule && c.DTRANS < DateTime.Today.Date && c.SAISIPAR == null && c.COPER != Enumere.CoperAjsutemenFondCaisse && c.COPER != Enumere.CoperFondCaisse);
if (clientT != null && clientT.Count() > 0)
{
if (!string.IsNullOrEmpty(clientT.First().CLIENT))
{
return(3);
}
}
var HabilCaisse = context.HABILITATIONCAISSE.Where(c => c.MATRICULE == matricule && c.DATE_DEBUT < DateTime.Today.Date && c.DATE_FIN == null);
if (HabilCaisse != null && HabilCaisse.Count() > 0)
{
return(3);
}
/* CAISSE DEJA ARRETE*/
//IEnumerable<TRANSCAISB> clientB = context.TRANSCAISB.Where(c => c.MATRICULE == matricule && c.HABILITATIONCAISSE.FK_IDCAISSE == Fk_IdCaisse && c.DTRANS == DateTime.Today && c.SAISIPAR == null && c.FK_IDHABILITATIONCAISSE != null);
//c'etait fait pour gerer la mobilité de caisse donc on verifie la caisse du centre mais a cause des problem au demarage je commente 01/10/2016
IEnumerable <TRANSCAISB> clientB = context.TRANSCAISB.Where(c => c.MATRICULE == matricule && c.DTRANS == DateTime.Today.Date && c.SAISIPAR == null && c.FK_IDHABILITATIONCAISSE != null);
if (clientB != null && clientB.Count() > 0)
{
if (!string.IsNullOrEmpty(clientB.First().CLIENT))
{
return(2);
}
}
/*Caisse ouverte a la demande*/
var clientO = context.OPENINGDAY.Where(c => c.KEYEDBY == matricule && c.OPEN == Enumere.CaisseStatOuverte);
if (clientO != null && clientO.Count() > 0)
{
if (!string.IsNullOrEmpty(clientO.First().KEYEDBY))
{
return(4);
}
}
/*journée précédente non arretée*/
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable RetourneListeReclamation()
{
//cmd.CommandText = "SPX_GUI_RETOURNE_DABON";
try
{
using (galadbEntities context = new galadbEntities())
{
IEnumerable <object> query = null;
var _RCL_Reclamation = context.RCL_Reclamation;
query =
from p in _RCL_Reclamation
select new
{
p.PK_ID,
p.Ordre,
p.NumeroReclamation,
p.Fk_IdTypeReclamation,
p.NomClient,
p.Fk_IdClient,
p.DateOuverture,
p.DateTransmission,
p.AgentEmetteur,
p.AgentRecepteur,
p.AgentValidation,
p.DateRdv,
p.DateRetourSouhaite,
p.DateRetour,
p.Observation,
p.Fk_IdModeReception,
p.Adresse,
p.Email,
p.NumeroTelephonePortable,
p.NumeroTelephoneFixe,
p.ObjetReclamation,
p.ActionMenees,
p.Fk_IdStatutReclamation,
p.MotifReprise,
p.NonConformite,
p.LettreReponse,
p.DateValidation,
p.MotifRejet,
p.Fk_IdCentre,
};
return(Galatee.Tools.Utility.ListToDataTable(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete(Guid IdStrategieSecurite)
{
//SqlCommand cmd = new SqlCommand("spx_AdmStrategieSecurite_Delete", cn);
try
{
Galatee.Entity.Model.ADMSTRATEGIESECURITE entity = new Galatee.Entity.Model.galadbEntities().ADMSTRATEGIESECURITE.Where(pk => pk.PK_ID == IdStrategieSecurite).FirstOrDefault();
Entities.DeleteEntity <Galatee.Entity.Model.ADMSTRATEGIESECURITE>(entity);
}
catch (Exception e)
{
throw e;
}
}
public static List <CsCompteSpecifique> RetourneCompteSpecifique()
{
try
{
using (galadbEntities Context = new galadbEntities())
{
#region Récupe données à Manipuler depuis la BD
var COMPTE_SPECIFIQUE = Context.COMPTA_COMPTE_SPECIFIQUE;
#endregion
#region Convertion des type de facture comptable en structure
List <CsCompteSpecifique> ListeCompteSpecifique = Entities.ConvertObject <CsCompteSpecifique, COMPTA_COMPTE_SPECIFIQUE>(COMPTE_SPECIFIQUE != null ? COMPTE_SPECIFIQUE.ToList() : new List <COMPTA_COMPTE_SPECIFIQUE>());
#endregion
foreach (CsCompteSpecifique item in ListeCompteSpecifique)
{
if (!string.IsNullOrEmpty(item.VALEURFILTRE))
{
item.LSTVALEURFILTRE = new List <string>();
string[] valeur = item.VALEURFILTRE.Split(';');
foreach (var items in valeur)
{
item.LSTVALEURFILTRE.Add(items);
}
}
if (!string.IsNullOrEmpty(item.VALEURFILTRE1))
{
item.LSTVALEURFILTRE1 = new List <string>();
string[] valeur = item.VALEURFILTRE1.Split(';');
foreach (var items in valeur)
{
item.LSTVALEURFILTRE1.Add(items);
}
}
if (!string.IsNullOrEmpty(item.VALEURFILTRE2))
{
item.LSTVALEURFILTRE2 = new List <string>();
string[] valeur = item.VALEURFILTRE2.Split(';');
foreach (var items in valeur)
{
item.LSTVALEURFILTRE2.Add(items);
}
}
}
return(ListeCompteSpecifique);
}
}
catch (Exception)
{
throw;
}
}
public static List <CsTypeFactureComptable> RetourneTypeFacture()
{
try
{
using (galadbEntities Context = new galadbEntities())
{
//#region Récupe données à Manipuler depuis la BD
//var TYPE_FACTURE_COMPTABILISE = Context.TYPE_FACTURE_COMPTABILISE;
//var COPERS = Context.COPER_TYPE_FACTURE_COMPTABILISE;
//var TYPE_COMPTE_TYPE_FACTURE_COMPTABLE = Context.TYPE_COMPTE_TYPE_FACTURE_COMPTABLE;
//#endregion
//#region Convertion des type de facture comptable en structure
//List<CsTypeFactureComptable> ListeTypeFacture = Entities.ConvertObject<CsTypeFactureComptable, TYPE_FACTURE_COMPTABILISE>(TYPE_FACTURE_COMPTABILISE != null ? TYPE_FACTURE_COMPTABILISE.ToList() : new List<TYPE_FACTURE_COMPTABILISE>());
//#endregion
//#region Récupérartion des des code opération(COPER) lié à chaque Type de facture comptable
//foreach (var item in ListeTypeFacture)
//{
// var LISTCOPER = COPERS.Where(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID);
// item.LISTCOPER = LISTCOPER != null ? LISTCOPER.Select(c => c.COPER.CODE).ToList() : new List<string>();
// //item.DC = TYPE_COMPTE_TYPE_FACTURE_COMPTABLE.FirstOrDefault(c => c.FK_IDTYPE_COMPTE == item.PK_ID).DC;f
//}
//#endregion
//#region Récupérartion des comptes (COPER) et des Type de compte(en indiquant la direction:debit ou credit) lié à chaque Type de facture comptable
//foreach (var item in ListeTypeFacture)
//{
// //Récupérartion des comptes (COPER)
// var LISTCOPER = COPERS.Where(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID);
// item.LISTCOPER = LISTCOPER != null ? LISTCOPER.Select(c => c.COPER.CODE).ToList() : new List<string>();
// //Récupérartion des Type de compte(en indiquant la direction:debit ou credit)
// var LISTTYPECOMPTE = TYPE_COMPTE_TYPE_FACTURE_COMPTABLE.Where(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID);
// item.LISTTYPECOMPTE = LISTTYPECOMPTE != null ? Entities.ConvertObject<CsTypeCompte, TYPE_COMPTE>(LISTTYPECOMPTE.Select(c => c.TYPE_COMPTE).ToList()) : new List<CsTypeCompte>();
// //En indiquant la direction:debit ou credit
// item.LISTTYPECOMPTE.ForEach(t => t.DC = LISTTYPECOMPTE.FirstOrDefault(c => c.FK_IDTYPE_FACTUE_COMPTABILISER == item.PK_ID && c.FK_IDTYPE_COMPTE == c.PK_ID).DC);
//}
//#endregion
//return ListeTypeFacture;
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public static List <PARAMETRAGEIMPORT> RetourneAllImportFichier()
{
try
{
using (galadbEntities context = new galadbEntities())
{
return(context.PARAMETRAGEIMPORT.ToList());
};
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SelectHabilitationByUser(int pIduser)
{
try
{
using (galadbEntities context = new galadbEntities())
{
List <PROFILSUTILISATEUR> profiluser = context.PROFILSUTILISATEUR.Where(t => t.FK_IDADMUTILISATEUR == pIduser && t.DATEFIN == null).ToList();
IEnumerable <object> query =
(from _profiluser in profiluser
from _menuPro in _profiluser.PROFIL.FONCTION.MODULESDEFONCTION
select new
{
FK_IDPROFIL = _profiluser.PROFIL.PK_ID,
FK_CODEFONCTION = _profiluser.PROFIL.FONCTION.PK_ID,
FK_IDMODULE = _menuPro.FK_IDMODULE,
FK_IDGROUPPROGRAM = _menuPro.MODULE.FK_IDGROUPPROGRAM,
ProgramName = _menuPro.MODULE.LIBELLE,
ModuleName = _menuPro.MODULE.LIBELLE,
Code = _menuPro.MODULE.CODE,
//PK_ID = _menuPro.ADMMENU.PK_ID,
//FK_IDMENU = _menuPro.ADMMENU.PK_ID,
}).Distinct();
//IEnumerable<object> query =
//(from _profiluser in profiluser
//from _menuPro in context.MENUSDUPROFIL
//select new
//{
// FK_CODEFONCTION = _profiluser.PROFIL.FONCTION.PK_ID ,
// FK_IDMODULE = _menuPro.ADMMENU.MODULE1.PK_ID,
// FK_IDGROUPPROGRAM = _menuPro.ADMMENU.MODULE1.GROUPPROGRAM.PK_ID,
// ProgramName = _menuPro.ADMMENU.MODULE1.LIBELLE,
// ModuleName = _menuPro.ADMMENU.MODULE1.LIBELLE,
// Code = _menuPro.ADMMENU.MODULE1.CODE,
// //PK_ID = _menuPro.ADMMENU.PK_ID,
// //FK_IDMENU = _menuPro.ADMMENU.PK_ID,
//}).Distinct();
return(Galatee.Tools.Utility.ListToDataTable(query.Distinct()));
}
}
catch (Exception ex)
{
throw ex;
}
}