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