コード例 #1
0
        public TRN_PaperOrder01_H Insert(SchoolQPaper_entities entities, string PPRODR01_code, DateTime PPRODR01_datetime,
                                         string PPRODR01_remarks, decimal PPRODR01_advanced_pay, string PPRODR01_cheque_no, string PPRODR01_mo_office,
                                         int PPRODR01_additional_papers, string PPRODR01_font, decimal PPRODR01_gross_tot, decimal PPRODR01_discount_amnt,
                                         decimal PPRODR01_net_tot, decimal PPRODR01_discount_percnt, string PPRODR01_telephone, string PPRODR01_train_received_by,
                                         string PPRODR01_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_PaperOrder01_H paperorder01_rec = new TRN_PaperOrder01_H();

            paperorder01_rec.PPRODR01_code                  = PPRODR01_code;
            paperorder01_rec.PPRODR01_datetime              = PPRODR01_datetime;
            paperorder01_rec.PPRODR01_remarks               = PPRODR01_remarks;
            paperorder01_rec.PPRODR01_advanced_pay          = PPRODR01_advanced_pay;
            paperorder01_rec.PPRODR01_cheque_no             = PPRODR01_cheque_no;
            paperorder01_rec.PPRODR01_mo_office             = PPRODR01_mo_office;
            paperorder01_rec.PPRODR01_additional_papers     = PPRODR01_additional_papers;
            paperorder01_rec.PPRODR01_font                  = PPRODR01_font;
            paperorder01_rec.PPRODR01_gross_tot             = PPRODR01_gross_tot;
            paperorder01_rec.PPRODR01_discount_amnt         = PPRODR01_discount_amnt;
            paperorder01_rec.PPRODR01_net_tot               = PPRODR01_net_tot;
            paperorder01_rec.PPRODR01_discount_percnt       = PPRODR01_discount_percnt;
            paperorder01_rec.PPRODR01_telephone             = PPRODR01_telephone;
            paperorder01_rec.PPRODR01_train_received_by     = PPRODR01_train_received_by;
            paperorder01_rec.PPRODR01_train_received_by_nic = PPRODR01_train_received_by_nic;
            paperorder01_rec.TRAINST_id  = TRAINST_id;
            paperorder01_rec.SCHL_id     = SCHL_id;
            paperorder01_rec.DELIMETH_id = DELIMETH_id;
            paperorder01_rec.PAYTYP_id   = PAYTYP_id;
            entities.TRN_PaperOrder01_H.Add(paperorder01_rec);
            entities.SaveChanges();

            if (dispose)
            {
                entities.Dispose();
            }
            return(paperorder01_rec);
        }
コード例 #2
0
        public TRN_PaperOrder01_H Save(SchoolQPaper_entities entities, string PPRODR01_code, DateTime PPRODR01_datetime,
                                       string PPRODR01_remarks, decimal PPRODR01_advanced_pay, string PPRODR01_cheque_no, string PPRODR01_mo_office,
                                       int PPRODR01_additional_papers, string PPRODR01_font, decimal PPRODR01_gross_tot, decimal PPRODR01_discount_amnt,
                                       decimal PPRODR01_net_tot, decimal PPRODR01_discount_percnt, string PPRODR01_telephone, string PPRODR01_train_received_by,
                                       string PPRODR01_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_PaperOrder01_H paperorder01_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, PPRODR01_font);
                    MST_TrainStation_rec = new Tuple <int?, string>(trainstation_rec.TRAINST_id, trainstation_rec.TRAINST_name);
                }

                PPRODR01_code    = new Document.Document_Class().GetDocumentCode(entities, Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_O_L_Invoice);
                paperorder01_rec = new TRN_PaperOrder01_H_Class().Insert(entities,
                                                                         PPRODR01_code,
                                                                         PPRODR01_datetime,
                                                                         PPRODR01_remarks,
                                                                         PPRODR01_advanced_pay,
                                                                         PPRODR01_cheque_no,
                                                                         PPRODR01_mo_office,
                                                                         PPRODR01_additional_papers,
                                                                         PPRODR01_font,
                                                                         PPRODR01_gross_tot,
                                                                         PPRODR01_discount_amnt,
                                                                         PPRODR01_net_tot,
                                                                         PPRODR01_discount_percnt,
                                                                         PPRODR01_telephone,
                                                                         PPRODR01_train_received_by,
                                                                         PPRODR01_train_received_by_nic,
                                                                         MST_TrainStation_rec.Item1,
                                                                         SCHL_id,
                                                                         DELIMETH_id,
                                                                         PAYTYP_id);

                PaperOrderD_Recs.ForEach(r =>
                {
                    new TRN_PaperOrder01_D_Class().Insert(entities, r.PPRODR01D_paper_qty, r.PPRODR01D_ignore_qty, r.GRADE_id, r.SUBJ_id, paperorder01_rec.PPRODR01_id);
                });

                new TRN_Receivable_Class().Insert(entities,
                                                  paperorder01_rec.PPRODR01_id,
                                                  PPRODR01_net_tot,
                                                  PPRODR01_net_tot,
                                                  null,
                                                  Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_O_L_Invoice);

                if (PPRODR01_advanced_pay != 0)
                {
                    DS_Receipt DS_Receipt_Obj = new DS_Receipt();
                    DS_Receipt_Obj.OutstandingInvoices.AddOutstandingInvoicesRow(paperorder01_rec.PPRODR01_id,
                                                                                 Misc.Properties.DBs.SchoolQPaper.dbo.MST_Document.Records.Up_to_O_L_Invoice,
                                                                                 PPRODR01_code,
                                                                                 PPRODR01_advanced_pay,
                                                                                 PPRODR01_net_tot,
                                                                                 SCHL_id,
                                                                                 "",
                                                                                 "",
                                                                                 Settings.Default.CurrentFont);

                    int PayTypes_Id = DS_Receipt_Obj.PayTypes.AddPayTypesRow(PAYTYP_id,
                                                                             "",
                                                                             PPRODR01_advanced_pay,
                                                                             "",
                                                                             "").Id;

                    if (PAYTYP_id == Misc.Properties.DBs.SchoolQPaper.dbo.MST_PayType.Records.Cheque)
                    {
                        DS_Receipt_Obj.ChequeInfo.AddChequeInfoRow(PayTypes_Id,
                                                                   PPRODR01_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,
                                                                           PPRODR01_cheque_no,
                                                                           PPRODR01_mo_office);
                    }

                    new Receipt.Receipt_Class().Save(entities,
                                                     "",
                                                     PPRODR01_datetime,
                                                     PPRODR01_datetime,
                                                     PPRODR01_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(paperorder01_rec);
        }