public int Post(Models.ProductPackage value)
        {
            try
            {
                Data.MstProductPackage NewProductPackage = new Data.MstProductPackage();

                NewProductPackage.ProductPackage = value.ProductPackageDescription;
                NewProductPackage.SKU = value.SKU;
                NewProductPackage.Price = value.Price;
                NewProductPackage.ProductId = value.ProductId;
                NewProductPackage.IsAvailable = value.IsAvailable;
                NewProductPackage.WithCoupon = value.WithCoupon;
                NewProductPackage.WithSoftware = value.WithSoftware;
                NewProductPackage.IsReoccuring = value.IsReoccuring;
                NewProductPackage.Particulars = value.Particulars;
                NewProductPackage.PackageURL = value.PackageURL;
                NewProductPackage.ProductPackageGroup = value.ProductPackageGroup;

                db.MstProductPackages.InsertOnSubmit(NewProductPackage);
                db.SubmitChanges();

                return NewProductPackage.Id;
            }
            catch
            {
                return 0;
            }
        }
        public HttpResponseMessage Put(Models.ProductPackage value)
        {
            string id = Convert.ToString(value.Id).Replace(",", "");
            int Id = Convert.ToInt32(id);

            try
            {
                //var Sales = from d in db.TrnSales where d.Id == Id select d;
                var ProductPackage = from d in db.MstProductPackages where d.Id == Id select d;

                if (ProductPackage.Any())
                {

                    var UpdatedProductPackage = ProductPackage.FirstOrDefault();

                    UpdatedProductPackage.ProductPackage = value.ProductPackageDescription;
                    UpdatedProductPackage.SKU = value.SKU;
                    UpdatedProductPackage.Price = value.Price;
                    UpdatedProductPackage.ProductId = value.ProductId;
                    UpdatedProductPackage.IsAvailable = value.IsAvailable;
                    UpdatedProductPackage.WithCoupon = value.WithCoupon;
                    UpdatedProductPackage.WithSoftware = value.WithSoftware;
                    UpdatedProductPackage.IsReoccuring = value.IsReoccuring;
                    UpdatedProductPackage.Particulars = value.Particulars;
                    UpdatedProductPackage.PackageURL = value.PackageURL;
                    UpdatedProductPackage.ProductPackageGroup = value.ProductPackageGroup;

                    db.SubmitChanges();
                }
                else
                {
                    return Request.CreateResponse(HttpStatusCode.NotFound);
                }
                return Request.CreateResponse(HttpStatusCode.OK);
            }
            catch (NullReferenceException)
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest);
            }
        }