Beispiel #1
0
        public DataTable SaveDataOnPmHeader(PMHeaderEntity item)
        {
            using (FacilitiesEntities db = new FacilitiesEntities())
            {
                try
                {
                    ClientPMHeader CH = new ClientPMHeader();
                    #region ADD/Update the PM header entries
                    if (item.ClientPMHeaderId != Guid.Empty)
                    {
                        CH = db.ClientPMHeaders.Where(a => a.ClientPMHeaderId == item.ClientPMHeaderId).FirstOrDefault();
                    }
                    else
                    {
                        CH.ClientPMHeaderId = Guid.NewGuid();
                    }

                    CH.Client             = item.Client;
                    CH.Customer           = item.Customer;
                    CH.ProblemClass       = item.ProblemClass;
                    CH.ProblemCode        = item.ProblemCode;
                    CH.RequestPriority    = item.RequestPriority;
                    CH.ServiceRequestType = item.ServiceRequestType;
                    CH.CustomerReference  = item.CustomerReference;
                    CH.IssueDescription   = item.IssueDescription;
                    CH.Frequency          = item.Frequency;
                    CH.BeginDate          = item.BeginDate;
                    CH.EndDate            = item.EndDate;
                    CH.ArriveDateAndTime  = item.ArriveDateAndTime;
                    CH.FinishDateAndTime  = item.FinishDateAndTime;
                    CH.WOInAdvance        = item.WOInAdvance;
                    CH.CreatedByUser      = item.UserId;
                    CH.ActiveFlag         = "N";

                    if (item.ClientPMHeaderId == Guid.Empty)
                    {
                        db.ClientPMHeaders.Add(CH);
                    }

                    db.SaveChanges();
                    #endregion


                    #region CALCULATE and insert the schedular entries and return
                    DataTable dt   = GetWOConfirmationDate(CH.ClientPMHeaderId);
                    DataView  view = dt.DefaultView;
                    view.Sort = "WorkOrderCreationDate ASC";
                    DataTable sortedDate = view.ToTable();
                    #endregion
                    return(dt);
                }
                catch (Exception ex)
                {
                    throw (ex);
                }
            }
        }
 public DataTable SaveDataOnPmHeader(PMHeaderEntity item)
 {
     return(repository.SaveDataOnPmHeader(item));
 }