//Update Adjustmentdetail
        public static AdjustmentDetailModel UpdateAdjustmentDetail(AdjustmentDetailModel adjdm, out string error)
        {
            error = "";
            LUSSISEntities   entities = new LUSSISEntities();
            adjustmentdetail adjd     = new adjustmentdetail();

            try
            {
                adjd = entities.adjustmentdetails.Where(a => a.adjid == adjdm.Adjid && a.itemid == adjdm.Itemid).First <adjustmentdetail>();
                //adjd.adjid = adjdm.adjid;
                //adjd.itemid = adjdm.itemid;
                adjd.reason      = adjdm.Reason;
                adjd.adjustedqty = adjdm.Adjustedqty;

                entities.SaveChanges();
                adjdm = GetAdjustDetailByItemandAdjustID(adjd.itemid, adjd.adjid, out error);
            }
            catch (NullReferenceException)
            {
                error = ConError.Status.NOTFOUND;
            }
            catch (Exception e)
            {
                error = e.Message;
            }
            return(adjdm);
        }
        public static AdjustmentDetailModel UpdateAdjustmentDetail(string token, AdjustmentDetailModel ajm, out string error)
        {
            error = "";
            string url          = APIHelper.Baseurl + "/adjustment/detail/update";
            string objectstring = JsonConvert.SerializeObject(ajm);

            ajm = APIHelper.Execute <AdjustmentDetailModel>(token, objectstring, url, out error);
            return(ajm);
        }
        public IHttpActionResult UpdateAdjustmentDetail(AdjustmentDetailModel adjd)
        {
            string error = "";
            AdjustmentDetailModel adjdm = AdjustmentDetailRepo.UpdateAdjustmentDetail(adjd, out error);

            if (error != "" || adjdm == null)
            {
                if (error == ConError.Status.NOTFOUND)
                {
                    return(Content(HttpStatusCode.NotFound, "Adjustment detail is Not Found"));
                }
                return(Content(HttpStatusCode.BadRequest, error));
            }
            return(Ok(adjdm));
        }
        //Get All adjustments by item id & adjustment id
        public static AdjustmentDetailModel GetAdjustDetailByItemandAdjustID(int itemid, int adjid, out string error)
        {
            error = "";
            LUSSISEntities        entities = new LUSSISEntities();
            AdjustmentDetailModel adjdm    = new AdjustmentDetailModel();

            try
            {
                adjustmentdetail adjd = entities.adjustmentdetails.Where(a => a.itemid == itemid && a.adjid == adjid).First <adjustmentdetail>();
                adjdm = ConvertDBtoAPIAdjustDetail(adjd);
            }
            catch (NullReferenceException)
            {
                error = ConError.Status.NOTFOUND;
            }
            catch (Exception e)
            {
                error = e.Message;
            }
            return(adjdm);
        }
        //Changed from DB to APIModel
        public static AdjustmentDetailModel ConvertDBtoAPIAdjustDetail(adjustmentdetail adjd)
        {
            AdjustmentDetailModel adjdm = new AdjustmentDetailModel(adjd.adjid, adjd.itemid, adjd.item.description, adjd.adjustedqty, adjd.reason, adjd.item.category.name, adjd.item.uom);

            return(adjdm);
        }