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