public IHttpActionResult PutBulkUploadRef(int id, BulkUploadRef bulkUploadRef)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != bulkUploadRef.Id)
            {
                return(BadRequest());
            }

            db.Entry(bulkUploadRef).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!BulkUploadRefExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public IHttpActionResult GetBulkUploadRef(int id)
        {
            BulkUploadRef bulkUploadRef = db.BulkUploadRefs.Find(id);

            if (bulkUploadRef == null)
            {
                return(NotFound());
            }

            return(Ok(bulkUploadRef));
        }
        public void CreateUserCredentails(string UserName, int UserCreateBy, DateTime UserCreatedOn)
        {
            BulkUploadRef bulkref = new BulkUploadRef
            {
                BulkUploadId = bulkUploadId,
                CreatedBy    = UserCreateBy,
                CreatedOn    = UserCreatedOn
            };

            db.BulkUploadRefs.Add(bulkref);
            db.SaveChanges();
        }
        public IHttpActionResult PostBulkUploadRef(BulkUploadRef bulkUploadRef)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.BulkUploadRefs.Add(bulkUploadRef);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = bulkUploadRef.Id }, bulkUploadRef));
        }
        public IHttpActionResult DeleteBulkUploadRef(int id)
        {
            BulkUploadRef bulkUploadRef = db.BulkUploadRefs.Find(id);

            if (bulkUploadRef == null)
            {
                return(NotFound());
            }

            db.BulkUploadRefs.Remove(bulkUploadRef);
            db.SaveChanges();

            return(Ok(bulkUploadRef));
        }