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); }