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;
}
}
