public Model.Order InsertOrUpdate(Model.Order order) { using (var context = new DataModelDataContext()) { Order target = null; if (order.Id != Guid.Empty) { target = context.Orders.SingleOrDefault(e => e.Id == order.Id); if (target == null) { return(null); } target.State = order.State; } else { target = new Order { Id = Guid.NewGuid(), State = "ManagerApproving", StateName = "Manager approving", }; context.Orders.InsertOnSubmit(target); } target.OwnerId = order.OwnerId; context.SubmitChanges(); order.Id = target.Id; return(order); } }
public Model.Employee InsertOrUpdate(Model.Employee employee) { using (var context = new DataModelDataContext()) { Employee target = null; if (employee.Id != Guid.Empty) { target = context.Employees.SingleOrDefault(e => e.Id == employee.Id); if (target == null) { return(null); } } else { target = new Employee { Id = Guid.NewGuid(), }; context.Employees.InsertOnSubmit(target); } target.Name = employee.Name; target.RoleId = employee.RoleId; context.SubmitChanges(); employee.Id = target.Id; return(employee); } }
private Order Get(Guid id, DataModelDataContext context) { var order = context.Orders.FirstOrDefault(c => c.Id == id); if (order == null) { return(null); } return(order); }
public Guid Login(string username, string password) { using (var context = new DataModelDataContext()) { var account = context.Accounts.FirstOrDefault(a => a.Username == username && a.Password == password); if (account != null) { return(account.EmployeeId); } } return(Guid.Empty); }
public List <Model.Order> Get() { using (var context = new DataModelDataContext()) { var result = context.Orders.Select(o => Mappings.Mapper.Map <Model.Order>(o)).ToList(); foreach (var order in result) { order.OwnerName = GetCustomerString(order.OwnerId, context); } return(result); } }
public bool CheckRole(string Id, string role) { var guid = Guid.Parse(Id); using (var context = new DataModelDataContext()) { var employee = context.Employees.FirstOrDefault(e => e.Id == guid); if (employee != null) { return(context.Roles.Any(r => r.Id == employee.RoleId && r.Name == role)); } } return(false); }
public void ChangeState(Guid id, string nextState, string nextStateName) { using (var context = new DataModelDataContext()) { var order = Get(id, context); if (order == null) { return; } order.State = nextState; order.StateName = nextStateName; context.SubmitChanges(); } }
public List <Model.OrderHistory> GetOrderHistory(Guid id) { using (var context = new DataModelDataContext()) { var result = context.OrderHistories.Where(h => h.OrderId == id).OrderBy(x => x.Order).Select(h => Mappings.Mapper.Map <Model.OrderHistory>(h)).ToList(); foreach (var history in result) { if (history.EmployeeId != null) { history.EmployeeName = GetEmployeeString((Guid)history.EmployeeId, context); } } return(result); } }
private string GetCustomerString(Guid idendityGuid, DataModelDataContext context) { var customers = context.Customers.Where(e => idendityGuid == e.Id).ToList(); var sb = new StringBuilder(); bool isFirst = true; foreach (var customer in customers) { if (!isFirst) { sb.Append(","); } isFirst = false; sb.Append(customer.Name); } return(sb.ToString()); }
public void UpdateOrderHistory(Guid id, string currentState, string nextState, string command, Guid?employeeId) { using (var context = new DataModelDataContext()) { var historyItem = new OrderHistory { Id = Guid.NewGuid(), DestinationState = nextState, OrderId = id, InitialState = currentState }; context.OrderHistories.InsertOnSubmit(historyItem); historyItem.Command = command; historyItem.TransitionTime = DateTime.Now; historyItem.EmployeeId = employeeId; context.SubmitChanges(); } }
private string GetEmployeeString(Guid idendityGuid, DataModelDataContext context) { var employees = context.Employees.Where(e => idendityGuid == e.Id).ToList(); var sb = new StringBuilder(); bool isFirst = true; foreach (var employee in employees) { if (!isFirst) { sb.Append(","); } isFirst = false; sb.Append(employee.Name); } return(sb.ToString()); }