コード例 #1
0
        public void saveGridData(string InvoiceNo, string JobCode, DateTime InvoiceDate, DateTime LastTransDate, decimal Amount, int AcJournalID, int AcOPInvoiceMasterId)
        {
            //save data in acjournalDetails
            AcJournalDetail acjournalDetailsDR = new AcJournalDetail();

            acjournalDetailsDR.AcJournalID       = AcJournalID;
            acjournalDetailsDR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails();
            //if(CustomerHeadID==0)
            //{
            //    acjournalDetailsDR.AcHeadID =SupplierHeadId;
            //}
            //if (SupplierHeadId == 0)
            //{
            //    acjournalDetailsDR.AcHeadID = CustomerHeadID;
            //}
            acjournalDetailsDR.BranchID = Convert.ToInt32(Session["branchid"]);
            acjournalDetailsDR.PartyID  = Convert.ToInt32(Session["AcCompanyID"]);

            acjournalDetailsDR.Amount = (-1) * Convert.ToDecimal(Amount);

            entity.AcJournalDetails.Add(acjournalDetailsDR);
            entity.SaveChanges();



            AcJournalDetail acjournalDetailsCR = new AcJournalDetail();

            acjournalDetailsCR.AcJournalID       = AcJournalID;
            acjournalDetailsCR.AcJournalDetailID = objectSourceModel.GetMaxNumberAcJournalDetails();
            //if (CustomerHeadID == 0)
            //{
            //    acjournalDetailsDR.AcHeadID = SupplierHeadId;
            //}
            //if (SupplierHeadId == 0)
            //{
            //    acjournalDetailsDR.AcHeadID = CustomerHeadID;
            //}
            acjournalDetailsDR.BranchID = Convert.ToInt32(Session["branchid"]);
            acjournalDetailsDR.PartyID  = Convert.ToInt32(Session["AcCompanyID"]);
            acjournalDetailsCR.Amount   = Convert.ToDecimal(Amount);

            entity.AcJournalDetails.Add(acjournalDetailsCR);
            entity.SaveChanges();
            //save data in acopInvoiceDetails

            AcOPInvoiceDetail acOPInvoiceDetails = new AcOPInvoiceDetail();

            acOPInvoiceDetails.AcOPInvoiceDetailID = objectSourceModel.GetMaxNumberAcOpeningInvoiceDetails();
            acOPInvoiceDetails.StatusClose         = false;
            acOPInvoiceDetails.LastTransDate       = LastTransDate;
            acOPInvoiceDetails.JobCode             = JobCode;
            acOPInvoiceDetails.InvoiceNo           = InvoiceNo;
            acOPInvoiceDetails.InvoiceDate         = InvoiceDate;
            acOPInvoiceDetails.Amount              = Amount;
            acOPInvoiceDetails.AcJournalID         = AcJournalID;
            acOPInvoiceDetails.AcOPInvoiceMasterID = AcOPInvoiceMasterId;
            entity.AcOPInvoiceDetails.Add(acOPInvoiceDetails);
            entity.SaveChanges();
        }