public TRN_PaperOrder02_H Insert(SchoolQPaper_entities entities, string PPRODR02_code, DateTime PPRODR02_datetime, string PPRODR02_remarks, decimal PPRODR02_advanced_pay, string PPRODR02_cheque_no, string PPRODR02_mo_office, string PPRODR02_font, decimal PPRODR02_gross_tot, decimal PPRODR02_discount_amnt, decimal PPRODR02_net_tot, decimal PPRODR02_discount_percnt, string PPRODR02_telephone, string PPRODR02_train_received_by, string PPRODR02_train_received_by_nic, int?TRAINST_id, int SCHL_id, int DELIMETH_id, int PAYTYP_id) { bool dispose = entities == null; entities = entities ?? new SchoolQPaper_entities(); TRN_PaperOrder02_H paperorder02_rec = new TRN_PaperOrder02_H(); paperorder02_rec.PPRODR02_code = PPRODR02_code; paperorder02_rec.PPRODR02_datetime = PPRODR02_datetime; paperorder02_rec.PPRODR02_remarks = PPRODR02_remarks; paperorder02_rec.PPRODR02_advanced_pay = PPRODR02_advanced_pay; paperorder02_rec.PPRODR02_cheque_no = PPRODR02_cheque_no; paperorder02_rec.PPRODR02_mo_office = PPRODR02_mo_office; paperorder02_rec.PPRODR02_font = PPRODR02_font; paperorder02_rec.PPRODR02_gross_tot = PPRODR02_gross_tot; paperorder02_rec.PPRODR02_discount_amnt = PPRODR02_discount_amnt; paperorder02_rec.PPRODR02_net_tot = PPRODR02_net_tot; paperorder02_rec.PPRODR02_discount_percnt = PPRODR02_discount_percnt; paperorder02_rec.PPRODR02_telephone = PPRODR02_telephone; paperorder02_rec.PPRODR02_train_received_by = PPRODR02_train_received_by; paperorder02_rec.PPRODR02_train_received_by_nic = PPRODR02_train_received_by_nic; paperorder02_rec.TRAINST_id = TRAINST_id; paperorder02_rec.SCHL_id = SCHL_id; paperorder02_rec.DELIMETH_id = DELIMETH_id; paperorder02_rec.PAYTYP_id = PAYTYP_id; entities.TRN_PaperOrder02_H.Add(paperorder02_rec); entities.SaveChanges(); if (dispose) { entities.Dispose(); } return(paperorder02_rec); }
public TRN_PaperOrder02_H Save(SchoolQPaper_entities entities, string PPRODR02_code, DateTime PPRODR02_datetime, string PPRODR02_remarks, decimal PPRODR02_advanced_pay, string PPRODR02_cheque_no, string PPRODR02_mo_office, string PPRODR02_font, decimal PPRODR02_gross_tot, decimal PPRODR02_discount_amnt, decimal PPRODR02_net_tot, decimal PPRODR02_discount_percnt, string PPRODR02_telephone, string PPRODR02_train_received_by, string PPRODR02_train_received_by_nic, Tuple <int?, string> MST_TrainStation_rec, int SCHL_id, int DELIMETH_id, int PAYTYP_id, List <PaperOrderD_Rec> PaperOrderD_Recs) { bool dispose = entities == null; entities = entities ?? new SchoolQPaper_entities(); TRN_PaperOrder02_H paperorder02_rec = null; System.Data.Entity.DbContextTransaction trans = null; if (dispose) { trans = entities.Database.BeginTransaction(); } try { if (MST_TrainStation_rec.Item1 != null && MST_TrainStation_rec.Item1 == 0) { var trainstation_rec = new MST_TrainStation_Class().Insert(entities, MST_TrainStation_rec.Item2, PPRODR02_font); MST_TrainStation_rec = new Tuple <int?, string>(trainstation_rec.TRAINST_id, trainstation_rec.TRAINST_name); } PPRODR02_code = new Document.Document_Class().GetDocumentCode(entities, Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_A_L_Invoice); paperorder02_rec = new TRN_PaperOrder02_H_Class().Insert(entities, PPRODR02_code, PPRODR02_datetime, PPRODR02_remarks, PPRODR02_advanced_pay, PPRODR02_cheque_no, PPRODR02_mo_office, PPRODR02_font, PPRODR02_gross_tot, PPRODR02_discount_amnt, PPRODR02_net_tot, PPRODR02_discount_percnt, PPRODR02_telephone, PPRODR02_train_received_by, PPRODR02_train_received_by_nic, MST_TrainStation_rec.Item1, SCHL_id, DELIMETH_id, PAYTYP_id); PaperOrderD_Recs.ForEach(r => { new TRN_PaperOrder02_D_Class().Insert(entities, r.PPRODR02D_paper_qty, r.GRADE_id, r.SUBJ_id, paperorder02_rec.PPRODR02_id); }); new TRN_Receivable_Class().Insert(entities, paperorder02_rec.PPRODR02_id, PPRODR02_net_tot, PPRODR02_net_tot, null, Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_A_L_Invoice); if (PPRODR02_advanced_pay != 0) { DS_Receipt DS_Receipt_Obj = new DS_Receipt(); DS_Receipt_Obj.OutstandingInvoices.AddOutstandingInvoicesRow(paperorder02_rec.PPRODR02_id, Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_A_L_Invoice, PPRODR02_code, PPRODR02_advanced_pay, PPRODR02_net_tot, SCHL_id, "", "", Settings.Default.CurrentFont); int PayTypes_Id = DS_Receipt_Obj.PayTypes.AddPayTypesRow(PAYTYP_id, "", PPRODR02_advanced_pay, "", "").Id; if (PAYTYP_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_PayType.Records.Cheque) { DS_Receipt_Obj.ChequeInfo.AddChequeInfoRow(PayTypes_Id, PPRODR02_cheque_no, DateTime.Now); } else if (PAYTYP_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_PayType.Records.MO) { DS_Receipt_Obj.MoneyOrderInfo.AddMoneyOrderInfoRow(PayTypes_Id, DateTime.Now, PPRODR02_cheque_no, PPRODR02_mo_office); } new Receipt.Receipt_Class().Save(entities, "", PPRODR02_datetime, PPRODR02_datetime, PPRODR02_advanced_pay, "", Settings.Default.CurrentFont, SCHL_id, null, DS_Receipt_Obj); } if (dispose) { trans.Commit(); } } catch (Exception ex) { if (dispose) { trans.Rollback(); } throw ex; } if (dispose) { trans.Dispose(); entities.Dispose(); } return(paperorder02_rec); }