Example #1
0
        public ResponseVM Create(EmployeeTypeVM employeetypeVM)
        {
            using (context)
            {
                //check if record already exists
                if (context.EmployeeTypes.Where(b => b.EmployeeTypeName.ToLower() == employeetypeVM.EmployeeTypeName.ToLower()).Any())
                {
                    return(new ResponseVM("created", false, "Employee Type", ResponseVM.ALREADY_EXIST));
                }
                using (var dbTransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        employeetypeVM.EmployeeTypeid = Guid.NewGuid();
                        //converts to book type then save to context
                        context.EmployeeTypes.Add(toModel.EmployeeType(employeetypeVM));
                        context.SaveChanges();

                        //commits changes to db
                        dbTransaction.Commit();
                        return(new ResponseVM("created", true, "Employee Type"));
                    }
                    catch (Exception ex)
                    {
                        dbTransaction.Rollback();
                        return(new ResponseVM("created", false, "Employee Type", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
                    }
                }
            }
        }
Example #2
0
        public ResponseVM Create(CategoryListVM categoryListVM)
        {
            using (context)
            {
                if (context.CategoryLists.Where(x => x.CategoryListName == categoryListVM.CategoryListName).Any())
                {
                    return(new ResponseVM("created", false, "CategoryList", ResponseVM.ALREADY_EXIST));
                }

                using (var dbTransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        categoryListVM.CategoryListid = Guid.NewGuid();
                        context.CategoryLists.Add(toModel.CategoryList(categoryListVM));
                        context.SaveChanges();

                        dbTransaction.Commit();
                        return(new ResponseVM("created", true, "CategoryList"));
                    }
                    catch (Exception ex)
                    {
                        dbTransaction.Rollback();
                        return(new ResponseVM("created", false, "CategoryList", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
                    }
                }
            }
        }
Example #3
0
        public ResponseVM Create(SeverityVM severityVM)
        {
            using (context)
            {
                if (context.Severities.Where(x => x.SeverityCode == severityVM.SeverityCode ||
                                             x.SeverityName == severityVM.SeverityName ||
                                             x.SeverityDesc == severityVM.SeverityDesc).Any())
                {
                    return(new ResponseVM("created", false, "Severity", ResponseVM.ALREADY_EXIST));
                }

                using (var dbTransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        severityVM.Severityid = Guid.NewGuid();
                        context.Severities.Add(toModel.Severity(severityVM));
                        context.SaveChanges();

                        dbTransaction.Commit();
                        return(new ResponseVM("created", true, "Severity"));
                    }
                    catch (Exception ex)
                    {
                        dbTransaction.Rollback();
                        return(new ResponseVM("created", false, "Severity", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
                    }
                }
            }
        }
        public ResponseVM Create(ITGroupVM itgroupVM)
        {
            using (context)
            {
                if (context.ITGroups.Where(x => x.ITGroupName == itgroupVM.ITGroupName).Any())
                {
                    return(new ResponseVM("created", false, "ITGroup", ResponseVM.ALREADY_EXIST));
                }
                using (var dbTransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        context.ITGroups.Add(toModel.ITGroup(itgroupVM));
                        context.SaveChanges();

                        dbTransaction.Commit();
                        return(new ResponseVM("created", true, "ITGroup"));
                    }
                    catch (Exception ex)
                    {
                        dbTransaction.Rollback();
                        return(new ResponseVM("created", false, "ITGroup", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
                    }
                }
            }
        }
        public ResponseVM Create(TicketVM ticketVM)
        {
            using (context)
            {
                using (var dbTransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        ticketVM.Ticketid = Guid.NewGuid();
                        ticketVM.TrackingStatus = "Request for approval";
                        ticketVM.IsOpen = "True";
                        ticketVM.RequestedBy = "ridz";
                        //converts to book type then save to context
                        context.Tickets.Add(toModel.Ticket(ticketVM));
                        context.SaveChanges();

                        //commits changes to db
                        dbTransaction.Commit();
                        return new ResponseVM("created", true, "Ticket");
                    }
                    catch (Exception ex)
                    {

                        dbTransaction.Rollback();
                        return new ResponseVM("created", false, "Ticket", ResponseVM.SOMETHING_WENT_WRONG, "", ex);
                    }
                }
            }
        }
        public ResponseVM Create(TicketMinorVM ticketMinorVM)
        {
            using (context)
            {
                using (var dbTransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        ticketMinorVM.TicketMinorid    = Guid.NewGuid();
                        ticketMinorVM.DateAccomplished = DateTime.Now;
                        context.TicketMinors.Add(toModel.TicketMinor(ticketMinorVM));
                        context.SaveChanges();

                        dbTransaction.Commit();
                        return(new ResponseVM("created", true, "TicketMinor"));
                    }
                    catch (Exception ex)
                    {
                        dbTransaction.Rollback();
                        return(new ResponseVM("created", false, "TicketMinor", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
                    }
                }
            }
        }
Example #7
0
        public ResponseVM Create(EmployeeEmployeeTypeVM employeeEmployeeTypeVM)
        {
            using (context)
            {
                using (var dbTransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        employeeEmployeeTypeVM.EmployeeEmployeeTypeid = Guid.NewGuid().ToString();
                        var employeeEmployeeTypeSaved = context.EmployeeEmployeeTypes.Add(toModel.EmployeeEmployeeType(employeeEmployeeTypeVM)).Entity;
                        context.SaveChanges();

                        foreach (var empID in employeeEmployeeTypeVM.EmployeeIdList)
                        {
                            var employee = context.Employees.Find(empID);
                            if (employee == null)
                            {
                                return(new ResponseVM("create", false, "EmployeeEmployeeType", "Employee does not exists"));
                            }
                            var typeEmployee = new TypeEmployee
                            {
                                EmployeeID             = empID,
                                EmployeeEmployeeTypeid = employeeEmployeeTypeSaved.EmployeeEmployeeTypeid,
                                EmployeeFullName       = toViewModel.ToFullName(employee.FirstName, employee.LastName)
                            };

                            context.TypeEmployees.Add(typeEmployee);
                            context.SaveChanges();
                        }


                        dbTransaction.Commit();
                        return(new ResponseVM
                                   ("create", true, "EmployeeEmployeeType"));
                    }
                    catch (Exception ex)
                    {
                        dbTransaction.Rollback();
                        return(new ResponseVM("create", false, "EmployeeEmployeeType", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
                    }
                }
            }
        }