private void doAction()
{
using (var ctx = new TicketsEntities())
{
int tech_num = Convert.ToInt16(textBox_techCode.Text);
//output paramenter
ObjectParameter objParam = new ObjectParameter("cod", typeof(String));
ctx.proc_Assign_Technician(tech_num, objParam);
String ticket_code = Convert.ToString(objParam.Value);
if (ticket_code.Equals("."))
{
MessageBox.Show("The Technician with number " + tech_num + " doesn't exist in the DB");
}
else
{
if (ticket_code.Equals(""))
{
MessageBox.Show("There are no unassigned Tickets.");
}
else
{
MessageBox.Show("The Technician with number " + tech_num + " has been assigned to Ticket " + ticket_code);
}
}
//
ctx.SaveChanges();
}
}
private void GetTickets()
{
using (var ctx = new TicketsEntities())
{
var query = from t in ctx.vi_Ticket
where t.ticketState != "closed"
select t;
//
foreach (var ticket in query)
{
dgv_tickets.Rows.Add(
ticket.cod,
ticket.ticketState,
ticket.ticketDescription,
ticket.ticketPriority,
ticket.ticketType,
ticket.ticketUser,
ticket.creationDate,
ticket.technician,
ticket.closeDate
);
}
ctx.SaveChanges();
}
}
private void GetTicketInfo()
{
using (var ctx = new TicketsEntities())
{
bool reveal = true;
String ticket_code = textBox_ticketCode.Text;
//
// get ticket steps
//
var result = ctx.proc_Get_Ticket_Steps(ticket_code);
var q = result.ToList();
//
if (q.Count() == 0)
{
//if ticket code doesn't exist, hides the insertion section
Conceal();
dgv_steps.Rows.Clear();
MessageBox.Show("There isn't any ticket with the code " + ticket_code);
}
else
{
foreach (var line in q)
{
if (!line.ticketState.Equals("In Progress"))
{
dgv_steps.Rows.Clear();
MessageBox.Show("The ticket " + ticket_code + " is not in progress");
Conceal();
reveal = false;
break;
}
dgv_steps.Rows.Add(
line.orderNumber,
line.description
);
//stores the responsible technician for the ticket, for future use
resp_technician = Convert.ToInt32(line.technician);
//stores the ticket's ticket type for future use
ticket_type = line.ticketType;
}
if (reveal)
{
Reveal();
}
}
//
ctx.SaveChanges();
}
}
public async Task <bool> InsertAddSubCategoriaHistorial(Guid IdUsuario, Guid IdSubCategoria)
{
bool validate = false;
using (var db = new TicketsEntities())
{
var result = db.spInsHistorialUsuario(IdUsuario, IdSubCategoria);
if (result < 0)
{
validate = true;
}
}
return(validate);
}
public async Task <bool> InsertCategoria(CategoriaViewModel cat)
{
bool validate = false;
using (var db = new TicketsEntities())
{
var result = db.spInsCategoria(cat.IdCategoria, cat.Nombre, cat.Descripcion, cat.UrlImagen);
if (result < 0)
{
validate = true;
}
}
return(validate);
}
public async Task <bool> InsertUsuario(UsuarioViewModel usuario)
{
bool validate = false;
using (var db = new TicketsEntities())
{
var result = db.spInsertUsuario(usuario.Nombre, usuario.Apellidos, usuario.Sexo,
usuario.Correo, usuario.Contrasena, usuario.TipoLogin, usuario.UrlImagen);
if (result < 0)
{
validate = true;
}
}
return(validate);
}
public async Task <bool> InsertSubcategoria(SubCategoriaViewModel subcategoria)
{
bool validate = false;
using (var db = new TicketsEntities())
{
var result = db.spInsSubCategoria(subcategoria.IdCategoria, subcategoria.Nombre,
subcategoria.Descripcion, subcategoria.UrlImagen, subcategoria.PrecioNormal,
subcategoria.PrecioDescuento, subcategoria.CodigoDescuento);
if (result < 0)
{
validate = true;
}
return(validate);
}
}
private void DoInsertion()
{
using (var ctx = new TicketsEntities())
{
//
// insert ticket action
//
String ticketCode = textBox_ticketCode.Text;
int tech = Convert.ToInt32(textBox_techNum.Text);
String ticketType = ticket_type;
int stepOrderNumber = Convert.ToInt32(textBox_stepNum.Text);
String note = textBox_actionNote.Text;
//output paramenter
ObjectParameter objParam = new ObjectParameter("orderNumber", typeof(int));
ctx.sp_Insert_Ticket_Action(ticketCode, tech, ticketType, stepOrderNumber, note, objParam);
//
if (MessageBox.Show("When you press Ok, the action will be closed", "Confirm", MessageBoxButtons.OK) == DialogResult.OK)
{
//
// end ticket action
//
ctx.sp_End_Ticket_Action(Convert.ToInt32(objParam.Value), ticketCode);
//
if (MessageBox.Show("Did the action solve the problem?", "Confirm", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
if (resp_technician == Convert.ToInt32(textBox_techNum.Text))
{
//
// close ticket
//
ctx.sp_Close_Ticket(ticketCode, tech);
MessageBox.Show("The ticket " + ticketCode + " has been closed.");
}
else
{
MessageBox.Show("You're not the technician responsible for this ticket, so it's not closed.");
}
dgv_steps.Rows.Clear();
}
}
//
ctx.SaveChanges();
}
}
public async Task <List <CategoriaViewModel> > GetCategorias()
{
var ListCategoria = new List <CategoriaViewModel>();
using (var db = new TicketsEntities())
{
var result = db.spSelCategorias();
foreach (var item in result)
{
var categoria = new CategoriaViewModel();
categoria.Descripcion = item.Descripcion;
categoria.IdCategoria = item.IdCategoria;
categoria.Nombre = item.Nombre;
categoria.UrlImagen = item.UrlImagen;
ListCategoria.Add(categoria);
}
}
return(ListCategoria);
}
public async Task <UsuarioViewModel> GetUsuario(string Correo, string password)
{
var usuario = new UsuarioViewModel();
using (var db = new TicketsEntities())
{
var result = db.spSelUsuario(Correo, password);
foreach (var item in result)
{
usuario.Nombre = item.Nombre;
usuario.Apellidos = item.Apellidos;
usuario.Contrasena = item.Contrasena;
usuario.Correo = item.Correo;
usuario.IdUsuario = item.IdUsuario;
usuario.Sexo = item.Sexo;
usuario.TipoLogin = item.TipoLogin;
usuario.UrlImagen = item.UrlImagen;
}
}
return(usuario);
}
private void doAction()
{
using (var ctx = new TicketsEntities())
{
String ticketCode = textBox_cod.Text;
//output paramenter
ObjectParameter objParam = new ObjectParameter("res", typeof(int));
ctx.proc_Remove_Ticket(ticketCode, objParam);
// proc output that indicates success
int r = Convert.ToInt32(objParam.Value);
if (r == 0)
{
MessageBox.Show("The ticket with code " + ticketCode + "does not exist or has already been removed.");
}
else
{
MessageBox.Show("The ticket with code " + ticketCode + "has been removed");
}
//
ctx.SaveChanges();
}
}
//button export click event
private void btn_export_Click(object sender, EventArgs e)
{
using (var ctx = new TicketsEntities())
{
DataSet ds = new DataSet();
// get desired ticket
String ticketCod = textBox_ticketCode.Text;
//reads XML_Schema to build dataset
ds.ReadXmlSchema("XML_Schema.xsd");
DataTableCollection dtc = ds.Tables;
//
var result = ctx.proc_Get_Ticket_Info(ticketCod);
//populate dataset
int i = 0;
foreach (var ticket in result)
{
if (i == 0)
{
// ticket info
dtc["ticket"].Rows.Add(new Object[] { ticket.tt_id, ticket.cod, ticket.ticketState, ticket.ticketDescription, 1 });
dtc["owner"].Rows.Add(new Object[] { ticket.owner_email, ticket.owner_name, ticket.owner_id, ticket.owner_email, 1 });
dtc["supervisor"].Rows.Add(new Object[] { ticket.anumber, ticket.tech_name, ticket.tech_email, ticket.anumber, 1 });
dtc["type_type"].Rows.Add(new Object[] { ticket.tt_id, ticket.tt_name, ticket.tt_id, 1 });
// ticket actions sequence
dtc["actions"].Rows.Add(new object[] { 1 });
++i;
}
// continues until there's no more actions
dtc["action"].Rows.Add(new object[] { ticket.orderNumber, ticket.beginDate, ticket.endDate, ticket.orderNumber, 1 });
}
ds.DataSetName = "Ticket_Info";
//saves both xsd and xml
ds.WriteXml(textBox_filename.Text + ".xml");
ds.WriteXmlSchema(textBox_filename.Text + ".xsd");
MessageBox.Show("The ticket " + textBox_ticketCode.Text + " has been exported to " + textBox_filename + ".xml");
//
ctx.SaveChanges();
}
}
public async Task <List <HistorialUsuarioViewModel> > GetHistorialUsuario(Guid IdUsuario)
{
var listhistorial = new List <HistorialUsuarioViewModel>();
using (var db = new TicketsEntities())
{
var result = db.spSelHistorialUsuario(IdUsuario);
foreach (var item in result)
{
var historial = new HistorialUsuarioViewModel();
historial.IdSubCategoria = item.IdSubCategoria;
historial.Nombre = item.Nombre;
historial.Descripcion = item.Descripcion;
historial.UrlImagen = item.UrlImagen;
historial.PrecioNormal = item.PrecioNormal;
historial.PrecioDescuento = item.PrecioDescuento;
historial.CodigoDescuento = item.CodigoDescuento;
listhistorial.Add(historial);
}
}
return(listhistorial);
}
public async Task <List <SubCategoriaViewModel> > GetSubCategoria(Guid IdCategoria)
{
var ListSubcategoria = new List <SubCategoriaViewModel>();
using (var db = new TicketsEntities())
{
var result = db.spSelSubCategorias(IdCategoria);
foreach (var item in result)
{
var subcategoria = new SubCategoriaViewModel();
subcategoria.Nombre = item.Nombre;
subcategoria.CodigoDescuento = item.CodigoDescuento;
subcategoria.Descripcion = item.Descripcion;
subcategoria.IdCategoria = item.IdCategoria;
subcategoria.IdSubCategoria = item.IdSubCategoria;
subcategoria.PrecioDescuento = item.PrecioDescuento;
subcategoria.PrecioNormal = item.PrecioNormal;
subcategoria.UrlImagen = item.UrlImagen;
ListSubcategoria.Add(subcategoria);
}
}
return(ListSubcategoria);
}
