/// <summary>
/// Create a new DiscrepancyDetail object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="discrepancyType">Initial value of the DiscrepancyType property.</param>
/// <param name="qty">Initial value of the Qty property.</param>
public static DiscrepancyDetail CreateDiscrepancyDetail(global::System.Int32 id, global::System.Int32 discrepancyType, global::System.Int32 qty)
{
DiscrepancyDetail discrepancyDetail = new DiscrepancyDetail();
discrepancyDetail.Id = id;
discrepancyDetail.DiscrepancyType = discrepancyType;
discrepancyDetail.Qty = qty;
return discrepancyDetail;
}
/// <summary>
/// Deprecated Method for adding a new object to the DiscrepancyDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToDiscrepancyDetails(DiscrepancyDetail discrepancyDetail)
{
base.AddObject("DiscrepancyDetails", discrepancyDetail);
}
public Constants.DB_STATUS Delete(DiscrepancyDetail discrepancyDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
public Constants.DB_STATUS Update(DiscrepancyDetail discrepancyDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
discrepancyDetailObj = inventory.DiscrepancyDetails.Where(disDetailObj => disDetailObj.Id == discrepancyDetail.Id).First();
Discrepancy disId = inventory.Discrepancies.Where(d => d.Id == discrepancyDetail.Discrepancy.Id).First();
Item item = inventory.Items.Where(i => i.Id == discrepancyDetail.Item.Id).First();
discrepancyDetailObj.Qty = discrepancyDetail.Qty;
discrepancyDetailObj.Discrepancy = disId;
discrepancyDetailObj.Item = item;
discrepancyDetailObj.DiscrepancyType = discrepancyDetail.DiscrepancyType;
discrepancyDetailObj.Qty = discrepancyDetail.Qty;
discrepancyDetailObj.Remarks = discrepancyDetail.Remarks;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
public Constants.DB_STATUS Insert(DiscrepancyDetail discrepancyDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
//disDetail = inventory.DiscrepancyDetails.Where(disDetailObj => disDetailObj.Id == discrepancyDetail.Id).FirstOrDefault();
//disDetail.ItemReference = discrepancyDetail.ItemReference;
// disDetail.Qty = discrepancyDetail.Qty;
// disDetail.Remarks = discrepancyDetail.Remarks;
try
{
inventory.AddToDiscrepancyDetails(discrepancyDetail);
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
public DiscrepancyDetail GetDiscrepancyDetail(DiscrepancyDetail discrepancyDetail)
{
discrepancyDetailObj = inventory.DiscrepancyDetails.Where(disDetailObj => disDetailObj.Id == discrepancyDetail.Id).First();
if (!discrepancyDetailObj.Equals(null))
return discrepancyDetailObj;
return null;
}
/// <summary>
/// Show the added item in the table
/// Created By:JinChengCheng
/// Created Date:26-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name="discrepancyDetail"></param>
/// <returns>The return type of this method is datatable.</returns>
public Constants.ACTION_STATUS SelectAdd(string itemId, int qty, string reason)
{
Item item = new Item();
item.Id = itemId;
item = itemBroker.GetItem(item);
if (item != null && reason != String.Empty)
{
DiscrepancyDetail dd = new DiscrepancyDetail();
//dd.Discrepancy = discrepancy;
dd.Item = item;
int amount = qty * (int)item.Cost;
if (amount >= 250)
{
dd.DiscrepancyType = Converter.objToInt(Constants.DISCREPANCY_TYPE.MANAGER);
}
else
{
dd.DiscrepancyType = Converter.objToInt(Constants.DISCREPANCY_TYPE.SUPERVISOR);
}
dd.Qty = qty;
dd.Remarks = reason;
dd.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
discrepancy.DiscrepancyDetails.Add(dd);
}
return Constants.ACTION_STATUS.SUCCESS;
}
