private void search()
{
INVTransferHeader invtransferHeader = new INVTransferHeader();
//invtransferHeader.CreateDate = dtb_Date.Value;
int fromInv = 0, toInv = 0;
if (cbx_StoreFrom.SelectedValue != null)
{
int.TryParse(cbx_StoreFrom.SelectedValue.ToString(), out fromInv);
}
if (cbx_StoreTo.SelectedValue != null)
{
int.TryParse(cbx_StoreTo.SelectedValue.ToString(), out toInv);
}
if (fromInv > 0)
{
invtransferHeader.FromInventoryID = fromInv;
}
if (toInv > 0)
{
invtransferHeader.ToInventoryID = toInv;
}
if (string.IsNullOrEmpty(tbx_OrderSerial.Text))
{
invtransferHeader.InvoiceNumber = tbx_OrderSerial.Text;
}
InitiateGrid(invtransferHeader);
}
/////
public bool SaveTransferOrder(INVTransferHeader transferHeader, INVTransferLineCollection sALSalesLineCollection)
{
POS.DataLayer.INVTransferHeader _transferHeader = new POS.DataLayer.INVTransferHeader();
_transferHeader.TransferDate = DateTime.Now;
_transferHeader.InvoiceDate = DateTime.Now;
_transferHeader.FromInventoryID = transferHeader.FromInventoryID;
_transferHeader.ToInventoryID = transferHeader.ToInventoryID;
_transferHeader.IsClosed = false;
_transferHeader.CreatedBy = GlobalVariables.CurrentUser.UserID;
_transferHeader.CreateDate = DateTime.Now;
_transferHeader.UpdatedBy = null;
_transferHeader.UpdateDate = null;
_transferHeader.IsDeleted = false;
_transferHeader.DeletedBy = null;
_transferHeader.DeletedDate = null;
POS.DataLayer.INVTransferLineCollection _sALSalesLineCollection = new DataLayer.INVTransferLineCollection();
foreach (INVTransferLine sALSalesLine in sALSalesLineCollection)
{
POS.DataLayer.INVTransferLine _sALSalesLine = new POS.DataLayer.INVTransferLine();
_sALSalesLine.ProductID = sALSalesLine.ProductID;
_sALSalesLine.Qty = sALSalesLine.Qty;
_sALSalesLine.CreatedBy = GlobalVariables.CurrentUser.UserID;
_sALSalesLine.CreateDate = DateTime.Now;
_sALSalesLine.UpdatedBy = null;
_sALSalesLine.UpdateDate = null;
_sALSalesLine.IsDeleted = false;
_sALSalesLine.DeletedBy = null;
_sALSalesLine.DeletedDate = null;
_sALSalesLineCollection.Add(_sALSalesLine);
}
POS.DataLayer.INVTransferLine transferLineObj = new DataLayer.INVTransferLine();
return(transferLineObj.SaveTransaction(_transferHeader, _sALSalesLineCollection));
}
/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class INVTransferHeader in the form of object of INVTransferHeaderCollection </returns>
public INVTransferHeaderCollection SelectAll()
{
INVTransferHeaderCollection iNVTransferHeaderCollection = new INVTransferHeaderCollection();
foreach (POS.DataLayer.INVTransferHeader _iNVTransferHeader in POS.DataLayer.INVTransferHeaderBase.SelectAll())
{
_iNVTransferHeaderWCF = new INVTransferHeader();
_iNVTransferHeaderWCF.INVTransferHeaderID = _iNVTransferHeader.INVTransferHeaderID;
_iNVTransferHeaderWCF.TransferDate = _iNVTransferHeader.TransferDate;
_iNVTransferHeaderWCF.FromInventoryID = _iNVTransferHeader.FromInventoryID;
_iNVTransferHeaderWCF.ToInventoryID = _iNVTransferHeader.ToInventoryID;
_iNVTransferHeaderWCF.InvoiceNumber = _iNVTransferHeader.InvoiceNumber;
_iNVTransferHeaderWCF.InvoiceDate = _iNVTransferHeader.InvoiceDate;
_iNVTransferHeaderWCF.IsVoid = _iNVTransferHeader.IsVoid;
_iNVTransferHeaderWCF.IsPrinted = _iNVTransferHeader.IsPrinted;
_iNVTransferHeaderWCF.IsClosed = _iNVTransferHeader.IsClosed;
_iNVTransferHeaderWCF.CreatedBy = _iNVTransferHeader.CreatedBy;
_iNVTransferHeaderWCF.CreateDate = _iNVTransferHeader.CreateDate;
_iNVTransferHeaderWCF.UpdatedBy = _iNVTransferHeader.UpdatedBy;
_iNVTransferHeaderWCF.UpdateDate = _iNVTransferHeader.UpdateDate;
_iNVTransferHeaderWCF.IsDeleted = _iNVTransferHeader.IsDeleted;
_iNVTransferHeaderWCF.DeletedBy = _iNVTransferHeader.DeletedBy;
_iNVTransferHeaderWCF.DeletedDate = _iNVTransferHeader.DeletedDate;
iNVTransferHeaderCollection.Add(_iNVTransferHeaderWCF);
}
return(iNVTransferHeaderCollection);
}
/// <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 INVTransferHeader</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 INVTransferHeader in the form of an object of class INVTransferHeaderCollection</returns>
public INVTransferHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVTransferHeaderCollection iNVTransferHeaderCollection = new INVTransferHeaderCollection();
foreach (POS.DataLayer.INVTransferHeader _iNVTransferHeader in POS.DataLayer.INVTransferHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_iNVTransferHeaderWCF = new INVTransferHeader();
_iNVTransferHeaderWCF.INVTransferHeaderID = _iNVTransferHeader.INVTransferHeaderID;
_iNVTransferHeaderWCF.TransferDate = _iNVTransferHeader.TransferDate;
_iNVTransferHeaderWCF.FromInventoryID = _iNVTransferHeader.FromInventoryID;
_iNVTransferHeaderWCF.ToInventoryID = _iNVTransferHeader.ToInventoryID;
_iNVTransferHeaderWCF.InvoiceNumber = _iNVTransferHeader.InvoiceNumber;
_iNVTransferHeaderWCF.InvoiceDate = _iNVTransferHeader.InvoiceDate;
_iNVTransferHeaderWCF.IsVoid = _iNVTransferHeader.IsVoid;
_iNVTransferHeaderWCF.IsPrinted = _iNVTransferHeader.IsPrinted;
_iNVTransferHeaderWCF.IsClosed = _iNVTransferHeader.IsClosed;
_iNVTransferHeaderWCF.CreatedBy = _iNVTransferHeader.CreatedBy;
_iNVTransferHeaderWCF.CreateDate = _iNVTransferHeader.CreateDate;
_iNVTransferHeaderWCF.UpdatedBy = _iNVTransferHeader.UpdatedBy;
_iNVTransferHeaderWCF.UpdateDate = _iNVTransferHeader.UpdateDate;
_iNVTransferHeaderWCF.IsDeleted = _iNVTransferHeader.IsDeleted;
_iNVTransferHeaderWCF.DeletedBy = _iNVTransferHeader.DeletedBy;
_iNVTransferHeaderWCF.DeletedDate = _iNVTransferHeader.DeletedDate;
iNVTransferHeaderCollection.Add(_iNVTransferHeaderWCF);
}
return(iNVTransferHeaderCollection);
}
private void GetTransferOrderData(int salesHeaderID)
{
INVTransferHeaderPrimaryKey pk = new INVTransferHeaderPrimaryKey();
pk.INVTransferHeaderID = salesHeaderID;
_transferHeader = _transferHeaderWrapper.SelectOne(pk);
transferLineCollection = _transferHeaderWrapper.SelectByField(salesHeaderID);
BindGrid();
cbx_StoreFrom.SelectedValue = _transferHeader.FromInventoryID;
cbx_StoreTo.SelectedValue = _transferHeader.ToInventoryID;
dtb_Date.Value = _transferHeader.TransferDate.Value;
}
/// <summary>
/// This method will insert one new row into the database using the property Information
/// </summary>
///
/// <param name="iNVTransferHeader" type="INVTransferHeader">This INVTransferHeader will be inserted in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Insert(INVTransferHeader iNVTransferHeader)
{
_iNVTransferHeader = new POS.DataLayer.INVTransferHeader();
_iNVTransferHeader.INVTransferHeaderID = iNVTransferHeader.INVTransferHeaderID;
_iNVTransferHeader.TransferDate = iNVTransferHeader.TransferDate;
_iNVTransferHeader.FromInventoryID = iNVTransferHeader.FromInventoryID;
_iNVTransferHeader.ToInventoryID = iNVTransferHeader.ToInventoryID;
_iNVTransferHeader.CreatedBy = iNVTransferHeader.CreatedBy;
_iNVTransferHeader.CreateDate = iNVTransferHeader.CreateDate;
_iNVTransferHeader.UpdatedBy = iNVTransferHeader.UpdatedBy;
_iNVTransferHeader.IsDeleted = iNVTransferHeader.IsDeleted;
_iNVTransferHeader.DeletedBy = iNVTransferHeader.DeletedBy;
_iNVTransferHeader.DeletedDate = iNVTransferHeader.DeletedDate;
return(_iNVTransferHeader.Insert());
}
///<summary>
/// This method will update one new row into the database using the property Information
/// </summary>
///
/// <param name="iNVTransferHeader" type="INVTransferHeader">This INVTransferHeader will be updated in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Update(INVTransferHeader iNVTransferHeader)
{
_iNVTransferHeader = POS.DataLayer.INVTransferHeader.SelectOne(new POS.DataLayer.INVTransferHeaderPrimaryKey(iNVTransferHeader.INVTransferHeaderID));
_iNVTransferHeader.TransferDate = iNVTransferHeader.TransferDate;
_iNVTransferHeader.FromInventoryID = iNVTransferHeader.FromInventoryID;
_iNVTransferHeader.ToInventoryID = iNVTransferHeader.ToInventoryID;
_iNVTransferHeader.CreatedBy = iNVTransferHeader.CreatedBy;
_iNVTransferHeader.CreateDate = iNVTransferHeader.CreateDate;
_iNVTransferHeader.UpdatedBy = iNVTransferHeader.UpdatedBy;
_iNVTransferHeader.IsDeleted = iNVTransferHeader.IsDeleted;
_iNVTransferHeader.DeletedBy = iNVTransferHeader.DeletedBy;
_iNVTransferHeader.DeletedDate = iNVTransferHeader.DeletedDate;
return(_iNVTransferHeader.Update());
}
private INVTransferHeader CollectHeaderData()
{
if (_transferHeaderID > 0)
{
_transferHeader.FromInventoryID = Convert.ToInt32(cbx_StoreFrom.SelectedValue);
_transferHeader.ToInventoryID = Convert.ToInt32(cbx_StoreTo.SelectedValue);
_transferHeader.TransferDate = dtb_Date.Value;
return(_transferHeader);
}
else
{
INVTransferHeader _INVTransferHeader = new INVTransferHeader();
_INVTransferHeader.FromInventoryID = Convert.ToInt32(cbx_StoreFrom.SelectedValue);
_INVTransferHeader.ToInventoryID = Convert.ToInt32(cbx_StoreTo.SelectedValue);
_INVTransferHeader.TransferDate = dtb_Date.Value;
return(_INVTransferHeader);
}
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="INVTransferHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVTransferHeader</returns>
public INVTransferHeader SelectOne(INVTransferHeaderPrimaryKey pk)
{
_iNVTransferHeaderWCF = new INVTransferHeader();
_iNVTransferHeader = POS.DataLayer.INVTransferHeaderBase.SelectOne(new POS.DataLayer.INVTransferHeaderPrimaryKey(pk.INVTransferHeaderID));
_iNVTransferHeaderWCF.INVTransferHeaderID = _iNVTransferHeader.INVTransferHeaderID;
_iNVTransferHeaderWCF.TransferDate = _iNVTransferHeader.TransferDate;
_iNVTransferHeaderWCF.FromInventoryID = _iNVTransferHeader.FromInventoryID;
_iNVTransferHeaderWCF.ToInventoryID = _iNVTransferHeader.ToInventoryID;
_iNVTransferHeaderWCF.CreatedBy = _iNVTransferHeader.CreatedBy;
_iNVTransferHeaderWCF.CreateDate = _iNVTransferHeader.CreateDate;
_iNVTransferHeaderWCF.UpdatedBy = _iNVTransferHeader.UpdatedBy;
_iNVTransferHeaderWCF.IsDeleted = _iNVTransferHeader.IsDeleted;
_iNVTransferHeaderWCF.DeletedBy = _iNVTransferHeader.DeletedBy;
_iNVTransferHeaderWCF.DeletedDate = _iNVTransferHeader.DeletedDate;
return(_iNVTransferHeaderWCF);
}
public List <INVTransferHeaderModel> getAllTransferTransaction(INVTransferHeader invtransferHeader, DateTime?dateFrom = null, DateTime?toFrom = null)
{
List <INVTransferHeaderModel> resultList = new List <INVTransferHeaderModel>();
try
{
DateTime?fromCreationDate = dateFrom != null?dateFrom:null;
DateTime?toCreationDate = toFrom != null?toFrom:null;
resultList = (from item in SelectAll()
join fromInv in invinventoryService.SelectAll() on item.FromInventoryID equals fromInv.InventoryID
join toInv in invinventoryService.SelectAll() on item.ToInventoryID equals toInv.InventoryID
join usr in aduserService.SelectAll() on item.CreatedBy equals usr.UserID
where (
item.IsDeleted == false
&&
(!invtransferHeader.FromInventoryID.HasValue || item.FromInventoryID == invtransferHeader.FromInventoryID) &&
(!invtransferHeader.ToInventoryID.HasValue || item.ToInventoryID == invtransferHeader.ToInventoryID) &&
(string.IsNullOrEmpty(invtransferHeader.InvoiceNumber) || item.InvoiceNumber.Contains(invtransferHeader.InvoiceNumber)) &&
(invtransferHeader == null || (item.CreateDate > fromCreationDate && item.CreateDate > toCreationDate))
)
select new INVTransferHeaderModel()
{
INVTransferHeaderID = item.INVTransferHeaderID.Value,
CreatedBy = usr.UserName,
FromInventory = fromInv.InventoryName,
ToInventory = toInv.InventoryName,
TransferDate = item.CreateDate.Value.Date.ToShortDateString(),
IsClosed = item.IsClosed.Value,
InvoiceNumber = item.InvoiceNumber
}
).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(resultList);
}
public List<INVTransferHeaderModel> getAllTransferTransaction(INVTransferHeader invtransferHeader, DateTime? dateFrom = null, DateTime? toFrom = null)
{
List<INVTransferHeaderModel> resultList = new List<INVTransferHeaderModel>();
try
{
DateTime? fromCreationDate = dateFrom!=null?dateFrom:null;
DateTime? toCreationDate = toFrom!=null?toFrom:null;
resultList = (from item in SelectAll()
join fromInv in invinventoryService.SelectAll() on item.FromInventoryID equals fromInv.InventoryID
join toInv in invinventoryService.SelectAll() on item.ToInventoryID equals toInv.InventoryID
join usr in aduserService.SelectAll() on item.CreatedBy equals usr.UserID
where (
item.IsDeleted == false
&&
(!invtransferHeader.FromInventoryID.HasValue || item.FromInventoryID == invtransferHeader.FromInventoryID)
&& (!invtransferHeader.ToInventoryID.HasValue || item.ToInventoryID == invtransferHeader.ToInventoryID)
&& (string.IsNullOrEmpty(invtransferHeader.InvoiceNumber) || item.InvoiceNumber.Contains(invtransferHeader.InvoiceNumber))
&& (invtransferHeader==null || (item.CreateDate > fromCreationDate && item.CreateDate > toCreationDate))
)
select new INVTransferHeaderModel()
{
INVTransferHeaderID = item.INVTransferHeaderID.Value,
CreatedBy = usr.UserName,
FromInventory = fromInv.InventoryName,
ToInventory = toInv.InventoryName,
TransferDate = item.CreateDate.Value.Date.ToShortDateString(),
IsClosed = item.IsClosed.Value,
InvoiceNumber = item.InvoiceNumber
}
).ToList();
}
catch (Exception ex)
{
throw ex;
}
return resultList;
}
/// <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 INVTransferHeader in the form of an object of class INVTransferHeaderCollection </returns>
public INVTransferHeaderCollection SelectAllPaged(int?pageSize, int?skipPages, string orderByStatement)
{
INVTransferHeaderCollection iNVTransferHeaderCollection = new INVTransferHeaderCollection();
foreach (POS.DataLayer.INVTransferHeader _iNVTransferHeader in POS.DataLayer.INVTransferHeaderBase.SelectAllPaged(pageSize, skipPages, orderByStatement))
{
_iNVTransferHeaderWCF = new INVTransferHeader();
_iNVTransferHeaderWCF.INVTransferHeaderID = _iNVTransferHeader.INVTransferHeaderID;
_iNVTransferHeaderWCF.TransferDate = _iNVTransferHeader.TransferDate;
_iNVTransferHeaderWCF.FromInventoryID = _iNVTransferHeader.FromInventoryID;
_iNVTransferHeaderWCF.ToInventoryID = _iNVTransferHeader.ToInventoryID;
_iNVTransferHeaderWCF.CreatedBy = _iNVTransferHeader.CreatedBy;
_iNVTransferHeaderWCF.CreateDate = _iNVTransferHeader.CreateDate;
_iNVTransferHeaderWCF.UpdatedBy = _iNVTransferHeader.UpdatedBy;
_iNVTransferHeaderWCF.IsDeleted = _iNVTransferHeader.IsDeleted;
_iNVTransferHeaderWCF.DeletedBy = _iNVTransferHeader.DeletedBy;
_iNVTransferHeaderWCF.DeletedDate = _iNVTransferHeader.DeletedDate;
iNVTransferHeaderCollection.Add(_iNVTransferHeaderWCF);
}
return(iNVTransferHeaderCollection);
}
/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class INVTransferHeader</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>
///
/// <returns>List of object of class INVTransferHeader in the form of an object of class INVTransferHeaderCollection</returns>
public INVTransferHeaderCollection SelectByField(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation)
{
INVTransferHeaderCollection iNVTransferHeaderCollection = new INVTransferHeaderCollection();
foreach (POS.DataLayer.INVTransferHeader _iNVTransferHeader in POS.DataLayer.INVTransferHeaderBase.SelectByField(field, fieldValue, fieldValue2, typeOperation))
{
_iNVTransferHeaderWCF = new INVTransferHeader();
_iNVTransferHeaderWCF.INVTransferHeaderID = _iNVTransferHeader.INVTransferHeaderID;
_iNVTransferHeaderWCF.TransferDate = _iNVTransferHeader.TransferDate;
_iNVTransferHeaderWCF.FromInventoryID = _iNVTransferHeader.FromInventoryID;
_iNVTransferHeaderWCF.ToInventoryID = _iNVTransferHeader.ToInventoryID;
_iNVTransferHeaderWCF.CreatedBy = _iNVTransferHeader.CreatedBy;
_iNVTransferHeaderWCF.CreateDate = _iNVTransferHeader.CreateDate;
_iNVTransferHeaderWCF.UpdatedBy = _iNVTransferHeader.UpdatedBy;
_iNVTransferHeaderWCF.IsDeleted = _iNVTransferHeader.IsDeleted;
_iNVTransferHeaderWCF.DeletedBy = _iNVTransferHeader.DeletedBy;
_iNVTransferHeaderWCF.DeletedDate = _iNVTransferHeader.DeletedDate;
iNVTransferHeaderCollection.Add(_iNVTransferHeaderWCF);
}
return(iNVTransferHeaderCollection);
}
public void InitiateGrid(INVTransferHeader invtransferHeader)
{
dgrid_Result.Columns.Clear();
dgrid_Result.AutoGenerateColumns = false;
dgrid_Result.Height = 150;
dgrid_Result.Size = new Size(10, 250);
addColumnToGrid("INVTransferHeaderID", "INVTransferHeaderID", 120, false);
addColumnToGrid("IsClosed", "IsClosed", 120, false);
addColumnToGrid("المخزن المحول منه", "FromInventory", 120, true);
addColumnToGrid("المخزن المحول اليه", "ToInventory", 120, true);
addColumnToGrid("تاريخ التحويل", "TransferDate", 120, true);
addColumnToGrid("رقم الفاتورة", "InvoiceNumber", 120, true);
addColumnToGrid("الموظف", "CreatedBy", 120, true);
List <INVTransferHeaderModel> transferList = new List <INVTransferHeaderModel>();
if (invtransferHeader == null)
{
transferList = _invtransferHeaderWrapper.getAllTransferTransaction();
}
else
{
transferList = _invtransferHeaderWrapper.getAllTransferTransaction(invtransferHeader);
}
dgrid_Result.DataSource = transferList;
}
/////
public bool SaveTransferOrder(INVTransferHeader transferHeader, INVTransferLineCollection sALSalesLineCollection)
{
POS.DataLayer.INVTransferHeader _transferHeader = new POS.DataLayer.INVTransferHeader();
_transferHeader.TransferDate = DateTime.Now;
_transferHeader.InvoiceDate = DateTime.Now;
_transferHeader.FromInventoryID = transferHeader.FromInventoryID;
_transferHeader.ToInventoryID = transferHeader.ToInventoryID;
_transferHeader.IsClosed = false;
_transferHeader.CreatedBy = GlobalVariables.CurrentUser.UserID;
_transferHeader.CreateDate = DateTime.Now;
_transferHeader.UpdatedBy = null;
_transferHeader.UpdateDate = null;
_transferHeader.IsDeleted = false;
_transferHeader.DeletedBy = null;
_transferHeader.DeletedDate = null;
POS.DataLayer.INVTransferLineCollection _sALSalesLineCollection = new DataLayer.INVTransferLineCollection();
foreach (INVTransferLine sALSalesLine in sALSalesLineCollection)
{
POS.DataLayer.INVTransferLine _sALSalesLine = new POS.DataLayer.INVTransferLine();
_sALSalesLine.ProductID = sALSalesLine.ProductID;
_sALSalesLine.Qty = sALSalesLine.Qty;
_sALSalesLine.CreatedBy = GlobalVariables.CurrentUser.UserID;
_sALSalesLine.CreateDate = DateTime.Now;
_sALSalesLine.UpdatedBy = null;
_sALSalesLine.UpdateDate = null;
_sALSalesLine.IsDeleted = false;
_sALSalesLine.DeletedBy = null;
_sALSalesLine.DeletedDate = null;
_sALSalesLineCollection.Add(_sALSalesLine);
}
POS.DataLayer.INVTransferLine transferLineObj = new DataLayer.INVTransferLine();
return transferLineObj.SaveTransaction(_transferHeader, _sALSalesLineCollection);
}
private INVTransferHeader CollectHeaderData()
{
if (_transferHeaderID > 0)
{
_transferHeader.FromInventoryID = Convert.ToInt32(cbx_StoreFrom.SelectedValue);
_transferHeader.ToInventoryID = Convert.ToInt32(cbx_StoreTo.SelectedValue);
_transferHeader.TransferDate = dtb_Date.Value;
return _transferHeader;
}
else
{
INVTransferHeader _INVTransferHeader = new INVTransferHeader();
_INVTransferHeader.FromInventoryID = Convert.ToInt32(cbx_StoreFrom.SelectedValue);
_INVTransferHeader.ToInventoryID = Convert.ToInt32(cbx_StoreTo.SelectedValue);
_INVTransferHeader.TransferDate = dtb_Date.Value;
return _INVTransferHeader;
}
}
private void GetTransferOrderData(int salesHeaderID)
{
INVTransferHeaderPrimaryKey pk = new INVTransferHeaderPrimaryKey();
pk.INVTransferHeaderID = salesHeaderID;
_transferHeader = _transferHeaderWrapper.SelectOne(pk);
transferLineCollection = _transferHeaderWrapper.SelectByField(salesHeaderID);
BindGrid();
cbx_StoreFrom.SelectedValue = _transferHeader.FromInventoryID;
cbx_StoreTo.SelectedValue = _transferHeader.ToInventoryID;
dtb_Date.Value = _transferHeader.TransferDate.Value;
}
public void InitiateGrid(INVTransferHeader invtransferHeader,DateTime? dateFrom = null,DateTime? toFrom = null)
{
dgrid_Result.Columns.Clear();
dgrid_Result.AutoGenerateColumns = false;
dgrid_Result.Height = 150;
dgrid_Result.Size = new Size(10, 250);
addColumnToGrid("INVTransferHeaderID", "INVTransferHeaderID", 120, false);
addColumnToGrid("IsClosed", "IsClosed", 120, false);
addColumnToGrid("المخزن المحول منه", "FromInventory", 120, true);
addColumnToGrid("المخزن المحول اليه", "ToInventory", 120, true);
addColumnToGrid("تاريخ التحويل", "TransferDate", 120, true);
addColumnToGrid("رقم الفاتورة", "InvoiceNumber", 120, true);
addColumnToGrid("الموظف", "CreatedBy", 120, true);
List<INVTransferHeaderModel> transferList = new List<INVTransferHeaderModel>();
if (invtransferHeader == null)
transferList = _invtransferHeaderWrapper.getAllTransferTransaction();
else
transferList = _invtransferHeaderWrapper.getAllTransferTransaction(invtransferHeader,dateFrom,toFrom);
dgrid_Result.DataSource = transferList;
}
private void search()
{
INVTransferHeader invtransferHeader = new INVTransferHeader();
//invtransferHeader.CreateDate = dtb_Date.Value;
int fromInv = 0, toInv = 0;
if (cbx_StoreFrom.SelectedValue != null)
int.TryParse(cbx_StoreFrom.SelectedValue.ToString(), out fromInv);
if (cbx_StoreTo.SelectedValue != null)
int.TryParse(cbx_StoreTo.SelectedValue.ToString(), out toInv);
if (fromInv > 0)
invtransferHeader.FromInventoryID = fromInv;
if (toInv > 0)
invtransferHeader.ToInventoryID = toInv;
if (string.IsNullOrEmpty(tbx_OrderSerial.Text))
invtransferHeader.InvoiceNumber = tbx_OrderSerial.Text;
InitiateGrid(invtransferHeader);
}
