public TicketWorkflow Insert(TicketWorkflow workflow)
{
using (var model = new gb_ts_stagingEntities())
{
var newRecord = new tic_TicketWorkflow
{
IssueTypeId = workflow.IssueType.Id == 0 ? null : (int?)workflow.IssueType.Id,
TicketTypeId = workflow.TicketType.Id == 0 ? null : (int?)workflow.TicketType.Id,
ProductId = workflow.Product.Id == 0 ? null : (int?)workflow.Product.Id,
ProductCategoryId = workflow.ProductCategory.Id == 0 ? null : (int?)workflow.ProductCategory.Id,
CustomerPriorityId = workflow.CustomerPriorityId == 0 ? null : workflow.CustomerPriorityId,
DepartmentId = workflow.Department.Id,
CreationDate = DateTime.Now,
CreatedBy = "Admin",
SortOrder = workflow.SortOrder,
IsActive = true
};
model.tic_TicketWorkflow.Add(newRecord);
model.SaveChanges();
workflow.Id = newRecord.Id;
return(workflow);
}
}
public IList <Error> Validate(TicketWorkflow record)
{
using (var model = new gb_ts_stagingEntities())
{
record.IssueTypeId = record.IssueType?.Id;
if (record.IssueTypeId == 0)
{
record.IssueTypeId = null;
}
record.ProductCategoryId = record.ProductCategory?.Id;
if (record.ProductCategoryId == 0)
{
record.ProductCategoryId = null;
}
if (record.CustomerPriorityId == 0)
{
record.CustomerPriorityId = null;
}
record.TicketTypeId = record.TicketType?.Id;
if (record.TicketTypeId == 0)
{
record.TicketTypeId = null;
}
record.ProductId = record.Product?.Id;
if (record.ProductId == 0)
{
record.ProductId = null;
}
var q =
model.tic_TicketWorkflow.FirstOrDefault(
rec =>
rec.IsActive &&
rec.IssueTypeId == record.IssueTypeId &&
rec.ProductCategoryId == record.ProductCategoryId &&
rec.CustomerPriorityId == record.CustomerPriorityId &&
rec.ProductId == record.ProductId &&
rec.TicketTypeId == record.TicketTypeId &&
rec.Id != record.Id);
if (q == null)
{
return(null);
}
return(new List <Error> {
new Error {
Code = 1, ErrorText = "Workflow rule should be unique."
}
});
}
}
public TicketWorkflow Update(TicketWorkflow workflow)
{
using (var model = new gb_ts_stagingEntities())
{
var recordToEdit = model.tic_TicketWorkflow.First(rec => rec.Id == workflow.Id);
recordToEdit.IssueTypeId = workflow.IssueType.Id == 0 ? null : (int?)workflow.IssueType.Id;
recordToEdit.TicketTypeId = workflow.TicketType.Id == 0 ? null : (int?)workflow.TicketType.Id;
recordToEdit.ProductId = workflow.Product.Id == 0 ? null : (int?)workflow.Product.Id;
recordToEdit.ProductCategoryId = workflow.ProductCategory.Id == 0 ? null : (int?)workflow.ProductCategory.Id;
recordToEdit.DepartmentId = workflow.Department.Id;
recordToEdit.CustomerPriorityId = workflow.CustomerPriorityId == 0 ? null : workflow.CustomerPriorityId;
recordToEdit.SortOrder = workflow.SortOrder;
recordToEdit.UpdatedBy = "Admin";
recordToEdit.LastUpdate = DateTime.Now;
model.SaveChanges();
return(workflow);
}
}
public TicketWorkflow Update(TicketWorkflow workflow)
{
throw new NotImplementedException();
}
public TicketWorkflow Insert(TicketWorkflow workflow)
{
throw new NotImplementedException();
}
public JsonResult Validate(TicketWorkflow record)
{
var errors = _ticketWorkflowRepository.Validate(record);
return(Json(errors));
}
public JsonResult Insert(TicketWorkflow record)
{
_ticketWorkflowRepository.Insert(record);
return(Json(record));
}
public JsonResult Update(TicketWorkflow record)
{
_ticketWorkflowRepository.Update(record);
return(Json(record));
}
