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