public Int32 insertCollectionLine(Models.TrnCollectionLine collectionLine) { try { Data.TrnCollectionLine newCollectionLine = new Data.TrnCollectionLine(); newCollectionLine.ORId = collectionLine.ORId; newCollectionLine.BranchId = collectionLine.BranchId; newCollectionLine.AccountId = collectionLine.AccountId; newCollectionLine.ArticleId = collectionLine.ArticleId; newCollectionLine.SIId = collectionLine.SIId; newCollectionLine.Particulars = collectionLine.Particulars; newCollectionLine.Amount = collectionLine.Amount; newCollectionLine.PayTypeId = collectionLine.PayTypeId; newCollectionLine.CheckNumber = collectionLine.CheckNumber; newCollectionLine.CheckDate = Convert.ToDateTime(collectionLine.CheckDate); newCollectionLine.CheckBank = collectionLine.CheckBank; newCollectionLine.DepositoryBankId = collectionLine.DepositoryBankId; newCollectionLine.IsClear = collectionLine.IsClear; db.TrnCollectionLines.InsertOnSubmit(newCollectionLine); db.SubmitChanges(); return(newCollectionLine.Id); } catch { return(0); } }
public HttpResponseMessage updateCollectionLine(String id, Models.TrnCollectionLine collectionLine) { try { var collectionLines = from d in db.TrnCollectionLines where d.Id == Convert.ToInt32(id) select d; if (collectionLines.Any()) { var updateCollectionLine = collectionLines.FirstOrDefault(); updateCollectionLine.ORId = collectionLine.ORId; updateCollectionLine.BranchId = collectionLine.BranchId; updateCollectionLine.AccountId = collectionLine.AccountId; updateCollectionLine.ArticleId = collectionLine.ArticleId; updateCollectionLine.SIId = collectionLine.SIId; updateCollectionLine.Particulars = collectionLine.Particulars; updateCollectionLine.Amount = collectionLine.Amount; updateCollectionLine.PayTypeId = collectionLine.PayTypeId; updateCollectionLine.CheckNumber = collectionLine.CheckNumber; updateCollectionLine.CheckDate = Convert.ToDateTime(collectionLine.CheckDate); updateCollectionLine.CheckBank = collectionLine.CheckBank; updateCollectionLine.DepositoryBankId = collectionLine.DepositoryBankId; updateCollectionLine.IsClear = collectionLine.IsClear; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }