private void cmboBox_TakingName_SelectedIndexChanged(object sender, EventArgs e) { int headerID; if (!int.TryParse(cmboBox_TakingName.SelectedValue.ToString(), out headerID)) { return; } INVTakingInventory _selectedHeader = _takingHeaders.Where(a => a.TakingHeaderID == headerID).FirstOrDefault(); txtbox_Date.Text = _selectedHeader.TakingDate.Value.ToShortDateString(); txtbox_InventoryName.Text = _selectedHeader.InventoryName; dgv_Lines.AutoGenerateColumns = false; dgv_Lines.DataSource = new INVTakingInventoryLineWrapper().GetLines(headerID); }
public INVTakingInventoryCollection GetUnCommittedTaking() { INVTakingInventoryCollection iNVTakingInventoryCollection = new INVTakingInventoryCollection(); foreach (POS.DataLayer.INVTakingInventory _iNVTakingInventory in new POS.DataLayer.INVTakingInventory().GetNotCommittedTaking()) { _iNVTakingInventoryWCF = new INVTakingInventory(); _iNVTakingInventoryWCF.TakingHeaderID = _iNVTakingInventory.TakingHeaderID; _iNVTakingInventoryWCF.TakingDate = _iNVTakingInventory.TakingDate; _iNVTakingInventoryWCF.TakingName = _iNVTakingInventory.TakingName; _iNVTakingInventoryWCF.CreatedBy = _iNVTakingInventory.CreatedBy; _iNVTakingInventoryWCF.Notes = _iNVTakingInventory.Notes; _iNVTakingInventoryWCF.InventoryID = _iNVTakingInventory.InventoryID; _iNVTakingInventoryWCF.InventoryName = _iNVTakingInventory.InventoryName; iNVTakingInventoryCollection.Add(_iNVTakingInventoryWCF); } return iNVTakingInventoryCollection; }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="INVTakingInventoryPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class INVTakingInventory</returns> public INVTakingInventory SelectOne(INVTakingInventoryPrimaryKey pk) { _iNVTakingInventoryWCF = new INVTakingInventory(); _iNVTakingInventory = POS.DataLayer.INVTakingInventoryBase.SelectOne(new POS.DataLayer.INVTakingInventoryPrimaryKey(pk.TakingHeaderID)); _iNVTakingInventoryWCF.TakingHeaderID = _iNVTakingInventory.TakingHeaderID; _iNVTakingInventoryWCF.TakingDate = _iNVTakingInventory.TakingDate; _iNVTakingInventoryWCF.TakingName = _iNVTakingInventory.TakingName; _iNVTakingInventoryWCF.CreatedBy = _iNVTakingInventory.CreatedBy; _iNVTakingInventoryWCF.CreatedDate = _iNVTakingInventory.CreatedDate; _iNVTakingInventoryWCF.UpdatedBy = _iNVTakingInventory.UpdatedBy; _iNVTakingInventoryWCF.UpdateDate = _iNVTakingInventory.UpdateDate; _iNVTakingInventoryWCF.IsDeleted = _iNVTakingInventory.IsDeleted; _iNVTakingInventoryWCF.DeletedBy = _iNVTakingInventory.DeletedBy; _iNVTakingInventoryWCF.DeletedDate = _iNVTakingInventory.DeletedDate; _iNVTakingInventoryWCF.Notes = _iNVTakingInventory.Notes; _iNVTakingInventoryWCF.InventoryID = _iNVTakingInventory.InventoryID; return _iNVTakingInventoryWCF; }
public INVTakingInventoryCollection GetUnCommittedTaking() { INVTakingInventoryCollection iNVTakingInventoryCollection = new INVTakingInventoryCollection(); foreach (POS.DataLayer.INVTakingInventory _iNVTakingInventory in new POS.DataLayer.INVTakingInventory().GetNotCommittedTaking()) { _iNVTakingInventoryWCF = new INVTakingInventory(); _iNVTakingInventoryWCF.TakingHeaderID = _iNVTakingInventory.TakingHeaderID; _iNVTakingInventoryWCF.TakingDate = _iNVTakingInventory.TakingDate; _iNVTakingInventoryWCF.TakingName = _iNVTakingInventory.TakingName; _iNVTakingInventoryWCF.CreatedBy = _iNVTakingInventory.CreatedBy; _iNVTakingInventoryWCF.Notes = _iNVTakingInventory.Notes; _iNVTakingInventoryWCF.InventoryID = _iNVTakingInventory.InventoryID; _iNVTakingInventoryWCF.InventoryName = _iNVTakingInventory.InventoryName; iNVTakingInventoryCollection.Add(_iNVTakingInventoryWCF); } return(iNVTakingInventoryCollection); }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class INVTakingInventory in the form of object of INVTakingInventoryCollection </returns> public INVTakingInventoryCollection SelectAll() { INVTakingInventoryCollection iNVTakingInventoryCollection = new INVTakingInventoryCollection(); foreach (POS.DataLayer.INVTakingInventory _iNVTakingInventory in POS.DataLayer.INVTakingInventoryBase.SelectAll()) { _iNVTakingInventoryWCF = new INVTakingInventory(); _iNVTakingInventoryWCF.TakingHeaderID = _iNVTakingInventory.TakingHeaderID; _iNVTakingInventoryWCF.TakingDate = _iNVTakingInventory.TakingDate; _iNVTakingInventoryWCF.TakingName = _iNVTakingInventory.TakingName; _iNVTakingInventoryWCF.CreatedBy = _iNVTakingInventory.CreatedBy; _iNVTakingInventoryWCF.CreatedDate = _iNVTakingInventory.CreatedDate; _iNVTakingInventoryWCF.UpdatedBy = _iNVTakingInventory.UpdatedBy; _iNVTakingInventoryWCF.UpdateDate = _iNVTakingInventory.UpdateDate; _iNVTakingInventoryWCF.IsDeleted = _iNVTakingInventory.IsDeleted; _iNVTakingInventoryWCF.DeletedBy = _iNVTakingInventory.DeletedBy; _iNVTakingInventoryWCF.DeletedDate = _iNVTakingInventory.DeletedDate; _iNVTakingInventoryWCF.Notes = _iNVTakingInventory.Notes; _iNVTakingInventoryWCF.InventoryID = _iNVTakingInventory.InventoryID; iNVTakingInventoryCollection.Add(_iNVTakingInventoryWCF); } return iNVTakingInventoryCollection; }
///<summary> /// This method will update one new row into the database using the property Information /// </summary> /// /// <param name="iNVTakingInventory" type="INVTakingInventory">This INVTakingInventory will be updated in the database.</param> /// /// <returns>True if succeeded</returns> public bool Update(INVTakingInventory iNVTakingInventory) { _iNVTakingInventory=POS.DataLayer.INVTakingInventory.SelectOne(new POS.DataLayer.INVTakingInventoryPrimaryKey(iNVTakingInventory.TakingHeaderID)); _iNVTakingInventory.TakingDate=iNVTakingInventory.TakingDate; _iNVTakingInventory.TakingName=iNVTakingInventory.TakingName; _iNVTakingInventory.CreatedBy=iNVTakingInventory.CreatedBy; _iNVTakingInventory.CreatedDate=iNVTakingInventory.CreatedDate; _iNVTakingInventory.UpdatedBy=iNVTakingInventory.UpdatedBy; _iNVTakingInventory.UpdateDate=iNVTakingInventory.UpdateDate; _iNVTakingInventory.IsDeleted=iNVTakingInventory.IsDeleted; _iNVTakingInventory.DeletedBy=iNVTakingInventory.DeletedBy; _iNVTakingInventory.DeletedDate=iNVTakingInventory.DeletedDate; _iNVTakingInventory.Notes=iNVTakingInventory.Notes; _iNVTakingInventory.InventoryID=iNVTakingInventory.InventoryID; return _iNVTakingInventory.Update(); }
/// <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 INVTakingInventory</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 INVTakingInventory in the form of an object of class INVTakingInventoryCollection</returns> public INVTakingInventoryCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { INVTakingInventoryCollection iNVTakingInventoryCollection = new INVTakingInventoryCollection(); foreach (POS.DataLayer.INVTakingInventory _iNVTakingInventory in POS.DataLayer.INVTakingInventoryBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement)) { _iNVTakingInventoryWCF = new INVTakingInventory(); _iNVTakingInventoryWCF.TakingHeaderID = _iNVTakingInventory.TakingHeaderID; _iNVTakingInventoryWCF.TakingDate = _iNVTakingInventory.TakingDate; _iNVTakingInventoryWCF.TakingName = _iNVTakingInventory.TakingName; _iNVTakingInventoryWCF.CreatedBy = _iNVTakingInventory.CreatedBy; _iNVTakingInventoryWCF.CreatedDate = _iNVTakingInventory.CreatedDate; _iNVTakingInventoryWCF.UpdatedBy = _iNVTakingInventory.UpdatedBy; _iNVTakingInventoryWCF.UpdateDate = _iNVTakingInventory.UpdateDate; _iNVTakingInventoryWCF.IsDeleted = _iNVTakingInventory.IsDeleted; _iNVTakingInventoryWCF.DeletedBy = _iNVTakingInventory.DeletedBy; _iNVTakingInventoryWCF.DeletedDate = _iNVTakingInventory.DeletedDate; _iNVTakingInventoryWCF.Notes = _iNVTakingInventory.Notes; _iNVTakingInventoryWCF.InventoryID = _iNVTakingInventory.InventoryID; iNVTakingInventoryCollection.Add(_iNVTakingInventoryWCF); } return iNVTakingInventoryCollection; }
/// <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 INVTakingInventory in the form of an object of class INVTakingInventoryCollection </returns> public INVTakingInventoryCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement) { INVTakingInventoryCollection iNVTakingInventoryCollection = new INVTakingInventoryCollection(); foreach (POS.DataLayer.INVTakingInventory _iNVTakingInventory in POS.DataLayer.INVTakingInventoryBase.SelectAllPaged(pageSize, skipPages, orderByStatement)) { _iNVTakingInventoryWCF = new INVTakingInventory(); _iNVTakingInventoryWCF.TakingHeaderID = _iNVTakingInventory.TakingHeaderID; _iNVTakingInventoryWCF.TakingDate = _iNVTakingInventory.TakingDate; _iNVTakingInventoryWCF.TakingName = _iNVTakingInventory.TakingName; _iNVTakingInventoryWCF.CreatedBy = _iNVTakingInventory.CreatedBy; _iNVTakingInventoryWCF.CreatedDate = _iNVTakingInventory.CreatedDate; _iNVTakingInventoryWCF.UpdatedBy = _iNVTakingInventory.UpdatedBy; _iNVTakingInventoryWCF.UpdateDate = _iNVTakingInventory.UpdateDate; _iNVTakingInventoryWCF.IsDeleted = _iNVTakingInventory.IsDeleted; _iNVTakingInventoryWCF.DeletedBy = _iNVTakingInventory.DeletedBy; _iNVTakingInventoryWCF.DeletedDate = _iNVTakingInventory.DeletedDate; _iNVTakingInventoryWCF.Notes = _iNVTakingInventory.Notes; _iNVTakingInventoryWCF.InventoryID = _iNVTakingInventory.InventoryID; iNVTakingInventoryCollection.Add(_iNVTakingInventoryWCF); } return iNVTakingInventoryCollection; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// /// <param name="iNVTakingInventory" type="INVTakingInventory">This INVTakingInventory will be inserted in the database.</param> /// /// <returns>True if succeeded</returns> public bool Insert(INVTakingInventory iNVTakingInventory) { _iNVTakingInventory = new POS.DataLayer.INVTakingInventory(); _iNVTakingInventory.TakingHeaderID=iNVTakingInventory.TakingHeaderID; _iNVTakingInventory.TakingDate=iNVTakingInventory.TakingDate; _iNVTakingInventory.TakingName=iNVTakingInventory.TakingName; _iNVTakingInventory.CreatedBy=iNVTakingInventory.CreatedBy; _iNVTakingInventory.CreatedDate=iNVTakingInventory.CreatedDate; _iNVTakingInventory.UpdatedBy=iNVTakingInventory.UpdatedBy; _iNVTakingInventory.UpdateDate=iNVTakingInventory.UpdateDate; _iNVTakingInventory.IsDeleted=iNVTakingInventory.IsDeleted; _iNVTakingInventory.DeletedBy=iNVTakingInventory.DeletedBy; _iNVTakingInventory.DeletedDate=iNVTakingInventory.DeletedDate; _iNVTakingInventory.Notes=iNVTakingInventory.Notes; _iNVTakingInventory.InventoryID=iNVTakingInventory.InventoryID; return _iNVTakingInventory.Insert(); }