public MemoryStream Load_Data(MemoryStream xml) { Dictionary<Object, Object> param = null; MemoryStream mresult = null; bool demo = false; OperationContext.Current.OperationCompleted += new EventHandler(delegate(object sender, EventArgs e) { if (mresult != null) mresult.Dispose(); }); try { param = Serializer.READC<Dictionary<Object, Object>>(xml); demo = ((param.Keys.Any(x => x.Equals("DEMO"))) && (param["DEMO"] != null)) ? Convert.ToBoolean(param["DEMO"]) : false; using (var CONTEXT = new dbAbisEntities((!demo) ? CS : CS_DEMO)) { switch (param["commandName"].ToString()) { case "item": List<ITEMS> listItem = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<ITEMS>("ITEMSgetDataByIdCommande", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<ITEMS>>(listItem); break; case "itemdetail": DataTable listItemDetail = CONTEXT.EXECUTE_DATATABLE_STORED_PROCEDURE("ITEMS_DETAILget", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<DataTable>(listItemDetail); break; case "valeur": break; case "REPONSES": DataTable listReponse = CONTEXT.EXECUTE_DATATABLE_STORED_PROCEDURE("REPONSESget", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<DataTable>(listReponse); break; case "REPONSES_HISTORIQUE": List<REPONSES_HISTORIQUE> lReponseHistorique = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<REPONSES_HISTORIQUE>("REPONSES_HISTORIQUEget", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<REPONSES_HISTORIQUE>>(lReponseHistorique); break; case "SEANCE_INSCRIPTION": List<SEANCES_INSCRIPTIONS> lSEANCES_INSCRIPTIONS = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<SEANCES_INSCRIPTIONS>("SEANCES_INSCRIPTIONSget", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<SEANCES_INSCRIPTIONS>>(lSEANCES_INSCRIPTIONS); break; } } return mresult; } catch (Exception ex) { File.AppendAllText(@"C:\Users\Public\s.txt", ex.ToString()); throw new ApplicationException(String.Empty, ex); } }
public MemoryStream GET_PRESTATIONS(MemoryStream xml) { Dictionary<object, Object> param = null; MemoryStream mresult = null; bool demo = false; List<PRESTATIONS> result = null; OperationContext.Current.OperationCompleted += new EventHandler(delegate(object sender, EventArgs args) { if (mresult != null) mresult.Dispose(); }); try { param = Serializer.READC<Dictionary<object, object>>(xml); demo = ((param.Keys.Any(x => x.Equals("DEMO"))) && (param["DEMO"] != null)) ? Convert.ToBoolean(param["DEMO"]) : false; using (var CONTEXT = new dbAbisEntities((!demo) ? CS : CS_DEMO)) { result = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<PRESTATIONS>("PRESTATIONSget", param, new List<string> { "DEMO" }); } mresult = Serializer.WRITEC<List<PRESTATIONS>>(result); return mresult; } catch (Exception ex) { throw new ApplicationException(String.Empty, ex); } }
private void GET_PRESTATIONS_UNITE_SPEC(Dictionary<object, object> param, bool demo, out IEnumerable<object> res) { try { using (var CONTEXT = new dbAbisEntities((!demo) ? CS : CS_DEMO)) { res = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<PRESTATIONS_UNITE>("PRESTATIONS_UNITEget", param).Cast<object>(); } } catch (Exception ex) { throw new ApplicationException(String.Empty, ex); } }
public MemoryStream commande_loader(MemoryStream xml) { Dictionary<Object, Object> param = null; MemoryStream mresult = null; bool demo = false; List<COMMANDES_ESSAIS> result = null; try { OperationContext.Current.OperationCompleted += new EventHandler(delegate(object sender, EventArgs e) { if (mresult != null) mresult.Dispose(); }); param = Serializer.READC<Dictionary<Object, Object>>(xml); demo = ((param.Keys.Any(x => x.Equals("DEMO"))) && (param["DEMO"] != null)) ? Convert.ToBoolean(param["DEMO"]) : false; string cn = param["commandName"].ToString(); using (var CONTEXT = new dbAbisEntities((!demo) ? CS : CS_DEMO)) { switch (param["commandName"].ToString()) { case "Traduction": /*List<PROJETS_LANGUES_TRADUCTION> listTraduction = EXECUTE_ENTITY_STORED_PROCEDURE<PROJETS_LANGUES_TRADUCTION>("PROJETS_LANGUES_TRADUCTIONgetByIdCommande", param); mresult = Serializer.WRITEC<List<PROJETS_LANGUES_TRADUCTION>>( listTraduction);*/ break; case "SpeakIn": bool b = Convert.ToBoolean(CONTEXT.EXECUTE_INT_STORED_PROCEDURE("LANGUESspeakIn", param, new List<string> { "DEMO", "commandName" })); mresult = Serializer.WRITES<bool>(b); break; case "Langue": List<LANGUE> listlANGUE = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<LANGUE>("LANGUESgetByIdPays", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<LANGUE>>(listlANGUE); break; case "CoefProjet": DataTable resultCoefCout = CONTEXT.EXECUTE_DATATABLE_STORED_PROCEDURE("PROJETS_COUTSgetByIdCommande", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<DataTable>(resultCoefCout); break; case "CoefClient": DataTable resultCoefClient = CONTEXT.EXECUTE_DATATABLE_STORED_PROCEDURE("getCoefClient", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<DataTable>(resultCoefClient); break; case "protocole": DataTable resultProtocole = CONTEXT.EXECUTE_DATATABLE_STORED_PROCEDURE("FICHIER_DEVISgetByIdCommande", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<DataTable>(resultProtocole); break; case "filtre": DataTable resultFiltre = CONTEXT.EXECUTE_DATATABLE_STORED_PROCEDURE("COMMANDES_ESSAIS_RAYONSgetByIdCommande", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<DataTable>(resultFiltre); break; case "produit": List<PRODUITS> listProduit = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<PRODUITS>("PRODUITSgetByIdCommande", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<PRODUITS>>(listProduit); break; case "repartition": List<PROJETS_SITES_REPARTITION> listRepartition = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<PROJETS_SITES_REPARTITION>("PROJETS_SITES_REPARTITIONgetByIdCommande", param, new List<string> { "DEMO", "commandName" }); foreach (var v in listRepartition) { CONTEXT.AttachToThis(v); v.SITE_NOMReference.Load(); } mresult = Serializer.WRITEC<List<PROJETS_SITES_REPARTITION>>(listRepartition); break; case "age": List<PROJETS_AGE> listAge = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<PROJETS_AGE>("PROJETS_AGEget", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<PROJETS_AGE>>(listAge); break; case "sexe": List<PROJETS_SEXE> listSexe = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<PROJETS_SEXE>("PROJETS_SEXEget", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<PROJETS_SEXE>>(listSexe); break; case "destinataire": List<CLIENTS_CONTACTS> listDest = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<CLIENTS_CONTACTS>("PROJETS_DESTINATAIRESget", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<CLIENTS_CONTACTS>>(listDest); break; case "liste": result = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<COMMANDES_ESSAIS>("COMMANDES_ESSAIS_GetByIdContact", param, new List<string> { "DEMO", "commandName" }); mresult = Serializer.WRITEC<List<COMMANDES_ESSAIS>>(result); break; case "commande": result = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<COMMANDES_ESSAIS>("COMMANDES_ESSAIS_GetByIdCommande", param, new List<string> { "DEMO", "commandName" }); if (result.Count() != 0) { COMMANDES_ESSAIS commande = result.First(); //CONTEXT.AttachToThis(commande); //commande.PROJETSReference.Load(); mresult = Serializer.WRITEC<COMMANDES_ESSAIS>(commande); } break; } } return mresult; } catch (Exception ex) { throw new ApplicationException(String.Empty, ex); } }
public MemoryStream GetDataComboFiltre(MemoryStream xml) { Dictionary<Object, Object> param = null; MemoryStream mresult = null; bool demo = false; OperationContext.Current.OperationCompleted += new EventHandler(delegate(object sender, EventArgs e) { if (mresult != null) mresult.Dispose(); }); try { param = Serializer.READC<Dictionary<Object, Object>>(xml); demo = ((param.Keys.Any(x => x.Equals("DEMO"))) && (param["DEMO"] != null)) ? Convert.ToBoolean(param["DEMO"]) : false; using (var CONTEXT = new dbAbisEntities((!demo) ? CS : CS_DEMO)) { switch (Convert.ToInt32(param["niveau"])) { case 0: List<RAYON0> listRay0 = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<RAYON0>("RAYON0get", param, (new string[] { "niveau", "DEMO" }).ToList()); mresult = Serializer.WRITEC<List<RAYON0>>(listRay0); break; case 1: List<RAYON1> listRay1 = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<RAYON1>("RAYON1get", param, (new string[] { "niveau", "DEMO" }).ToList()); mresult = Serializer.WRITEC<List<RAYON1>>(listRay1); break; case 2: List<RAYON2> listRay2 = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<RAYON2>("RAYON2get", param, (new string[] { "niveau", "DEMO" }).ToList()); mresult = Serializer.WRITEC<List<RAYON2>>(listRay2); break; case 3: List<RAYON3> listRay3 = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<RAYON3>("RAYON3get", param, (new string[] { "niveau", "DEMO" }).ToList()); mresult = Serializer.WRITEC<List<RAYON3>>(listRay3); break; case 4: List<RAYON3_REPONSES> listRay3Rep = CONTEXT.EXECUTE_ENTITY_STORED_PROCEDURE<RAYON3_REPONSES>("RAYON3_REPONSESget", param, (new string[] { "niveau", "DEMO" }).ToList()); mresult = Serializer.WRITEC<List<RAYON3_REPONSES>>(listRay3Rep); break; default: break; } } return mresult; } catch (Exception ex) { throw new ApplicationException(String.Empty, ex); } }