public HttpResponseMessage postCollectionLine(Entities.TrnCollectionLine collectionLine)
        {
            try
            {
                Data.TrnCollectionLine newCollectionLine = new Data.TrnCollectionLine();
                newCollectionLine.CollectionId = collectionLine.CollectionId;
                newCollectionLine.Amount       = collectionLine.Amount;
                newCollectionLine.PayTypeId    = collectionLine.PayTypeId;
                newCollectionLine.CheckNumber  = collectionLine.CheckNumber;
                newCollectionLine.CheckDate    = collectionLine.CheckDate;
                newCollectionLine.CheckBank    = collectionLine.CheckBank;
                newCollectionLine.CreditCardVerificationCode = collectionLine.CreditCardVerificationCode;
                newCollectionLine.CreditCardNumber           = collectionLine.CreditCardNumber;
                newCollectionLine.CreditCardType             = collectionLine.CreditCardType;
                newCollectionLine.CreditCardBank             = collectionLine.CreditCardBank;
                newCollectionLine.GiftCertificateNumber      = collectionLine.GiftCertificateNumber;
                newCollectionLine.OtherInformation           = collectionLine.OtherInformation;
                newCollectionLine.StockInId = collectionLine.StockInId;
                newCollectionLine.AccountId = collectionLine.AccountId;
                db.TrnCollectionLines.InsertOnSubmit(newCollectionLine);
                db.SubmitChanges();

                return(Request.CreateResponse(HttpStatusCode.OK));
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's wrong from the server."));
            }
        }
        public HttpResponseMessage putCollectionLine(String id, Entities.TrnCollectionLine newCollectionLine)
        {
            try
            {
                var collectionLine = from d in db.TrnCollectionLines where d.Id == Convert.ToInt32(id) select d;
                if (collectionLine.Any())
                {
                    //var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;

                    var updateCollectionLine = collectionLine.FirstOrDefault();
                    updateCollectionLine.CollectionId = newCollectionLine.CollectionId;
                    updateCollectionLine.Amount       = newCollectionLine.Amount;
                    updateCollectionLine.PayTypeId    = newCollectionLine.PayTypeId;
                    updateCollectionLine.CheckNumber  = newCollectionLine.CheckNumber;
                    updateCollectionLine.CheckDate    = newCollectionLine.CheckDate;
                    updateCollectionLine.CheckBank    = newCollectionLine.CheckBank;
                    updateCollectionLine.CreditCardVerificationCode = newCollectionLine.CreditCardVerificationCode;
                    updateCollectionLine.CreditCardNumber           = newCollectionLine.CreditCardNumber;
                    updateCollectionLine.CreditCardType             = newCollectionLine.CreditCardType;
                    updateCollectionLine.CreditCardBank             = newCollectionLine.CreditCardBank;
                    updateCollectionLine.GiftCertificateNumber      = newCollectionLine.GiftCertificateNumber;
                    updateCollectionLine.OtherInformation           = newCollectionLine.OtherInformation;
                    updateCollectionLine.StockInId = newCollectionLine.StockInId;
                    updateCollectionLine.AccountId = newCollectionLine.AccountId;
                    db.TrnCollectionLines.InsertOnSubmit(updateCollectionLine);
                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.BadRequest));
            }
        }