public void TestMethod1()
{
TicketDS ticket = new TicketDS();
DBRepository r = DBRepository.GetDbRepository(true);
r.BeginTransaction();
ticket.Insert_Preveedor_Ticket(r, 7612, 112, 8, "Esta es una prueba desde un test unitario", "Hash");
}
static void Main(string[] args)
{
Console.WriteLine("Inicio Programa.");
DBRepository respository = DBRepository.GetDbRepository();
TicketDS ticket = new TicketDS();
DataTable dt = ticket.ObtenercasosMensuales(2015, 6, "715420/1");
Console.WriteLine("Fin Programa.");
Console.ReadLine();
}
public static ContadorCasos getContadorCasos(int mes, int anno, string poliza)
{
ContadorCasos rContador = new ContadorCasos();
rContador._cantidad = 0;
TicketDS ds = new TicketDS();
DataTable dt = ds.ObtenercasosMensuales(anno, mes, poliza);
if(dt!=null && dt.Rows.Count>0)
{
rContador._cantidad = Int32.Parse(dt.Rows[0][COL_TOTAL].ToString());
foreach(DataRow r in dt.Rows)
{
CasosMesurables caso = new CasosMesurables();
caso.TipoCaso = r[COL_TIPO_TICKET].ToString();
caso.Cantidad = Int32.Parse(r[COL_CANTIIDAD].ToString());
rContador._casos.Add(caso);
}
}
return rContador;
}
private void LoadPrestadores()
{
if(this.ID!=NULL_ID && !this.IsPrestadorLoaded)
{
TicketDS ticketDataService = new TicketDS();
DataSet ds = ticketDataService.List_PrestadoresByTicket(this.ID);
if(ds.Tables.Count>0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
PrestadorCaso p = new PrestadorCaso();
ORM_PrestadorCaso(p, dr);
this._prestadorCaso.Add(p);
}
}
this._isPrestadorLoaded = true;
}
}
public override bool Persist()
{
bool result = false;
try
{
TicketDS dataservice = new TicketDS();
if (this.Observacion == null)
throw new Exception("El objeto ticket debe tener una observación");
if (this.IsNew)
{
this._id = dataservice.Create(this.ObjectToRow(), this.Observacion.ObjectToRow(), this.GetPrestadoresTable());
result = true;
}
else
{
result = dataservice.Update(this.ObjectToRow(), this.Observacion.ObjectToRow(), this.GetPrestadoresTable());
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}
public static List<Ticket> List(FiltroTicket f, out int RecordCount)
{
List<Ticket> resultList = new List<Ticket>();
try
{
TicketDS dataservice = new TicketDS();
DataSet ds = dataservice.List(f, out RecordCount);
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[0].Rows)
{
Ticket t = new Ticket();
ORM(t, r);
resultList.Add(t);
}
}
}
catch (Exception ex)
{
throw ex;
}
return resultList;
}
public static Ticket GetById(int id)
{
Ticket ticketResult = null;
try
{
TicketDS ticketDS = new TicketDS();
String objectHash = Guid.NewGuid().ToString();
DataRow dr = ticketDS.GetObjectById(id, objectHash);
if (dr != null)
{
ticketResult = new Ticket();
ticketResult._UObjectID = objectHash;
ORM(ticketResult, dr);
ticketResult.ObservacionesHistoricas = Observacion.ListByTicket(ticketResult.ID);
ticketResult.LoadPrestadores();
}
}
catch (Exception ex)
{
throw ex;
}
return ticketResult;
}