public void Delete(ag_upsideo_clientemailing emailing) { try { using (Data.Model.UpsilabEntities context = new UpsilabEntities()) { var _rec = context.ag_upsideo_clientemailing.FirstOrDefault(x => x.idemailingclient == emailing.idemailingclient); _rec.deleted = "o"; context.SaveChanges(); } } catch (Exception e) { Log.Log.AppendException(e); throw new Exception("SavingError"); } }
public int Add(int idemailing, Guid idcgp, string a, string cc, string objet, string msg, Dictionary<string,string> files, bool isdraft) { using (Data.Model.UpsilabEntities context = new UpsilabEntities()) { context.Connection.Open(); using (var dbContextTransaction = context.Connection.BeginTransaction()) { ag_upsideo_clientemailing _emailing = null; try { if (idemailing <= 0) { _emailing = new ag_upsideo_clientemailing { idcgp = idcgp, a = a, cc = cc, datecreation = DateTime.Now, draft = isdraft, objet = objet, message = msg }; context.ag_upsideo_clientemailing.AddObject(_emailing); context.SaveChanges(); // // // if (files != null && files.Count() > 0) { foreach (var file in files) { var _attached = new ag_upsideo_clientemailing_attachedfile { idemailingclient = _emailing.idemailingclient, location = file.Value, name = file.Key }; context.ag_upsideo_clientemailing_attachedfile.AddObject(_attached); context.SaveChanges(); } } } else { _emailing = context.ag_upsideo_clientemailing.FirstOrDefault(x => x.idemailingclient == idemailing); _emailing.a = a; _emailing.cc = cc; _emailing.draft = isdraft; _emailing.objet = objet; _emailing.message = msg; context.SaveChanges(); if (files != null && files.Count() > 0) { var tmpfiles = files.Select(x => x).ToDictionary(x => x.Key, x => x.Value); foreach (var dbattached in _emailing.ag_upsideo_clientemailing_attachedfile) { if (!files.ContainsKey(dbattached.name.Trim())) { tmpfiles.Remove(dbattached.name.Trim()); dbattached.deleted = "o"; context.SaveChanges(); } } // // // if (tmpfiles.Count > 0) { foreach (var file in tmpfiles) { var _attached = new ag_upsideo_clientemailing_attachedfile { idemailingclient = _emailing.idemailingclient, location = file.Value, name = file.Key }; context.ag_upsideo_clientemailing_attachedfile.AddObject(_attached); context.SaveChanges(); } } } } // // // dbContextTransaction.Commit(); return _emailing.idemailingclient; } catch (Exception e) { dbContextTransaction.Rollback(); Log.Log.AppendException(e); throw new Exception("SavingError"); } } } }
public void Update(ag_upsideo_clientemailing emailing) { try { using (Data.Model.UpsilabEntities context = new UpsilabEntities()) { var _rec = context.ag_upsideo_clientemailing.FirstOrDefault(x => x.idemailingclient == emailing.idemailingclient); _rec.cc = emailing.cc; _rec.a = emailing.a; _rec.objet = emailing.objet; _rec.message = emailing.message; context.SaveChanges(); } } catch (Exception e) { Log.Log.AppendException(e); throw new Exception("SavingError"); } }