//
private void CasoAtendidoONoSePresento(EstatusTicket Estatus)
{
using (TicketService service = new TicketService())
{
if (_ticketTrabajado != null)
{
service.ChangeEstatusTicket(_ticketTrabajado.IdTicket, Estatus);
}
}
this.lblNumTicket.Text = "FP-000";
}
//
public void ChangeEstatusTicket(int IdTicket, EstatusTicket Estatus)
{
SqlDatabase _Db = null;
int IdEstatusTicket = 0;
switch (Estatus)
{
case EstatusTicket.Libre:
IdEstatusTicket = 1;
break;
case EstatusTicket.Seleccionado:
IdEstatusTicket = 2;
break;
case EstatusTicket.Completado:
IdEstatusTicket = 3;
break;
case EstatusTicket.NosePresento:
IdEstatusTicket = 4;
break;
default:
break;
}
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
_Db = factory.CreateDefault() as SqlDatabase;
using (DbConnection connetion = _Db.CreateConnection())
{
if (connetion.State == ConnectionState.Closed)
{
connetion.Open();
}
using (DbCommand _DbCommand = _Db.GetStoredProcCommand("dbo.ChangeEstatusTicket"))
{
_DbCommand.Connection = connetion;
_DbCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@IdEstatusTicket", SqlDbType = SqlDbType.Int, Value = IdEstatusTicket
});
_DbCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@IdTicket", SqlDbType = SqlDbType.Int, Value = IdTicket
});
_DbCommand.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
Com.Hit.TurnoMatic.Utils.Log.LogError(TAG, "ChangeEstatusTicket", ex);
}
}
