public IHttpActionResult PostCustomerNotes(CustomerNotesDTO oDto) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var result = subsiteofficeconfigService.SaveCustomerNoteInfo(oDto); if (result == Guid.Empty) { return(NotFound()); } return(Ok(result)); }
/// <summary> /// This method is used to Save and Update the Customer Note Infomration Dtails /// </summary> /// <param name="dto"></param> /// <returns></returns> public Guid SaveCustomerNoteInfo(CustomerNotesDTO dto) { int entityState = 0; CustomerNote model = new CustomerNote(); if (dto != null) { Guid refId; model.Id = Guid.NewGuid(); entityState = (int)System.Data.Entity.EntityState.Added; bool IsRefId = Guid.TryParse(dto.RefId, out refId); if (!IsRefId) { return(Guid.Empty); } model.RefId = refId; model.Note = dto.Note; model.LastUpdatedBy = dto.UserId ?? Guid.Empty; model.LastUpdatedDate = System.DateTime.Now; if (entityState == (int)System.Data.Entity.EntityState.Added) { model.CreatedBy = dto.UserId ?? Guid.Empty; model.CreatedDate = System.DateTime.Now; db.CustomerNotes.Add(model); } else { db.Entry(model).State = System.Data.Entity.EntityState.Modified; } } try { db.SaveChanges(); db.Dispose(); return(model.Id); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/SaveCustomerNoteInfo", model.RefId); return(Guid.Empty); throw; } }
/// <summary> /// This Method is used to Get the Customer Notes details by ID /// </summary> /// <param name="userid"></param> /// <returns></returns> public IQueryable <CustomerNotesDTO> GetCustomerNotesById(Guid userid) { try { db = new DatabaseEntities(); var data = (from cu in db.CustomerNotes where cu.RefId == userid select cu); List <CustomerNotesDTO> lstsbcustnotes = new List <CustomerNotesDTO>(); foreach (var itm in data) { CustomerNotesDTO customernotesDTO = new CustomerNotesDTO(); customernotesDTO.Note = itm.Note; customernotesDTO.RefName = db.emp_CustomerInformation.Where(o => o.Id == itm.RefId).Select(a => a.CompanyName).FirstOrDefault(); customernotesDTO.CreatedDate = itm.CreatedDate.ToString("MM/dd/yyyy hh:mm tt"); lstsbcustnotes.Add(customernotesDTO); } return(lstsbcustnotes.OrderByDescending(a => a.CreatedDate).AsQueryable()); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/GetCustomerNotesById", Guid.Empty); return(null); } }