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;
}
