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; } }
public static CRMRendezVous UpdateRDV(CRMRendezVous rdv) { using (UpsilabEntities db = new UpsilabEntities()) { var rdvtoupdate = db.CRMRendezVous.Where(f => f.idCRMRendezVous == rdv.idCRMRendezVous).FirstOrDefault(); rdvtoupdate.Date = rdv.Date; rdvtoupdate.DateAlerte = rdv.DateAlerte; rdvtoupdate.Detail = rdv.Detail; rdvtoupdate.Heure = rdv.Heure; rdvtoupdate.HeureAlerte = rdv.HeureAlerte; rdvtoupdate.Lieu = rdv.Lieu; rdvtoupdate.Objet = rdv.Objet; db.SaveChanges(); return rdvtoupdate; } }
public ActionResult InsertRDV(CRMRendezVous _crmRDV) { try { // Pas besoin d'enregistrer la date et l'heure d'envoi de l'alerte si le checkbox RecevoirAlerte n'est pas coché if (Request.Params["RecevoirAlerte"] == null) { _crmRDV.DateAlerte = null; _crmRDV.HeureAlerte = null; } if (Request.Params["Lieu"] != null) { if (Request.Params["Lieu"] == "exterieur") { _crmRDV.Lieu = Request.Params["LieuRDV"]; } } CRMRendezVous newRDV = CRMRendezVousBL.InsertRDV(_crmRDV); Events newEvent = new Events() { idCRMRendezVous = newRDV.idCRMRendezVous, text = newRDV.Objet, idCustomer = newRDV.idClient, idUser = SessionManager.GetUserSession().idUser }; #region Events DateTime start_date = DateTime.Now; if (newRDV.Date.HasValue) { start_date = newRDV.Date.Value; if (newRDV.Heure.HasValue) { start_date = newRDV.Date.Value.AddMinutes(this.ConvertToHour(newRDV.Heure.Value.ToString())); } } newEvent.start_date = start_date; newEvent.end_date = start_date; EventsBL.InsertEvents(newEvent); #endregion ViewBag.Style = "style=color:green"; ViewBag.Message = LanguageData.GetContent("appel_tel_bien_enregistee"); } catch (Exception ex) { ViewBag.Style = "style=color:red"; ViewBag.Message = LanguageData.GetContent("exception_titre") + ": " + ex.Message; } Guid gCustomerId = Guid.Empty; SessionManager.Get<Guid>(AgregAgendaClientIdSessionKey, out gCustomerId); return RedirectToAction("Index", new { id = gCustomerId }); }
public PartialViewResult LoadPopupSaisieRDV() { try { Guid gCustomerId = Guid.Empty; SessionManager.Get<Guid>(AgregAgendaClientIdSessionKey, out gCustomerId); //CustomerProspect cp = CustomerProspectBL.GetCustomerProspectById(gCustomerId); UpsilabEntities db = new UpsilabEntities(); CustomerProspect cp = db.CustomerProspect.Where(c => c.idCustomer == gCustomerId && c.isDeleted == false).FirstOrDefault(); if (cp == null) { return PartialView("RetourPartial", LanguageData.GetContent("error_client_not_exists")); } else { CRMRendezVous rdv = new CRMRendezVous() { idClient = gCustomerId }; Tuple<CRMRendezVous, CustomerProspect> tuple = new Tuple<CRMRendezVous, CustomerProspect>(rdv, cp); return PartialView("PopupSaisieRendezVousPartial", tuple); } } catch (Exception ex) { return PartialView("RetourPartial", ex.Message); } }
public PartialViewResult LoadPopupSaisieRDV(string id) { try { Guid gCustomerId = Guid.Empty; if (Guid.TryParse(id, out gCustomerId)) { gCustomerId = new Guid(id); } CustomerProspect cp = CustomerProspectBL.GetCustomerProspectById(gCustomerId); if (cp == null) { return PartialView("RetourPartial", LanguageData.GetContent("error_client_not_exists")); } else { CRMRendezVous rdv = new CRMRendezVous() { idClient = gCustomerId }; Tuple<CRMRendezVous, CustomerProspect> tuple = new Tuple<CRMRendezVous, CustomerProspect>(rdv, cp); return PartialView("PopupSaisieRendezVousPartial", tuple); } } catch (Exception ex) { return PartialView("RetourPartial", ex.Message); } }
public PartialViewResult LoadPopupSaisieRDV() { try { Guid gCustomerId = Guid.Empty; Guid idCGP = SessionManager.GetUserSession().idUser; CRMRendezVous rdv = new CRMRendezVous() { idClient = gCustomerId }; return PartialView("PopupAjoutRendezVousPartial", rdv); } catch (Exception ex) { return PartialView("RetourPartial", ex.Message); } }
public ActionResult InsertRDV(CRMRendezVous _crmRDV) { try { // Pas besoin d'enregistrer la date et l'heure d'envoi de l'alerte si le checkbox RecevoirAlerte n'est pas coché if (Request.Params["RecevoirAlerte"] == null) { _crmRDV.DateAlerte = null; _crmRDV.HeureAlerte = null; } if (Request.Params["Lieu"] != null) { if (Request.Params["Lieu"] == "exterieur") { _crmRDV.Lieu = Request.Params["LieuRDV"]; } } var isupdate = (_crmRDV.idCRMRendezVous > 0); CRMRendezVous _RDV = isupdate ? CRMRendezVousBL.UpdateRDV(_crmRDV) : CRMRendezVousBL.InsertRDV(_crmRDV); Events _event = isupdate ? EventsBL.GetEventbyIdRdv(_crmRDV.idCRMRendezVous) : new Events { idCRMRendezVous = _RDV.idCRMRendezVous, idCustomer = _RDV.idClient, idUser = SessionManager.GetUserSession().idUser }; #region Events DateTime start_date = DateTime.Now; _event.start_date = start_date; _event.end_date = start_date; _event.text = _RDV.Objet; if (_RDV.Date.HasValue) { _event.start_date = _RDV.Date.Value; if (_RDV.Heure.HasValue) { _event.end_date = _RDV.Date.Value.AddMinutes(this.ConvertToHour(_RDV.Heure.Value.ToString())); } } if (isupdate) { EventsBL.UpdateEvents(_event); } else EventsBL.InsertEvents(_event); #endregion ViewBag.Style = "style=color:green"; ViewBag.Message = LanguageData.GetContent("appel_tel_bien_enregistee"); } catch (Exception ex) { ViewBag.Style = "style=color:red"; ViewBag.Message = LanguageData.GetContent("exception_titre") + ": " + ex.Message; } return RedirectToAction("Index", new { id = this.idCustomer }); }