public OrganizationController() { item = new ReturnedItem(); item.apiAppName = "DriversApi"; item.clientAppId = "3319759c-a7c1-4251-b92d-a3b1a1c1cd80"; item.organizationDisplayName = "Tenant A"; item.organizationDomain = "tentant.onmicrosoft.com"; item.signUpSignInPolicy = "B2C_1_susi"; item.passwordResetPolicy = "B2C_1_pr"; item.scopes = "read,write"; }
public ReturnedItemDetailUI() { InitializeComponent(); loStock = new Stock(); loReturnedItem = new ReturnedItem(); loInventory = new Inventory(); loInventoryDetail = new InventoryDetail(); loSecurity = new SecurityUI(); lStockId = ""; lFromSave = false; }
/// <summary> /// This method returns a list of rented items from the rental transactions with the specified StoreMemberID. /// </summary> /// <param name="storeMemberID">The ID of the StoreMember.</param> /// <returns>A list of rented items from the rental transactions with the specified StoreMemberID.</returns> public List <ReturnedItem> GetReturnTransactionsWithItemsByStoreMemberID(int storeMemberID) { List <ReturnedItem> returnedList = new List <ReturnedItem>(); string selectStatement = "SELECT ReturnTransaction.ReturnID AS ReturnID, Returns.RentalID AS RentalID, ReturnTransaction.ReturnDate AS ReturnDate, " + "RentalTransaction.ScheduledReturn AS ScheduledReturn, Employees.FName AS EmployeeFirst, Employees.LName AS EmployeeLast, " + "FurnitureItem.Serial# AS ItemSerial, FurnitureItem.Description AS ItemDescription, Returns.Quantity AS ItemQuantity, " + "Returns.FineDue AS FineDue, Returns.RefundDue AS RefundDue " + "FROM ReturnTransaction " + "LEFT JOIN Employees ON ReturnTransaction.EmployeeID=Employees.EmployeeID " + "LEFT JOIN Returns ON ReturnTransaction.ReturnID=Returns.ReturnID " + "LEFT JOIN RentalTransaction ON Returns.RentalID=RentalTransaction.RentalID " + "LEFT JOIN FurnitureItem ON Returns.Serial#=FurnitureItem.Serial# " + "WHERE RentalTransaction.MemberID=@memberID " + "ORDER BY ReturnID ASC, RentalID ASC; "; using (SqlConnection connection = RentMeDBConnection.GetConnection()) { connection.Open(); using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection)) { selectCommand.Parameters.AddWithValue("@memberID", storeMemberID); using (SqlDataReader reader = selectCommand.ExecuteReader()) { while (reader.Read()) { int returnID = reader.GetInt32(0); int rentalID = reader.GetInt32(1); DateTime returnDate = (DateTime)reader["ReturnDate"]; DateTime scheduledReturn = (DateTime)reader["ScheduledReturn"]; string employeeFullName = reader["EmployeeFirst"].ToString() + " " + reader["EmployeeLast"].ToString(); string itemSerial = reader["ItemSerial"].ToString(); string itemDescription = reader["ItemDescription"].ToString(); int itemQuantity = reader.GetInt32(8); decimal fineDue = reader.GetDecimal(9); decimal refundDue = reader.GetDecimal(10); ReturnedItem returnedItem = new ReturnedItem(returnID, rentalID, returnDate, scheduledReturn, employeeFullName, itemSerial, itemDescription, itemQuantity, fineDue, refundDue); returnedList.Add(returnedItem); } } } } return(returnedList); }
private void AddToListView(bool isScrap, ReturnedItem goodItem, ScrapItem scrapItem) { string[] arr = new string[3]; if (isScrap) { arr[0] = Convert.ToString(scrapItem.Item.Id); arr[1] = scrapItem.Item.Name; arr[2] = Convert.ToString(scrapItem.Qty); ListViewItem lit = new ListViewItem(arr); scrapListView.Items.Add(lit); } else { arr[0] = Convert.ToString(goodItem.Item.Id); arr[1] = goodItem.Item.Name; arr[2] = Convert.ToString(goodItem.Qty); ListViewItem lit = new ListViewItem(arr); goodListView.Items.Add(lit); } }
private void AddToStocksAndMakeHistory(ReturnedItem itemTobeReturned) { ReturnedItem rI = new ReturnedItem(); rI.Item = itemTobeReturned.Item; rI.ReturnedHistory = _history; rI.Qty = Convert.ToDouble(itemTobeReturned.Qty); rI.DateAdded = DateTime.Now; ReturnInOutParam p = new ReturnInOutParam(); p.ReturnedItem = rI; p.InOrOut = InOrOut.In; p.Note = rI.Qty + " Item(s) Returned To Stocks. Please refer to Return History. DR : " + _dr.DRNumberToDisplay; p.DrId = _dr.Id; p.ItemId = rI.Item.Id; p.Name = _name; _inOutService.InOutGoodItems(p); }
private void SaveButton_Click(object sender, RoutedEventArgs e) { IdTextBox.Text = ReturnedItem.GetNextReturnsId().ToString(); if (IsDataInCorrectForm()) { ReturnedItem.AddReturnedItem(CreateReturnedItemFromData()); if (_selectedCustomer == null) { return; } _selectedCustomer.ContactInfo = CustomerInfoTextBox.Text; Customer.UpdateCustomer(_selectedCustomer); MessageBox.Show("Successfully Added!!", "Information", MessageBoxButton.OK, MessageBoxImage.Information); NotifyObservers(); } else { MessageBox.Show("Incomplete Data!!", "Information", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void InventoryDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { _selectedReturnedItem = ((DataGrid)sender).SelectedItem as ReturnedItem; }
public string updateReturnedItem([FromBody] ReturnedItem pReturnedItem) { return(loReturnedItem.updateReturnedItem(pReturnedItem)); }
public string insertReturnedItem([FromBody] ReturnedItem pReturnedItem) { return(loReturnedItem.insertReturnedItem(pReturnedItem)); }