public void delivery_adjust(int disb_id, string cat, string description, int quantity, string type) { var categ = (from m in cntxt.Categories where m.Category_Name == cat select m).First<Category>(); var item = (from m in cntxt.Stock_Item where m.CategoryID == categ.CategoryID select m).First<Stock_Item>(); var disb = (from m in cntxt.Disbursements where m.DisbursementID == disb_id select m).First<Disbursement>(); var disb_det = (from m in cntxt.DisbursementDetails where m.Item_Code == item.Item_Code && m.DisbursementID == disb_id select m).First<DisbursementDetail>(); disb_det.Alloted = disb_det.Alloted - quantity; disb_det.Pending_Qty = disb_det.Pending_Qty + quantity; disb_det.Outstanding_Type = "pending"; disb.Dispatch_Status = "pending"; Acknowledgement ack = new Acknowledgement { Adjustment_Date = DateTime.Now, Item_Code = item.Item_Code, Quantity = quantity, Reason = type }; cntxt.AddToAcknowledgements(ack); cntxt.SaveChanges(); }
/// <summary> /// Deprecated Method for adding a new object to the Acknowledgements EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToAcknowledgements(Acknowledgement acknowledgement) { base.AddObject("Acknowledgements", acknowledgement); }
/// <summary> /// Create a new Acknowledgement object. /// </summary> /// <param name="adjustmentID">Initial value of the AdjustmentID property.</param> /// <param name="adjustment_Date">Initial value of the Adjustment_Date property.</param> /// <param name="item_Code">Initial value of the Item_Code property.</param> /// <param name="quantity">Initial value of the Quantity property.</param> /// <param name="reason">Initial value of the Reason property.</param> public static Acknowledgement CreateAcknowledgement(global::System.Int32 adjustmentID, global::System.DateTime adjustment_Date, global::System.String item_Code, global::System.Int32 quantity, global::System.String reason) { Acknowledgement acknowledgement = new Acknowledgement(); acknowledgement.AdjustmentID = adjustmentID; acknowledgement.Adjustment_Date = adjustment_Date; acknowledgement.Item_Code = item_Code; acknowledgement.Quantity = quantity; acknowledgement.Reason = reason; return acknowledgement; }