public List<Ticket> GetAll()
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
List<tbl_Tickets> dbListTickets = context.tbl_Tickets.ToList();
List<Ticket> entList = new List<Ticket>();
foreach (var drItem in dbListTickets)
{
Ticket entItem = new Ticket();
AssignDataObjectToEntity(drItem, ref entItem);
entList.Add(entItem);
}
return entList;
}
public int Save(Ticket newTicket)
{
int blResult = -1;
try
{
if (newTicket.IdTicket == 0)
{
blResult = Insert(newTicket);
}
else
{
blResult = Update(newTicket);
}
}
catch {
return -1;
}
return blResult;
}
private void AssignDataObjectToEntity(tbl_Tickets dbCategory, ref Ticket entity)
{
entity.IdTicket = dbCategory.IdTicket;
entity.Description = dbCategory.Description;
entity.CreatedOn = dbCategory.CreatedOn;
entity.AssignedTo = new Security.MembershipService().GetUserById(dbCategory.IdAssignedTo);
entity.Category = new CategoryService().GetByID(dbCategory.IdCategory);
entity.TicketStatus = dbCategory.TicketStatus == "Abierto" ? Ticket.TicketStatusEnum.Abierto : Ticket.TicketStatusEnum.Cerrado;
entity.CreatedBy = new Security.MembershipService().GetUserById(dbCategory.CreatedBy);
entity.CloseDescription = dbCategory.CloseDescription;
try
{
entity.ClosedOn = dbCategory.ClosedOn;
entity.ClosedOnByUser = dbCategory.ClosedOnByUser.Value;
}
catch
{ }
entity.IdPrioriy = dbCategory.IdPriority;
}
public List<Ticket> GetAllByIdCompanyStatus(int ID,Ticket.TicketStatusEnum Status)
{
List<Ticket> entityList = GetAll().Where(t => t.CreatedBy.EntCompany.IdCompany == ID && t.TicketStatus == Ticket.TicketStatusEnum.Abierto).ToList();
return entityList;
}
private int Update(Ticket entTicket)
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
try {
tbl_Tickets dbTickets = context.tbl_Tickets.Where(t => t.IdTicket == entTicket.IdTicket).FirstOrDefault();
dbTickets.CloseDescription = entTicket.CloseDescription;
dbTickets.ClosedOn = DateTime.Now;
dbTickets.TicketStatus = entTicket.TicketStatus.ToString();
dbTickets.ClosedOnByUser = entTicket.ClosedOnByUser;
context.SubmitChanges();
return dbTickets.IdTicket;
}
catch { }
return -1;
}
private int Insert(Ticket entTicket)
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
try
{
tbl_Tickets dbTickets = new tbl_Tickets() {
CloseDescription = entTicket.CloseDescription,
CreatedOn = entTicket.CreatedOn,
CreatedBy = entTicket.CreatedBy.IdUser,
Description = entTicket.Description,
IdAssignedTo = entTicket.AssignedTo.IdUser,
IdCategory = entTicket.Category.IdCategory,
IdPriority = entTicket.IdPrioriy,
TicketStatus = entTicket.TicketStatus.ToString()
};
context.tbl_Tickets.InsertOnSubmit(dbTickets);
context.SubmitChanges();
return dbTickets.IdTicket;
}
catch
{ }
return -1;
}