Beispiel #1
0
 public List <Customer> GetAllCustomers()
 {
     using (AHDBContext myEntities = new AHDBContext())
     {
         return(myEntities.Customers.ToList());
     }
 }
Beispiel #2
0
            public void CreateNewRepair(string description,
                                        string purchaseOrder, string quoteNumber, Nullable <DateTime> dueDate, int customerID)
            {
                //Convert incomming due date to utc and store it.
                if (dueDate != null)
                {
                    dueDate = DateTime.SpecifyKind((DateTime)dueDate, DateTimeKind.Local);
                }
                else
                {
                    dueDate = DateTime.Now.ToUniversalTime();
                }

                Repair repair = new Repair();

                repair.Description   = description;
                repair.PurchaseOrder = purchaseOrder;
                repair.QuoteNumber   = quoteNumber;
                repair.Completed     = false;
                repair.DueDate       = dueDate.Value.ToUniversalTime();
                repair.CustomerID    = customerID;

                using (AHDBContext myContext = new AHDBContext())
                {
                    myContext.spInsertRepair(repair.Description, repair.PurchaseOrder, repair.QuoteNumber, repair.DueDate, repair.CustomerID);
                    myContext.SaveChanges();
                }
            }
Beispiel #3
0
 public void CreateNewNote(string noteText, int repairID)
 {
     using (AHDBContext myContext = new AHDBContext())
     {
         myContext.spInsertNote(noteText, repairID);
     }
 }
Beispiel #4
0
 public void DeleteRepair(int repairID)
 {
     using (AHDBContext myContext = new AHDBContext())
     {
         myContext.spDeleteRepair(repairID);
     }
 }
Beispiel #5
0
 public void AssignVendorToRepair(int repairID, int vendorID)
 {
     using (AHDBContext myContext = new AHDBContext())
     {
         myContext.spInsertVendorRepair(repairID, vendorID);
         myContext.SaveChanges();
     }
 }
Beispiel #6
0
 public void CreateNewVendor(string description, string companyName)
 {
     using (AHDBContext myContext = new AHDBContext())
     {
         myContext.spInsertVendor(description, companyName);
         myContext.SaveChanges();
     }
 }
Beispiel #7
0
            public void UpdateRepair(int repairID, string description, string purchaseOrder, string quoteNumber,
                                     Nullable <bool> completed, DateTime?dateCompleted, DateTime?dueDate)
            {
                if (completed == true && (dateCompleted == null))
                {
                    dateCompleted = DateTime.UtcNow;
                }

                using (AHDBContext myContext = new AHDBContext())
                {
                    myContext.spUpdateRepair(repairID, description, purchaseOrder, quoteNumber, completed,
                                             dateCompleted, dueDate);
                }
            }
Beispiel #8
0
            public List <VendorDTO> GetVendorList()
            {
                List <VendorDTO> result = new List <VendorDTO>();

                using (AHDBContext myContext = new AHDBContext())
                {
                    result = (from vendor in myContext.Vendors
                              select new VendorDTO()
                    {
                        ID = vendor.ID,
                        CompanyName = vendor.CompanyName
                    }).ToList();
                }
                return(result);
            }
Beispiel #9
0
            public List <NoteDTO> GetNotesByRepair(int repairID)
            {
                List <NoteDTO> result = new List <NoteDTO>();

                using (AHDBContext myContext = new AHDBContext())
                {
                    result = (from note in myContext.Notes
                              where note.RepairID == repairID
                              select new NoteDTO()
                    {
                        ID = note.ID,
                        NoteText = note.NoteText,
                        DateCreatedAsUtcTime = note.DateCreatedAsUtcTime,
                        RepairID = note.RepairID
                    }).ToList();
                }
                return(result);
            }
Beispiel #10
0
            public List <RepairDTO> GetAllNotCompletedRepairsAndTheirVendors()
            {
                List <RepairDTO> result = new List <RepairDTO>();

                using (AHDBContext myContext = new AHDBContext())
                {
                    result = (from repair in myContext.Repairs
                              where repair.Completed == false
                              select new RepairDTO
                    {
                        ID = repair.ID,
                        Description = repair.Description,
                        PurchaseOrder = repair.PurchaseOrder,
                        QuoteNumber = repair.QuoteNumber,
                        Completed = repair.Completed,
                        DateCreatedAsUtcTime = repair.DateCreatedAsUtcTime,
                        DateCompleted = repair.DateCompleted,
                        DueDate = repair.DueDate,
                        CustomerID = repair.CustomerID,
                        Customer = new CustomerDTO
                        {
                            ID = repair.Customer.ID,
                            CompanyName = repair.Customer.CompanyName,
                        },
                        VendorRepairs = (from vendorRepair in repair.VendorRepairs
                                         where vendorRepair.Completed != true
                                         select new VendorRepairDTO
                        {
                            RepairID = vendorRepair.RepairID,
                            VendorID = vendorRepair.VendorID,
                            Completed = vendorRepair.Completed,
                            DateCreatedAsUtcTime = vendorRepair.DateCreatedAsUtcTime,
                            Vendor = new VendorDTO
                            {
                                ID = vendorRepair.Vendor.ID,
                                CompanyName = vendorRepair.Vendor.CompanyName,
                                DateCreatedAsUtcTime = vendorRepair.Vendor.DateCreatedAsUtcTime
                            }
                        }).ToList(),
                    }).ToList();
                }
                return(result);
            }
Beispiel #11
0
 public void CreateNewCustomer(string description, string companyName)
 {
     using (AHDBContext myContext = new AHDBContext())
     {
     }
 }