public static ag_upsideo_cptrelsupports_histo UpdateCpteSupportHistory(ag_upsideo_cptrelsupports_histo histo)
{
try
{
using (Data.Model.UpsilabEntities context = new UpsilabEntities())
{
if (histo.Id > 0)
{
var updatehisto = context.ag_upsideo_cptrelsupports_histo.FirstOrDefault(x => x.Id == histo.Id);
updatehisto.datemaj = DateTime.Now;
updatehisto.pru = histo.pru;
updatehisto.qte = histo.qte;
updatehisto.vl = histo.vl;
context.SaveChanges();
return updatehisto;
}
else
{
context.ag_upsideo_cptrelsupports_histo.AddObject(histo);
context.SaveChanges();
return histo;
}
}
}
catch (Exception e)
{
Log.Log.AppendException(e);
throw new Exception("SavingError");
}
}
public static AgregFournisseurModel AddFournisseurRetour(ag_upsideo_fournisseur frn, ag_upsideo_fournisseur_code frncode)
{
using (Data.Model.UpsilabEntities context = new UpsilabEntities())
{
context.Connection.Open();
using (var dbContextTransaction = context.Connection.BeginTransaction())
{
try
{
frn.deleted = "n";
context.ag_upsideo_fournisseur.AddObject(frn);
context.SaveChanges();
//
//
//
frncode.idfrontfournisseur = frn.idfrontfournisseur;
context.ag_upsideo_fournisseur_code.AddObject(frncode);
context.SaveChanges();
//
//
//
dbContextTransaction.Commit();
}
catch (Exception e)
{
dbContextTransaction.Rollback();
Log.Log.AppendException(e);
throw new Exception("SavingError");
}
}
}
return AgregFournisseurModel.Ag_upsideo_fournisseurToFournisseurModel(frn, frncode);
}
public static void Update(
int idSubscription,
bool isSingle,
DateTime? datePaiement,
string periodicite,
decimal? montant,
DateTime? datePremierEcheance,
decimal? premierVersement,
DateTime? datePremierVersement,
int? idMode
)
{
using (UpsilabEntities context = new UpsilabEntities())
{
var record = context.PaymentLog.FirstOrDefault(x => x.idSubscription == idSubscription);
if (record == null)
{
//ADD
record = new PaymentLog
{
idSubscription = idSubscription,
DatePayment = datePaiement,
DateFirstPaymentDeadline = datePremierEcheance,
DateFirstDeposit = datePremierVersement,
TotalAmount = montant,
AmountFirstDeposit = premierVersement,
Periodicity = periodicite,
IsSinglePayment = isSingle,
IdPaymentMode = idMode,
ReturnCode = "",
};
context.PaymentLog.AddObject(record);
context.SaveChanges();
return;
}
//Update
record.IsSinglePayment = isSingle;
record.DatePayment = datePaiement;
record.Periodicity = periodicite;
record.TotalAmount = montant;
record.DateFirstPaymentDeadline = datePremierEcheance;
record.AmountFirstDeposit = premierVersement;
record.DateFirstDeposit = datePremierVersement;
record.IdPaymentMode = idMode;
context.SaveChanges();
}
}
public static Upsilab.Data.Model.User CreateUser(Upsilab.Data.Model.User user, String pasword)
{
user.UserPassword = UserBL.Encrypt(pasword);
using (UpsilabEntities context = new UpsilabEntities())
{
var _user = new Data.Model.User();
_user.idUser = user.idUser;
_user.idUserProfile = user.idUserProfile;
_user.UserLogin = user.UserLogin;
_user.UserPassword = user.UserPassword;
_user.UserName = user.UserName;
_user.UserFirstName = user.UserFirstName;
_user.UserMobilePhone = user.UserMobilePhone;
_user.UserEmail = user.UserEmail;
_user.IsActive = user.IsActive;
_user.IsDeleted = user.IsDeleted;
_user.DateCreated = DateTime.Now;
_user.IdLicenseReport = user.IdLicenseReport;
_user.IdLicenseLab = user.IdLicenseLab;
//context.User.AddObject(user);
context.User.AddObject(_user);
context.SaveChanges();
}
return user;
}
/// <summary>
/// Log ONLY sent Emails, doesn't take care of any errors !!!
/// </summary>
/// <param name="IDSender">NULLABLE especially for System </param>
/// <param name="EmailSender"></param>
/// <param name="IDRecipient">NULLABLE</param>
/// <param name="EmailRecipient"></param>
/// <param name="RecipientType"></param>
/// <param name="EmailType"></param>
/// <param name="IDRecipientCC">NULLABLE</param>
/// <param name="EmailRecipientCC">NULLABLE</param>
public static void Log(Guid? IDSender, string EmailSender, Guid? IDRecipient, string EmailRecipient, TypeDestinataire RecipientType, string EmailType, Guid? IDRecipientCC = null, string EmailRecipientCC = null)
{
try
{
using (UpsilabEntities context = new UpsilabEntities())
{
EmailLog pEmailLog = new EmailLog();
if (IDSender != null)
pEmailLog.IDSender = IDSender.Value;
pEmailLog.EmailSender = EmailSender;
if (IDRecipient != null)
pEmailLog.IDRecipient = IDRecipient.Value;
if (IDRecipientCC != null)
pEmailLog.IDRecipientCC = IDRecipientCC.Value;
pEmailLog.EmailRecipient = EmailRecipient;
pEmailLog.EmailRecipientCC = EmailRecipientCC;
pEmailLog.RecipientType = RecipientType.ToString();
pEmailLog.EmailType = EmailType.ToString();
pEmailLog.DateCreated = DateTime.Now;
context.EmailLog.AddObject(pEmailLog);
context.SaveChanges();
}
}
catch { }
}
public ActionResult UpdateMessage(string idmessage)
{
using (UpsilabEntities context = new UpsilabEntities())
{
var result = new {Status = "OK", Message = string.Empty};
try
{
int idMessage = 0;
int.TryParse(idmessage, out idMessage);
if (idMessage > 0)
{
// set message to read
User currentUser = SessionManager.GetUserSession();
Message ms = context.Message.FirstOrDefault(m => m.idMessage == idMessage && m.idUser == currentUser.idUser);
if (ms != null)
{
ms.Read = true;
ms.DateUpdated = DateTime.Now;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Log.AppendException(ex);
result = new { Status = "KO", Message = ex.Message};
}
return Json(result,JsonRequestBehavior.AllowGet);
}
}
public static void CreateReportAlert(Guid idReport, int idAlert, String reason)
{
var existingReportAlert = ReportAlertBL.HasExistingReportAlert(idReport, idAlert);
if (existingReportAlert == null)
{
var reportAlert = new ReportAlert() { idAlert = idAlert, idReport = idReport, JustifyingReason = reason };
using (UpsilabEntities context = new UpsilabEntities())
{
context.ReportAlert.Attach(reportAlert);
context.ObjectStateManager.ChangeObjectState(reportAlert, System.Data.EntityState.Added);
context.SaveChanges();
}
}
else
{
existingReportAlert.JustifyingReason = reason;
using (UpsilabEntities context = new UpsilabEntities())
{
context.ReportAlert.Attach(existingReportAlert);
context.ObjectStateManager.ChangeObjectState(existingReportAlert, System.Data.EntityState.Modified);
context.SaveChanges();
}
}
}
//static UpsilabEntities context = new UpsilabEntities();
public static void InsertSignatureTransaction(SignatureTransaction signatureTransaction)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.SignatureTransaction.AddObject(signatureTransaction);
context.SaveChanges();
}
}
public static void Save(PaymentLog paymentLog)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.PaymentLog.AddObject(paymentLog);
context.SaveChanges();
}
}
public static void Add(CreditAddLog creditAddLog)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.CreditAddLog.AddObject(creditAddLog);
context.SaveChanges();
}
}
public static void InsertLABModel(LABModel labModel)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.LABModel.AddObject(labModel);
context.SaveChanges();
}
}
public static void Update(Data.Model.DER objDer)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.DER.Attach(objDer);
context.ObjectStateManager.ChangeObjectState(objDer, System.Data.EntityState.Modified);
context.SaveChanges();
}
}
public static ag_upsideo_compte Addcompte(ag_upsideo_compte compte)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.ag_upsideo_compte.AddObject(compte);
context.SaveChanges();
return compte;
}
}
public static void InsertEvents(Events newEvent)
{
using (UpsilabEntities db = new UpsilabEntities())
{
db.Events.Attach(newEvent);
db.ObjectStateManager.ChangeObjectState(newEvent, System.Data.EntityState.Added);
db.SaveChanges();
}
}
public static void UpdateSignatureTransaction(SignatureTransaction signatureTransaction)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.SignatureTransaction.Attach(signatureTransaction);
context.ObjectStateManager.ChangeObjectState(signatureTransaction, System.Data.EntityState.Modified);
context.SaveChanges();
}
}
public static void AddReminder(Upsilab.Data.Model.ReminderLog pReminder)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.ReminderLog.Attach(pReminder);
context.ObjectStateManager.ChangeObjectState(pReminder, System.Data.EntityState.Added);
context.SaveChanges();
}
}
public static void InsertCRMTelephone(CRMTelephone tel)
{
using (UpsilabEntities db = new UpsilabEntities())
{
db.CRMTelephone.Attach(tel);
db.ObjectStateManager.ChangeObjectState(tel, System.Data.EntityState.Added);
db.SaveChanges();
}
}
public static void Create(ConvRTO convention)
{
using (var context = new UpsilabEntities())
{
context.ConventionRTO.Attach(convention);
context.ObjectStateManager.ChangeObjectState(convention, EntityState.Added);
context.SaveChanges();
}
}
public static void Insert(MissionDocumentAppendix model)
{
using (var context = new UpsilabEntities())
{
model.DateCreated = DateTime.Now;
context.MissionDocumentAppendix.AddObject(model);
context.SaveChanges();
}
}
public static void InsertFichier(CRMFichier fic)
{
using (UpsilabEntities db = new UpsilabEntities())
{
db.CRMFichier.Attach(fic);
db.ObjectStateManager.ChangeObjectState(fic, System.Data.EntityState.Added);
db.SaveChanges();
}
}
public static void Add(CRMListeDiffusion pList)
{
using (UpsilabEntities db = new UpsilabEntities())
{
db.CRMListeDiffusion.Attach(pList);
db.ObjectStateManager.ChangeObjectState(pList, System.Data.EntityState.Added);
db.SaveChanges();
}
}
public static void UpdateLabModelName(Guid idlab,string name)
{
using (UpsilabEntities db = new UpsilabEntities())
{
var labModel = db.LABModel.Where(l => l.idLABModel == idlab).FirstOrDefault();
labModel.Name = name;
db.SaveChanges();
}
}
public static void Delete(int SignatureTransactionStatutId)
{
using (UpsilabEntities context = new UpsilabEntities())
{
var transStatut = context.SignatureTransactionStatusLog.Where(x => x.idSignatureTransactionStatus == SignatureTransactionStatutId).FirstOrDefault();
context.SignatureTransactionStatusLog.DeleteObject(transStatut);
context.SaveChanges();
}
}
public static void InsertExportLog(Upsilab.Data.Model.ExportLog _objExportLog)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.ExportLog.Attach(_objExportLog);
context.ObjectStateManager.ChangeObjectState(_objExportLog, System.Data.EntityState.Added);
context.SaveChanges();
}
}
public static ag_upsideo_referentiel AddReferentiel(ag_upsideo_referentiel referentiel)
{
using (var ctx = new UpsilabEntities())
{
ctx.ag_upsideo_referentiel.AddObject(referentiel);
ctx.SaveChanges();
return referentiel;
}
}
public static void DeleteCGP(Guid idFirmCGP)
{
using (Data.Model.UpsilabEntities context = new UpsilabEntities())
{
var cgp = context.FirmInstitution.FirstOrDefault(x => x.idFirmInstitution == idFirmCGP);
cgp.isDelete = true;
context.SaveChanges();
}
}
public static void Create(Upsilab.Data.Model.ConfidentialityAgreement conf)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.ConfidentialityAgreement.Attach(conf);
context.ObjectStateManager.ChangeObjectState(conf, System.Data.EntityState.Added);
context.SaveChanges();
}
}
public static Upsilab.Data.Model.UserAuthentication CreateUserAuthentication(Upsilab.Data.Model.UserAuthentication userAuth)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.UserAuthentication.AddObject(userAuth);
context.SaveChanges();
}
return userAuth;
}
public static Upsilab.Data.Model.UserAuthentication UpdateUserAuthentication(Upsilab.Data.Model.UserAuthentication userAuth)
{
using (UpsilabEntities context = new UpsilabEntities())
{
context.UserAuthentication.Attach(userAuth);
context.ObjectStateManager.ChangeObjectState(userAuth, System.Data.EntityState.Modified);
context.SaveChanges();
}
return userAuth;
}
public static CRMRendezVous InsertRDV(CRMRendezVous rdv)
{
using (UpsilabEntities db = new UpsilabEntities())
{
db.CRMRendezVous.Attach(rdv);
db.ObjectStateManager.ChangeObjectState(rdv, System.Data.EntityState.Added);
db.SaveChanges();
return rdv;
}
}
