コード例 #1
0
        public HttpResponseMessage updateJournalVoucherLine(String id, Models.TrnJournalVoucherLine journalVoucherLine)
        {
            try
            {
                var journalVoucherLines = from d in db.TrnJournalVoucherLines where d.Id == Convert.ToInt32(id) select d;
                if (journalVoucherLines.Any())
                {
                    var updatejournalVoucherLine = journalVoucherLines.FirstOrDefault();
                    updatejournalVoucherLine.JVId         = journalVoucherLine.JVId;
                    updatejournalVoucherLine.BranchId     = journalVoucherLine.BranchId;
                    updatejournalVoucherLine.AccountId    = journalVoucherLine.AccountId;
                    updatejournalVoucherLine.ArticleId    = journalVoucherLine.ArticleId;
                    updatejournalVoucherLine.Particulars  = journalVoucherLine.Particulars;
                    updatejournalVoucherLine.DebitAmount  = journalVoucherLine.DebitAmount;
                    updatejournalVoucherLine.CreditAmount = journalVoucherLine.CreditAmount;
                    updatejournalVoucherLine.APRRId       = journalVoucherLine.APRRId;
                    updatejournalVoucherLine.ARSIId       = journalVoucherLine.ARSIId;
                    updatejournalVoucherLine.IsClear      = journalVoucherLine.IsClear;

                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound));
                }
            }
            catch
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest));
            }
        }
コード例 #2
0
        public Int32 insertJournalVoucherLine(Models.TrnJournalVoucherLine journalVoucherLine)
        {
            try
            {
                Data.TrnJournalVoucherLine newJournalVoucherLine = new Data.TrnJournalVoucherLine();
                newJournalVoucherLine.JVId         = journalVoucherLine.JVId;
                newJournalVoucherLine.BranchId     = journalVoucherLine.BranchId;
                newJournalVoucherLine.AccountId    = journalVoucherLine.AccountId;
                newJournalVoucherLine.ArticleId    = journalVoucherLine.ArticleId;
                newJournalVoucherLine.Particulars  = journalVoucherLine.Particulars;
                newJournalVoucherLine.DebitAmount  = journalVoucherLine.DebitAmount;
                newJournalVoucherLine.CreditAmount = journalVoucherLine.CreditAmount;
                newJournalVoucherLine.APRRId       = journalVoucherLine.APRRId;
                newJournalVoucherLine.ARSIId       = journalVoucherLine.ARSIId;
                newJournalVoucherLine.IsClear      = journalVoucherLine.IsClear;

                db.TrnJournalVoucherLines.InsertOnSubmit(newJournalVoucherLine);
                db.SubmitChanges();

                return(newJournalVoucherLine.Id);
            }
            catch
            {
                return(0);
            }
        }