private void GetAdjustStockData(int adjustStockID)
{
INVAdjustStockPrimaryKey pk = new INVAdjustStockPrimaryKey();
pk.AdjustStockID = adjustStockID;
_adjustStock = _adjustStockWrapper.SelectOne(pk);
}
public bool DeleteAdjustStock(int id)
{
bool deleted = false;
try
{
INVAdjustStockCollection ajustStockCollection = new INVAdjustStockCollection();
INVAdjustStock _adjustNewStock = new INVAdjustStock();
INVAdjustStock _adjustOldStock = new INVAdjustStock();
INVAdjustStockPrimaryKey pk = new INVAdjustStockPrimaryKey();
pk.AdjustStockID = id;
_adjustNewStock = SelectOne(pk);
_adjustOldStock = SelectOne(pk);
INVAdjustStock _EditNewAdjustStock = _adjustNewStock;
_EditNewAdjustStock.Qty *= -1;
ajustStockCollection.Add(_EditNewAdjustStock);
INVAdjustStock _EditOldAdjustStock = _adjustOldStock;
_EditOldAdjustStock.StockTypeID = _adjustOldStock.OldStockTypeID;
ajustStockCollection.Add(_EditOldAdjustStock);
POS.DataLayer.INVAdjustStock adjustStockEntity = new DataLayer.INVAdjustStock();
deleted = adjustStockEntity.DeleteTransaction(id, GetAdjustStockFromBLLayer(ajustStockCollection));
}
catch (Exception ex)
{
throw ex;
}
return(deleted);
}
/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class INVAdjustStock in the form of object of INVAdjustStockCollection </returns>
public INVAdjustStockCollection SelectAll()
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAll())
{
_iNVAdjustStockWCF = new INVAdjustStock();
_iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID;
_iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID;
_iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID;
_iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty;
_iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID;
_iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy;
_iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate;
_iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy;
_iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return iNVAdjustStockCollection;
}
private void Search()
{
dgrid_Result.DataSource = null;
INVAdjustStock searchModel = new INVAdjustStock();
searchModel.ProductName = tbx_ProductName.Text != "" ? tbx_ProductName.Text : null;
searchModel.InventoryName = tbx_InventoryName.Text != "" ? tbx_InventoryName.Text : null;
searchModel.StockTypeName = tbx_StockTypeName.Text != "" ? tbx_StockTypeName.Text : null;
searchModel.AdjustReasonName = tbx_AdjustName.Text != "" ? tbx_AdjustName.Text : null;
List <INVAdjustStock> adjustStocks = _invAdjustStockWrapper.SearchByCriteria(searchModel);
dgrid_Result.DataSource = adjustStocks;
}
public List<INVAdjustStock> SearchByCriteria(INVAdjustStock SearchModel,DateTime? dateFrom = null,DateTime? toFrom = null)
{
List<INVAdjustStock> resultList = new List<INVAdjustStock>();
try
{
resultList = (from item in SelectAll()
join product in productService.SelectAll() on item.ProductID equals product.ProductID
join invt in invinventoryService.SelectAll() on item.InventoryID equals invt.InventoryID
join aRes in invAdjustStockReasonService.SelectAll() on item.AdjustReasonID equals aRes.AdjustStockReasonID
join sType in invStockTypeService.SelectAll() on item.StockTypeID equals sType.StockTypeID
join oldSType in invStockTypeService.SelectAll() on item.OldStockTypeID equals oldSType.StockTypeID
join usr in aduserService.SelectAll() on item.CreatedBy equals usr.UserID
where
(
SearchModel.InventoryID == null || item.InventoryID == SearchModel.InventoryID
&&
SearchModel.AdjustReasonID == null || item.AdjustReasonID == SearchModel.AdjustReasonID
&&
item.CredateDate >= dateFrom.Value
&&
item.CredateDate <= toFrom.Value
)
select new INVAdjustStock()
{
AdjustReasonID = item.AdjustReasonID,
AdjustStockID = item.AdjustStockID,
BatchID = item.BatchID,
CreatedBy = item.CreatedBy,
CreatedByName = usr.UserName,
CredateDate = item.CredateDate,
InventoryID = item.InventoryID,
ProductID = item.ProductID,
ProductName = product.ProductName,
Qty = item.Qty,
StockTypeID = item.StockTypeID,
UpdateDate = item.UpdateDate,
UpdatedBy = item.UpdatedBy,
OldStockTypeName = oldSType.StockTypeName,
StockTypeName = sType.StockTypeName,
InventoryName = invt.InventoryName,
AdjustReasonName = aRes.AdjustStockreasonName
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return resultList;
}
public FrmAdjustStockAddEdit(FrmAdjustmentSearch frmAdjustmentSearch)
{
InitializeComponent();
this._invProductStockWrapper = new INVProductStockWrapper();
this._inventoryWrapper = new INVInventoryWrapper();
this._stockTypeWrapper = new INVStockTypeWrapper();
this._adjustStockReasonWrapper = new INVAdjustStockReasonWrapper();
this._adjustStockWrapper = new INVAdjustStockWrapper();
this._adjustStock = new INVAdjustStock();
this._ProductWrapper = new BDProductWrapper();
this._adjustStockCollection = new INVAdjustStockCollection();
this._isEdit = false;
this._frmAdjustmentSearch = frmAdjustmentSearch;
}
public List <INVAdjustStock> SearchByCriteria(INVAdjustStock SearchModel, DateTime?dateFrom = null, DateTime?toFrom = null)
{
List <INVAdjustStock> resultList = new List <INVAdjustStock>();
try
{
resultList = (from item in SelectAll()
join product in productService.SelectAll() on item.ProductID equals product.ProductID
join invt in invinventoryService.SelectAll() on item.InventoryID equals invt.InventoryID
join aRes in invAdjustStockReasonService.SelectAll() on item.AdjustReasonID equals aRes.AdjustStockReasonID
join sType in invStockTypeService.SelectAll() on item.StockTypeID equals sType.StockTypeID
join oldSType in invStockTypeService.SelectAll() on item.OldStockTypeID equals oldSType.StockTypeID
join usr in aduserService.SelectAll() on item.CreatedBy equals usr.UserID
where
(
SearchModel.InventoryID == null || item.InventoryID == SearchModel.InventoryID
&&
SearchModel.AdjustReasonID == null || item.AdjustReasonID == SearchModel.AdjustReasonID
&&
item.CredateDate >= dateFrom.Value
&&
item.CredateDate <= toFrom.Value
)
select new INVAdjustStock()
{
AdjustReasonID = item.AdjustReasonID,
AdjustStockID = item.AdjustStockID,
BatchID = item.BatchID,
CreatedBy = item.CreatedBy,
CreatedByName = usr.UserName,
CredateDate = item.CredateDate,
InventoryID = item.InventoryID,
ProductID = item.ProductID,
ProductName = product.ProductName,
Qty = item.Qty,
StockTypeID = item.StockTypeID,
UpdateDate = item.UpdateDate,
UpdatedBy = item.UpdatedBy,
OldStockTypeName = oldSType.StockTypeName,
StockTypeName = sType.StockTypeName,
InventoryName = invt.InventoryName,
AdjustReasonName = aRes.AdjustStockreasonName
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(resultList);
}
public FrmAdjustStockAddEdit(int id, FrmAdjustmentSearch frmAdjustmentSearch)
{
InitializeComponent();
this._invProductStockWrapper = new INVProductStockWrapper();
this._inventoryWrapper = new INVInventoryWrapper();
this._stockTypeWrapper = new INVStockTypeWrapper();
this._adjustStockReasonWrapper = new INVAdjustStockReasonWrapper();
this._adjustStockWrapper = new INVAdjustStockWrapper();
this._adjustStock = new INVAdjustStock();
this._ProductWrapper = new BDProductWrapper();
this._isEdit = true;
this._adjustStockID = id;
GetAdjustStockData(_adjustStockID.Value);
this._frmAdjustmentSearch = frmAdjustmentSearch;
}
public List <INVAdjustStock> SearchByCriteria(INVAdjustStock SearchModel)
{
List <INVAdjustStock> resultList = new List <INVAdjustStock>();
try
{
resultList = (from item in SelectAll()
join product in productService.SelectAll() on item.ProductID equals product.ProductID
join invt in invinventoryService.SelectAll() on item.InventoryID equals invt.InventoryID
join aRes in invAdjustStockReasonService.SelectAll() on item.AdjustReasonID equals aRes.AdjustStockReasonID
join sType in invStockTypeService.SelectAll() on item.StockTypeID equals sType.StockTypeID
join usr in aduserService.SelectAll() on item.CreatedBy equals usr.UserID
where
(
string.IsNullOrEmpty(SearchModel.AdjustReasonName) || aRes.AdjustStockreasonName.Contains(SearchModel.AdjustReasonName)
&&
string.IsNullOrEmpty(SearchModel.ProductName) || product.ProductName.Contains(SearchModel.ProductName)
&&
string.IsNullOrEmpty(SearchModel.InventoryName) || invt.InventoryName.Contains(SearchModel.InventoryName)
&&
string.IsNullOrEmpty(SearchModel.StockTypeName) || sType.StockTypeName.Contains(SearchModel.StockTypeName)
)
select new INVAdjustStock()
{
AdjustReasonID = item.AdjustReasonID,
AdjustStockID = item.AdjustStockID,
BatchID = item.BatchID,
CreatedBy = item.CreatedBy,
CreatedByName = usr.UserName,
CredateDate = item.CredateDate,
InventoryID = item.InventoryID,
ProductID = item.ProductID,
ProductName = product.ProductName,
Qty = item.Qty,
StockTypeID = item.StockTypeID,
UpdateDate = item.UpdateDate,
UpdatedBy = item.UpdatedBy,
StockTypeName = sType.StockTypeName,
InventoryName = invt.InventoryName,
AdjustReasonName = aRes.AdjustStockreasonName
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(resultList);
}
private void Search()
{
dgrid_Result.DataSource = null;
INVAdjustStock searchModel = new INVAdjustStock();
int AdjustReasonID = 0;
int InventoryID = 0;
DateTime? dateFrom = null;
DateTime? toFrom = null;
if (cbx_AdjustReason.SelectedValue != null)
{
int.TryParse(cbx_AdjustReason.SelectedValue.ToString(), out AdjustReasonID);
searchModel.AdjustReasonID = AdjustReasonID;
}
if (cbx_Store.SelectedValue != null)
{
int.TryParse(cbx_Store.SelectedValue.ToString(), out InventoryID);
searchModel.InventoryID = InventoryID;
}
if (dtp_fromDate.Value != null)
{
dateFrom = dtp_fromDate.Value;
}
if (dtp_toDate.Value != null)
{
toFrom = dtp_toDate.Value;
}
if (toFrom == null || dateFrom == null || toFrom < dateFrom)
{
MessageBox.Show("يجب اختيار فترة زمنية صحيحة");
return;
}
List <INVAdjustStock> adjustStocks = _invAdjustStockWrapper.SearchByCriteria(searchModel, dateFrom, toFrom);
dgrid_Result.DataSource = adjustStocks;
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="INVAdjustStockPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVAdjustStock</returns>
public INVAdjustStock SelectOne(INVAdjustStockPrimaryKey pk)
{
_iNVAdjustStockWCF = new INVAdjustStock();
_iNVAdjustStock = POS.DataLayer.INVAdjustStockBase.SelectOne(new POS.DataLayer.INVAdjustStockPrimaryKey(pk.AdjustStockID));
_iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID;
_iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID;
_iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID;
_iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty;
_iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID;
_iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy;
_iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate;
_iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy;
_iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
return _iNVAdjustStockWCF;
}
/// <summary>
/// This method will insert one new row into the database using the property Information
/// </summary>
///
/// <param name="iNVAdjustStock" type="INVAdjustStock">This INVAdjustStock will be inserted in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Insert(INVAdjustStock iNVAdjustStock)
{
_iNVAdjustStock = new POS.DataLayer.INVAdjustStock();
_iNVAdjustStock.AdjustStockID=iNVAdjustStock.AdjustStockID;
_iNVAdjustStock.ProductID=iNVAdjustStock.ProductID;
_iNVAdjustStock.BatchID=iNVAdjustStock.BatchID;
_iNVAdjustStock.Qty=iNVAdjustStock.Qty;
_iNVAdjustStock.AdjustReasonID=iNVAdjustStock.AdjustReasonID;
_iNVAdjustStock.CreatedBy=iNVAdjustStock.CreatedBy;
_iNVAdjustStock.CredateDate=iNVAdjustStock.CredateDate;
_iNVAdjustStock.UpdatedBy=iNVAdjustStock.UpdatedBy;
_iNVAdjustStock.UpdateDate=iNVAdjustStock.UpdateDate;
_iNVAdjustStock.StockTypeID=iNVAdjustStock.StockTypeID;
_iNVAdjustStock.OldStockTypeID=iNVAdjustStock.OldStockTypeID;
_iNVAdjustStock.InventoryID=iNVAdjustStock.InventoryID;
_iNVAdjustStock.ExpiryDate=iNVAdjustStock.ExpiryDate;
_iNVAdjustStock.BatchNumber=iNVAdjustStock.BatchNumber;
return _iNVAdjustStock.Insert();
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table.
/// </summary>
///
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
///
/// <returns>list of objects of class INVAdjustStock in the form of an object of class INVAdjustStockCollection </returns>
public INVAdjustStockCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAllPaged(pageSize, skipPages, orderByStatement))
{
_iNVAdjustStockWCF = new INVAdjustStock();
_iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID;
_iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID;
_iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID;
_iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty;
_iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID;
_iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy;
_iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate;
_iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy;
_iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return iNVAdjustStockCollection;
}
new private bool Validate()
{
bool isValid = false;
bool isValidProduct = false;
int ProductID = 0;
int? oldStockTypeId = dgrid_stock.SelectedRows.Count > 0 ? int.Parse(dgrid_stock.SelectedRows[0].Cells["col_StockTypeID"].Value.ToString()) : 0;
string BatchID = dgrid_batches.SelectedRows.Count > 0 ? dgrid_batches.SelectedRows[0].Cells["col_batch"].Value.ToString() : "";
DateTime?ExpiryDate = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDateTime(dgrid_batches.SelectedRows[0].Cells["col_expiry"].Value.ToString()) : (DateTime?)null;
decimal oldQty = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDecimal(dgrid_batches.SelectedRows[0].Cells["col_batchQty"].Value.ToString()) : Convert.ToDecimal(dgrid_stock.SelectedRows[0].Cells["col_qty"].Value.ToString());
int AdjustReasonID = 0;
int StockTypeID = 0;
int InventoryID = 0;
decimal Qty = num_Qty.Value;
int.TryParse(dgrid_stock.SelectedRows[0].Cells["col_invProductStock"].Value.ToString(), out ProductID);
int.TryParse(cbx_AdjustReason.SelectedValue.ToString(), out AdjustReasonID);
int.TryParse(cbx_StockTypeTO.SelectedValue.ToString(), out StockTypeID);
int.TryParse(cbx_Store.SelectedValue.ToString(), out InventoryID);
if (ProductID > 0)
{
isValidProduct = true;
BDProductPrimaryKey pk = new BDProductPrimaryKey();
pk.ProductID = ProductID;
if (_ProductWrapper.SelectOne(pk).IsAcceptBatch == true)
{
isValidProduct = (!string.IsNullOrEmpty(BatchID) && ExpiryDate.HasValue);
}
}
if (!isValidProduct || AdjustReasonID == 0 || StockTypeID == 0 || InventoryID == 0 || Qty == 0 || Qty > oldQty || oldStockTypeId == StockTypeID)
{
isValid = false;
}
else
{
isValid = true;
if (_isEdit)
{
INVAdjustStock _EditNewAdjustStock = _adjustStock;
_EditNewAdjustStock.Qty *= -1;
_adjustStockCollection.Add(_EditNewAdjustStock);
INVAdjustStock _EditOldAdjustStock = _adjustStock;
_adjustStock.StockTypeID = _adjustStock.OldStockTypeID;
_adjustStockCollection.Add(_EditOldAdjustStock);
}
_adjustStock.ProductID = ProductID;
_adjustStock.AdjustReasonID = AdjustReasonID;
_adjustStock.AdjustStockID = _adjustStockID;
_adjustStock.BatchID = null;
_adjustStock.InventoryID = InventoryID;
_adjustStock.StockTypeID = StockTypeID;
_adjustStock.OldStockTypeID = oldStockTypeId;
_adjustStock.Qty = Qty;
_adjustStock.BatchNumber = BatchID;
_adjustStock.ExpiryDate = ExpiryDate;
if (_isEdit)
{
_adjustStock.UpdateDate = DateTime.Now;
_adjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID;
}
else
{
_adjustStock.CredateDate = DateTime.Now;
_adjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
}
INVAdjustStock _oldAdjustStock = new INVAdjustStock();
_oldAdjustStock.ProductID = ProductID;
_oldAdjustStock.AdjustReasonID = AdjustReasonID;
_oldAdjustStock.AdjustStockID = _adjustStockID;
_oldAdjustStock.BatchID = null;
_oldAdjustStock.InventoryID = InventoryID;
_oldAdjustStock.StockTypeID = oldStockTypeId;
_oldAdjustStock.Qty = (-1 * Qty);
_oldAdjustStock.BatchNumber = BatchID;
_oldAdjustStock.ExpiryDate = ExpiryDate;
if (_isEdit)
{
_oldAdjustStock.UpdateDate = DateTime.Now;
_oldAdjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID;
}
else
{
_oldAdjustStock.CredateDate = DateTime.Now;
_oldAdjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
}
_adjustStockCollection.Add(_oldAdjustStock);
}
return(isValid);
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table
/// using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class INVAdjustStock</param>
/// <param name="fieldValue" type="object">Value for the field specified.</param>
/// <param name="fieldValue2" type="object">Value for the field specified.</param>
/// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
///
/// <returns>List of object of class INVAdjustStock in the form of an object of class INVAdjustStockCollection</returns>
public INVAdjustStockCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection();
foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_iNVAdjustStockWCF = new INVAdjustStock();
_iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID;
_iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID;
_iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID;
_iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty;
_iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID;
_iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy;
_iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate;
_iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy;
_iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate;
_iNVAdjustStockWCF.StockTypeID = _iNVAdjustStock.StockTypeID;
_iNVAdjustStockWCF.OldStockTypeID = _iNVAdjustStock.OldStockTypeID;
_iNVAdjustStockWCF.InventoryID = _iNVAdjustStock.InventoryID;
_iNVAdjustStockWCF.ExpiryDate = _iNVAdjustStock.ExpiryDate;
_iNVAdjustStockWCF.BatchNumber = _iNVAdjustStock.BatchNumber;
iNVAdjustStockCollection.Add(_iNVAdjustStockWCF);
}
return iNVAdjustStockCollection;
}
///<summary>
/// This method will update one new row into the database using the property Information
/// </summary>
///
/// <param name="iNVAdjustStock" type="INVAdjustStock">This INVAdjustStock will be updated in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Update(INVAdjustStock iNVAdjustStock)
{
_iNVAdjustStock=POS.DataLayer.INVAdjustStock.SelectOne(new POS.DataLayer.INVAdjustStockPrimaryKey(iNVAdjustStock.AdjustStockID));
_iNVAdjustStock.ProductID=iNVAdjustStock.ProductID;
_iNVAdjustStock.BatchID=iNVAdjustStock.BatchID;
_iNVAdjustStock.Qty=iNVAdjustStock.Qty;
_iNVAdjustStock.AdjustReasonID=iNVAdjustStock.AdjustReasonID;
_iNVAdjustStock.CreatedBy=iNVAdjustStock.CreatedBy;
_iNVAdjustStock.CredateDate=iNVAdjustStock.CredateDate;
_iNVAdjustStock.UpdatedBy=iNVAdjustStock.UpdatedBy;
_iNVAdjustStock.UpdateDate=iNVAdjustStock.UpdateDate;
_iNVAdjustStock.StockTypeID=iNVAdjustStock.StockTypeID;
_iNVAdjustStock.OldStockTypeID=iNVAdjustStock.OldStockTypeID;
_iNVAdjustStock.InventoryID=iNVAdjustStock.InventoryID;
_iNVAdjustStock.ExpiryDate=iNVAdjustStock.ExpiryDate;
_iNVAdjustStock.BatchNumber=iNVAdjustStock.BatchNumber;
return _iNVAdjustStock.Update();
}
public bool DeleteAdjustStock(int id)
{
bool deleted = false;
try
{
INVAdjustStockCollection ajustStockCollection = new INVAdjustStockCollection();
INVAdjustStock _adjustNewStock = new INVAdjustStock();
INVAdjustStock _adjustOldStock = new INVAdjustStock();
INVAdjustStockPrimaryKey pk = new INVAdjustStockPrimaryKey();
pk.AdjustStockID = id;
_adjustNewStock = SelectOne(pk);
_adjustOldStock = SelectOne(pk);
INVAdjustStock _EditNewAdjustStock = _adjustNewStock;
_EditNewAdjustStock.Qty *= -1;
ajustStockCollection.Add(_EditNewAdjustStock);
INVAdjustStock _EditOldAdjustStock = _adjustOldStock;
_EditOldAdjustStock.StockTypeID = _adjustOldStock.OldStockTypeID;
ajustStockCollection.Add(_EditOldAdjustStock);
POS.DataLayer.INVAdjustStock adjustStockEntity = new DataLayer.INVAdjustStock();
deleted = adjustStockEntity.DeleteTransaction(id, GetAdjustStockFromBLLayer(ajustStockCollection));
}
catch (Exception ex)
{
throw ex;
}
return deleted;
}
