//public static Spc_Get_Ticket_By_Usr_Request ToModel(this SPC_GET_TICKET_BY_USR_REQUEST_Result Table)
//{
// return new Spc_Get_Ticket_By_Usr_Request()
// {
// Id = Table.Id,
// Titulo = Table.Titulo,
// TicketDescrip = Table.TicketDescrip,
// IssueDescrip = Table.IssueDescrip,
// UsuarioRequest = Table.UsuarioRequest,
// DepartamentoDescrip = Table.DepartamentoDescrip,
// DivisionDescrip = Table.DivisionDescrip,
// Estatus = Table.Estatus,
// Fecha_Solicitud = Table.Fecha_Solicitud,
// Fecha_Correcion = Table.Fecha_Correcion,
// Fecha_Modificacion = Table.Fecha_Modificacion,
// OrganizacionDescrip = Table.OrganizacionDescrip,
// UsuarioAsignado = Table.UsuarioAsignado,
// };
//}
//public static Spc_Get_Ticket_By_Usr_Request ToTable(this SPC_GET_TICKET_BY_USR_REQUEST_Result Model)
//{
// return new Spc_Get_Ticket_By_Usr_Request()
// {
// Id = Model.Id,
// Titulo = Model.Titulo,
// TicketDescrip = Model.TicketDescrip,
// IssueDescrip = Model.IssueDescrip,
// UsuarioRequest = Model.UsuarioRequest,
// DepartamentoDescrip = Model.DepartamentoDescrip,
// DivisionDescrip = Model.DivisionDescrip,
// Estatus = Model.Estatus,
// Fecha_Solicitud = Model.Fecha_Solicitud,
// Fecha_Correcion = Model.Fecha_Correcion,
// Fecha_Modificacion = Model.Fecha_Modificacion,
// OrganizacionDescrip = Model.OrganizacionDescrip,
// UsuarioAsignado = Model.UsuarioAsignado
// };
//}
//public static Spc_Get_All_Tickets_With_Descrip ToModel(this SPC_GET_ALL_TICKETS_WITH_DESCRIP_Result Table)
//{
// return new Spc_Get_All_Tickets_With_Descrip()
// {
// Id = Table.Id,
// Titulo = Table.Titulo,
// TicketDescrip = Table.TicketDescrip,
// IssueDescrip = Table.IssueDescrip,
// UsuarioRequest = Table.UsuarioRequest,
// DepartamentoDescrip = Table.DepartamentoDescrip,
// DivisionDescrip = Table.DivisionDescrip,
// Estatus = Table.Estatus,
// Fecha_Solicitud = Table.Fecha_Solicitud,
// Fecha_Correcion = Table.Fecha_Correcion,
// Fecha_Modificacion = Table.Fecha_Modificacion,
// OrganizacionDescrip = Table.OrganizacionDescrip,
// UsuarioAsignado = Table.UsuarioAsignado,
// userAssignedId = Table.userAssignedId,
// userRequestId = Table.userRequestId
// };
//}
//public static SPC_GET_ALL_TICKETS_WITH_DESCRIP_Result ToTable(this Spc_Get_All_Tickets_With_Descrip Model)
//{
// return new SPC_GET_ALL_TICKETS_WITH_DESCRIP_Result()
// {
// Id = Model.Id,
// Titulo = Model.Titulo,
// TicketDescrip = Model.TicketDescrip,
// IssueDescrip = Model.IssueDescrip,
// UsuarioRequest = Model.UsuarioRequest,
// DepartamentoDescrip = Model.DepartamentoDescrip,
// DivisionDescrip = Model.DivisionDescrip,
// Estatus = Model.Estatus,
// Fecha_Solicitud = Model.Fecha_Solicitud,
// Fecha_Correcion = Model.Fecha_Correcion,
// Fecha_Modificacion = Model.Fecha_Modificacion,
// OrganizacionDescrip = Model.OrganizacionDescrip,
// UsuarioAsignado = Model.UsuarioAsignado,
// userAssignedId = Model.userAssignedId,
// userRequestId = Model.userRequestId
// };
//}
//public static Spc_Get_Tickets_User_Followed_Result ToModel(this SPC_GET_TICKETS_USER_FOLLOWED_Result Table)
//{
// return new Spc_Get_Tickets_User_Followed_Result()
// {
// Id = Table.Id,
// Titulo = Table.Titulo,
// TicketDescrip = Table.TicketDescrip,
// IssueDescrip = Table.IssueDescrip,
// UsuarioRequest = Table.UsuarioRequest,
// DepartamentoDescrip = Table.DepartamentoDescrip,
// DivisionDescrip = Table.DivisionDescrip,
// Estatus = Table.Estatus,
// Fecha_Solicitud = Table.Fecha_Solicitud,
// Fecha_Correcion = Table.Fecha_Correcion,
// Fecha_Modificacion = Table.Fecha_Modificacion,
// OrganizacionDescrip = Table.OrganizacionDescrip,
// UsuarioAsignado = Table.UsuarioAsignado,
// userAssignedId = Table.userAssignedId,
// userRequestId = Table.userRequestId
// };
//}
//public static SPC_GET_TICKETS_USER_FOLLOWED_Result ToTable(this Spc_Get_Tickets_User_Followed_Result Model)
//{
// return new SPC_GET_TICKETS_USER_FOLLOWED_Result()
// {
// Id = Model.Id,
// Titulo = Model.Titulo,
// TicketDescrip = Model.TicketDescrip,
// IssueDescrip = Model.IssueDescrip,
// UsuarioRequest = Model.UsuarioRequest,
// DepartamentoDescrip = Model.DepartamentoDescrip,
// DivisionDescrip = Model.DivisionDescrip,
// Estatus = Model.Estatus,
// Fecha_Solicitud = Model.Fecha_Solicitud,
// Fecha_Correcion = Model.Fecha_Correcion,
// Fecha_Modificacion = Model.Fecha_Modificacion,
// OrganizacionDescrip = Model.OrganizacionDescrip,
// UsuarioAsignado = Model.UsuarioAsignado,
// userAssignedId = Model.userAssignedId,
// userRequestId = Model.userRequestId
// };
//}
/// <summary>
/// Converts this instance of <see cref="TICKETS"/> to an instance of <see cref="Tickets"/>.
/// </summary>
/// <param name="entity"><see cref="TICKETS"/> to convert.</param>
public static Tickets ToModel(this TICKETS entity)
{
if (entity == null)
{
return(null);
}
var dto = new Tickets();
dto.Id = entity.Id;
dto.IssueId = entity.IssueId;
dto.UserRequestId = entity.UserRequestId;
dto.RequestDepartamentId = entity.RequestDepartamentId;
dto.DestinationDivisionId = entity.DestinationDivisionId;
dto.Estatus = entity.Estatus;
dto.Fecha_Solicitud = entity.Fecha_Solicitud;
dto.Fecha_Correcion = entity.Fecha_Correcion;
dto.Fecha_Modificacion = entity.Fecha_Modificacion;
dto.OrganizacionId = entity.OrganizacionId;
dto.Titulo = entity.Titulo;
dto.Descripcion = entity.Descripcion;
dto.UserAssigned = entity.UserAssigned;
entity.OnDTO(dto);
return(dto);
}
/// <summary>
/// Converts this instance of <see cref="Tickets"/> to an instance of <see cref="TICKETS"/>.
/// </summary>
/// <param name="dto"><see cref="Tickets"/> to convert.</param>
public static TICKETS ToTable(this Tickets dto)
{
if (dto == null)
{
return(null);
}
var entity = new TICKETS();
entity.Id = dto.Id;
entity.IssueId = dto.IssueId;
entity.UserRequestId = dto.UserRequestId;
entity.RequestDepartamentId = dto.RequestDepartamentId;
entity.DestinationDivisionId = dto.DestinationDivisionId;
entity.Estatus = dto.Estatus;
entity.Fecha_Solicitud = DateTime.Now;
entity.Fecha_Correcion = dto.Fecha_Correcion;
entity.Fecha_Modificacion = dto.Fecha_Modificacion;
entity.OrganizacionId = dto.OrganizacionId;
entity.Titulo = dto.Titulo;
entity.Descripcion = dto.Descripcion;
entity.UserAssigned = dto.UserAssigned;
dto.OnEntity(entity);
return(entity);
}
public ActionResult DeleteConfirmed(int id)
{
TICKETS tICKETS = db.TICKETS.Find(id);
db.TICKETS.Remove(tICKETS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "idTickets,emplacementMaterielTicket,typeMaterielTicket,niveauUrgenceTicket,descriptionIncident,dateCreationTicket,dateClotureTicket,idUtilisateur,numeroSerieMateriel")] TICKETS tICKETS)
{
if (ModelState.IsValid)
{
db.Entry(tICKETS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.numeroSerieMateriel = new SelectList(db.MATERIEL, "numeroSerieMateriel", "emplacementMateriel", tICKETS.numeroSerieMateriel);
ViewBag.idUtilisateur = new SelectList(db.UTILISATEUR, "idUtilisateur", "nomUtilisateur", tICKETS.idUtilisateur);
return(View(tICKETS));
}
// GET: TICKETS/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TICKETS tICKETS = db.TICKETS.Find(id);
if (tICKETS == null)
{
return(HttpNotFound());
}
return(View(tICKETS));
}
public ActionResult Create([Bind(Include = "idTickets,emplacementMaterielTicket,typeMaterielTicket,niveauUrgenceTicket,descriptionIncident,dateCreationTicket,dateClotureTicket,idUtilisateur,numeroSerieMateriel")] TICKETS tICKETS)
{
if (ModelState.IsValid)
{
tICKETS.dateCreationTicket = DateTime.Now; //enregistrement dans la base de données sous forme de date et heure
db.TICKETS.Add(tICKETS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.numeroSerieMateriel = new SelectList(db.MATERIEL, "numeroSerieMateriel", "emplacementMateriel", tICKETS.numeroSerieMateriel);
ViewBag.idUtilisateur = new SelectList(db.UTILISATEUR, "idUtilisateur", "nomUtilisateur", tICKETS.idUtilisateur);
return(View(tICKETS));
}
public ActionResult Create([Bind(Include = "idTicket,emplacementMaterielTicket,typeMaterielTicket,descriptionIncident,dateCreationIncident,dateClotureIncident,idUtilisateur,numeroSerieMateriel,nomCellule,etatStatut")] TICKETS tICKETS)
{
if (ModelState.IsValid)
{
db.TICKETS.Add(tICKETS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.nomCellule = new SelectList(db.CELLULE, "nomCellule", "nomCellule", tICKETS.nomCellule);
ViewBag.numeroSerieMateriel = new SelectList(db.MATERIEL, "numeroSerieMateriel", "emplacementMateriel", tICKETS.numeroSerieMateriel);
ViewBag.etatStatut = new SelectList(db.STATUT, "etatStatut", "etatStatut", tICKETS.etatStatut);
ViewBag.idUtilisateur = new SelectList(db.UTILISATEUR, "idUtilisateur", "nomUtilisateur", tICKETS.idUtilisateur);
return(View(tICKETS));
}
// GET: TICKETSAdmin/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TICKETS tICKETS = db.TICKETS.Find(id);
if (tICKETS == null)
{
return(HttpNotFound());
}
ViewBag.numeroSerieMateriel = new SelectList(db.MATERIEL, "numeroSerieMateriel", "emplacementMateriel", tICKETS.numeroSerieMateriel);
ViewBag.idUtilisateur = new SelectList(db.UTILISATEUR, "idUtilisateur", "nomUtilisateur", tICKETS.idUtilisateur);
return(View(tICKETS));
}
public ActionResult Edit([Bind(Include = "idTicket,emplacementMaterielTicket,typeMaterielTicket,descriptionIncident,dateCreationIncident,dateClotureIncident,idUtilisateur,idUrgence,numeroSerieMateriel,etatStatut,idCelllule,idBarre")] TICKETS tICKETS)
{
if (ModelState.IsValid)
{
db.Entry(tICKETS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.idBarre = new SelectList(db.BARRE, "idBarre", "libelleBarre", tICKETS.idBarre);
ViewBag.idCelllule = new SelectList(db.CELLULE, "idCelllule", "libelleCellule", tICKETS.idCelllule);
ViewBag.numeroSerieMateriel = new SelectList(db.MATERIEL, "numeroSerieMateriel", "emplacementMateriel", tICKETS.numeroSerieMateriel);
ViewBag.idUrgence = new SelectList(db.NIVEAUURGENCETICKET, "idUrgence", "libelleUrgence", tICKETS.idUrgence);
ViewBag.etatStatut = new SelectList(db.STATUT, "etatStatut", "libelleStatut", tICKETS.etatStatut);
ViewBag.idUtilisateur = new SelectList(db.UTILISATEUR, "idUtilisateur", "nomUtilisateur", tICKETS.idUtilisateur);
return(View(tICKETS));
}
// GET: TICKETS/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TICKETS tICKETS = db.TICKETS.Find(id);
if (tICKETS == null)
{
return(HttpNotFound());
}
ViewBag.idBarre = new SelectList(db.BARRE, "idBarre", "libelleBarre", tICKETS.idBarre);
ViewBag.idCelllule = new SelectList(db.CELLULE, "idCelllule", "libelleCellule", tICKETS.idCelllule);
ViewBag.numeroSerieMateriel = new SelectList(db.MATERIEL, "numeroSerieMateriel", "emplacementMateriel", tICKETS.numeroSerieMateriel);
ViewBag.idUrgence = new SelectList(db.NIVEAUURGENCETICKET, "idUrgence", "libelleUrgence", tICKETS.idUrgence);
ViewBag.etatStatut = new SelectList(db.STATUT, "etatStatut", "libelleStatut", tICKETS.etatStatut);
ViewBag.idUtilisateur = new SelectList(db.UTILISATEUR, "idUtilisateur", "nomUtilisateur", tICKETS.idUtilisateur);
return(View(tICKETS));
}
public static Tickets ToModel(this TICKETS Table)
{
if (Table == null)
{
return(null);
}
return(new Tickets()
{
Id = Table.Id,
DestinationDivisionId = Table.DestinationDivisionId,
IssueId = Table.IssueId,
OrganizacionId = Table.OrganizacionId,
RequestDepartamentId = Table.RequestDepartamentId,
UserRequestId = Table.UserRequestId,
Estatus = Table.Estatus,
Fecha_Correcion = Table.Fecha_Correcion,
Fecha_Modificacion = Table.Fecha_Modificacion,
Fecha_Solicitud = Table.Fecha_Solicitud
});
}
/// <summary> /// Invoked when <see cref="ToTable"/> operation is about to return. /// </summary> /// <param name="entity"><see cref="TICKETS"/> converted from <see cref="Tickets"/>.</param> static partial void OnEntity(this Tickets dto, TICKETS entity);
/// <summary> /// Invoked when <see cref="ToModel"/> operation is about to return. /// </summary> /// <param name="dto"><see cref="Tickets"/> converted from <see cref="TICKETS"/>.</param> static partial void OnDTO(this TICKETS entity, Tickets dto);
