public ItemRequestFormModel InsertNewItemRequest(InsertItemRequestModel itemRequest) { ItemRequestForm newItemRequest = new ItemRequestForm(); ItemRequestFormModel result = new ItemRequestFormModel(); var ticketStatusQuery = _itemRequestFormDataAccess.GetAllTicketStatus(); int ticketStatusNew = ticketStatusQuery.CodeDetails.Where(x => x.CodeValue.Contains("New")) .Select(x => x.Id).FirstOrDefault(); newItemRequest.Title = itemRequest.Title; newItemRequest.StatusCd = ticketStatusNew; newItemRequest.IsActive = true; newItemRequest.Notes = itemRequest.Notes; newItemRequest.FollowupStartDttm = DateTime.UtcNow; newItemRequest.CreateUserName = "******"; newItemRequest.CreateDttm = DateTime.UtcNow; newItemRequest.UpdateUserName = "******"; newItemRequest.UpdateDttm = DateTime.UtcNow; var insertedItem = _itemRequestFormDataAccess.InsertNewItemRequest(newItemRequest); result.Id = insertedItem.Id; result.Title = insertedItem.Title; result.Notes = insertedItem.Notes; result.DateCreated = insertedItem.CreateDttm; result.StatusCd = insertedItem.StatusCd; result.RequestFormItems = new List <ItemList>(); result.RequestFormQuotations = new List <QuotationList>(); return(result); }
public ItemRequestForm InsertNewItemRequest(ItemRequestForm itemRequest) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { context.ItemRequestForms.Add(itemRequest); context.Entry(itemRequest).State = EntityState.Added; int result = context.SaveChanges(); return(result > 0 ? itemRequest : new ItemRequestForm()); } }
public bool UpdateItemRequestById(UpdateItemRequestModel itemRequest) { ItemRequestForm query = new ItemRequestForm(); query.Id = itemRequest.Id; query.Title = itemRequest.Title; query.Notes = itemRequest.Notes; query.UpdateDttm = DateTime.UtcNow; query.UpdateUserName = "******"; query.FollowupStartDttm = DateTime.UtcNow; var result = _itemRequestFormDataAccess.UpdateItemRequestById(query); return(result); }
public bool UpdateItemRequestById(ItemRequestForm itemRequest) { using (OrmocIMSEntities context = new OrmocIMSEntities()) { var item = context.ItemRequestForms.Where(x => x.Id == itemRequest.Id).FirstOrDefault(); item.Id = itemRequest.Id; item.Title = itemRequest.Title; item.UpdateDttm = itemRequest.UpdateDttm; item.UpdateUserName = itemRequest.UpdateUserName; context.Entry(item).State = EntityState.Modified; int result = context.SaveChanges(); return(result > 0 ? true : false); } }
private void InitForm(string mode) { Form newForm; DataGridViewRow selectedRow = new DataGridViewRow(); if (mode.Equals("Edit")) { try { selectedRow = DgvGeneric.SelectedRows[0]; } catch (Exception ex) { Console.WriteLine(ex.Message); MessageBox.Show( text: "Debes seleccionar una fila", caption: "Error", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); return; } } switch (activeGrid) { case 0: newForm = new EmployeeForm(mode, selectedRow); newForm.ShowDialog(); break; case 1: newForm = new DepartmentForm(mode, selectedRow); newForm.ShowDialog(); break; case 2: newForm = new ItemForm(mode, selectedRow); newForm.ShowDialog(); break; case 3: newForm = new BrandForm(mode, selectedRow); newForm.ShowDialog(); break; case 4: newForm = new UnitForm(mode, selectedRow); newForm.ShowDialog(); break; case 5: newForm = new ProviderForm(mode, selectedRow); newForm.ShowDialog(); break; case 6: newForm = new ItemRequestForm(mode, selectedRow); newForm.ShowDialog(); break; case 7: newForm = new PurchaseOrderForm(mode, selectedRow); newForm.ShowDialog(); break; case 8: newForm = new UserForm(mode, selectedRow); newForm.ShowDialog(); break; } }