public static void Delete(int Id) { try { CompteResult myCR = null; using (var context = new CompteResultatEntities()) { var elements = context.CompteResults.Where(c => c.Id == Id); if (elements.Any()) { myCR = elements.First(); context.CompteResults.Attach(myCR); context.CompteResults.Remove(myCR); context.SaveChanges(); } } } catch (Exception ex) { log.Error(ex.Message); throw ex; } }
public static void Delete(CompteResult cr) { try { using (var context = new CompteResultatEntities()) { context.CompteResults.Attach(cr); context.CompteResults.Remove(cr); context.SaveChanges(); } } catch (Exception ex) { log.Error(ex.Message); throw ex; } }
//public static bool ComptesResultatExists(string crName, int parentCompId) //{ // //int crId = C.cINVALIDID; // bool exists = false; // try // { // using (var context = new CompteResultatEntities()) // { // var elements = context.CompteResults.Where(c => (c.Name == crName && c.ParentCompanyId==parentCompId) ); // if (elements.Any()) // { // //crId = elements.First().Id; // exists = true; // } // } // return exists; // //return crId; // } // catch (Exception ex) // { // log.Error(ex.Message); // throw ex; // } //} public static int Insert(CompteResult cr) { try { using (var context = new CompteResultatEntities()) { context.CompteResults.Add(cr); context.SaveChanges(); return(cr.Id); } } catch (Exception ex) { log.Error("CompteResultatExt - Insert ::" + ex.Message); throw ex; } }
public static void Update(CompteResult newCR) { try { if (newCR == null) { throw new Exception("The 'CompteResult' entity does not contain any data!"); } using (var context = new CompteResultatEntities()) { //CompteResult oldCR = context.CompteResults.Where(c => c.Id == newCR.Id).First(); var elements = context.CompteResults.Where(c => c.Id == newCR.Id); if (elements.Any()) { CompteResult oldCR = elements.First(); oldCR.Name = newCR.Name; oldCR.AssurIds = newCR.AssurIds; oldCR.CompanyIds = newCR.CompanyIds; oldCR.SubsidIds = newCR.SubsidIds; oldCR.ContractIds = newCR.ContractIds; oldCR.ReportLevelId = newCR.ReportLevelId; oldCR.CollegeId = newCR.CollegeId; oldCR.UserName = newCR.UserName; oldCR.CreationDate = newCR.CreationDate; oldCR.IsActive = newCR.IsActive; oldCR.IsAutoGenerated = newCR.IsAutoGenerated; oldCR.TaxActif = newCR.TaxActif; oldCR.TaxDefault = newCR.TaxDefault; oldCR.TaxPerif = newCR.TaxPerif; oldCR.ReportType = newCR.ReportType; context.SaveChanges(); } } } catch (Exception ex) { log.Error("CompteResultatExt - Update :: " + ex.Message); throw ex; } }
public static CompteResult GetComptesResultatForId(int id) { CompteResult myCR = null; try { using (var context = new CompteResultatEntities()) { var elements = context.CompteResults.Where(c => c.Id == id); if (elements.Any()) { myCR = elements.First(); } } return(myCR); } catch (Exception ex) { log.Error(ex.Message); throw ex; } }