private bool createDetail(TEDEF_DETFAC obj)
{
try
{
using (var db = new ticketpremiumEntities())
{
db.TEDEF_DETFAC.Add(obj);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public Bill generateBill(SoccerGame soccerGame, DateTime date_bill, string code_client, string mod_pag)
{
Bill bill = null;
try
{
TECLI_CLIENT client = null;
using (var db = new ticketpremiumEntities())
{
client = db.TECLI_CLIENT.Find(code_client);
}
if (client != null)
{
SoccerGame result_soccergame = updateLocalitiesSoccerGame(soccerGame);
if (result_soccergame != null)
{
int bill_code_saved = 0;
float total = 0;
using (var db = new ticketpremiumEntities())
{
TEFAC_FACTUR aux_bill = new TEFAC_FACTUR();
aux_bill.TECLI_CODIGO = client.TECLI_CODIGO;
aux_bill.TEFAC_FECHA = date_bill;
aux_bill.TEFAC_MODPAG = mod_pag;
foreach (Locality locality in result_soccergame.localities)
{
total += locality.price;
}
aux_bill.TEFAC_TOTAL = total;
db.TEFAC_FACTUR.Add(aux_bill);
db.SaveChanges();
bill_code_saved = aux_bill.TEFAC_CODIGO;
}
if (bill_code_saved > 0)
{
List <Locality> localities_bill = new List <Locality>();
foreach (Locality locality in result_soccergame.localities)
{
TEDEF_DETFAC tedef_detfac = new TEDEF_DETFAC();
tedef_detfac.TELCP_CODIGO = locality.code_locality;
tedef_detfac.TEPAF_CODIGO = locality.code_soccergame;
tedef_detfac.TEFAC_CODIGO = bill_code_saved;
tedef_detfac.TEDEF_CANTID = locality.availability;
tedef_detfac.TEDEF_SUBTOT = locality.price;
if (createDetail(tedef_detfac))
{
localities_bill.Add(locality);
}
}
result_soccergame.localities = localities_bill;
bill = new Bill();
bill.code_client = client.TECLI_CODIGO;
bill.name_client = client.TECLI_NOMBRE;
bill.code_bill = bill_code_saved;
bill.date_bill = date_bill.ToString();
bill.way_pay = mod_pag;
bill.total = total;
bill.soccer_game = result_soccergame;
}
else
{
bill = null;
}
}
else
{
bill = null;
}
}
else
{
bill = null;
}
}
catch (Exception e)
{
bill = null;
}
return(bill);
}
