public void UpdateSyncTicket(DBTicketModel ticket)
{
string sql = "[dbo].[MTL_HBP_Tickets_Sync]";
SqlCommand command = new SqlCommand(sql, cnn);
SqlDataReader rdr = null;
try
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@company", SqlDbType.Char).Value = ticket.Company;
command.Parameters.Add("@rfc", SqlDbType.Char).Value = ticket.RFC;
command.Parameters.Add("@numoperacion", SqlDbType.Int).Value = ticket.NumeroOperacion;
command.Parameters.Add("@tipoactividad", SqlDbType.Char).Value = ticket.TipoActividad;
command.Parameters.Add("@ticketid", SqlDbType.BigInt).Value = ticket.TicketId;
rdr = command.ExecuteReader();
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
}
public IList <DBTicketModel> GetTickets()
{
string sql = "SELECT * FROM dbo.HBP_Tickets where TicketId is null";
SqlCommand sqlCommand = new SqlCommand(sql, cnn);
SqlDataReader dataReader = null;
IList <DBTicketModel> tickets = new List <DBTicketModel>();
try
{
sqlCommand.CommandType = CommandType.Text;
dataReader = sqlCommand.ExecuteReader();
if (dataReader.HasRows)
{
DataTable dataTable = new DataTable();
dataTable.Load(dataReader);
foreach (DataRow row in dataTable.Rows)
{
DBTicketModel ticketModel = new DBTicketModel
{
Company = row.Field <string>("Company"),
RFC = row.Field <string>("RFC"),
Monto = row.Field <decimal?>("Monto"),
FechaAlta = row.Field <DateTime>("FechaAlta"),
NumeroOperacion = row.Field <int>("NumOperacion"),
Descripcion = row.Field <string>("Descripcion"),
SyncDate = row.Field <DateTime?>("sync_date"),
TicketId = row.Field <long?>("TicketId"),
TipoActividad = row.Field <string>("TipoActividad")
};
tickets.Add(ticketModel);
}
}
}
finally
{
if (dataReader != null)
{
dataReader.Close();
}
}
return(tickets);
}