internal static RecieptItem Item(string ItemSearch) { RecieptItem Item = null; if (POSConnection.State != System.Data.ConnectionState.Open) { POSConnection.Open(); SqlCommand command = new SqlCommand(SQL_ITEM, POSConnection); command.Parameters.AddWithValue("@ITEMID", ItemSearch.Trim()); command.Parameters.AddWithValue("@ITEMBARCODE", ItemSearch.Trim()); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { Item = new RecieptItem() { Barcode = reader.GetString(0), Description = reader.GetString(1), ItemId = reader.GetString(2), LineNumber = 1, NetAmount = reader.GetDecimal(3), PaymentItem = "", PaymentUsage = 0, Quantity = 1 }; } reader.Close(); } return(Item); }
private void buttonWarrentyPriceCheck_Click(object sender, EventArgs e) { this.IsBusy = true; if (this.textBoxItemSearch.Text.Trim().Length >= 13) { if (this.buttonWarrentyPriceCheck.Enabled) { RecieptItem RecieptItem = LSExtendedWarrenty.AppBase.DataHelper.DataProvider.GetItem(this.textBoxItemSearch.Text); if (RecieptItem == null) { MessageBox.Show(this, "Item not found.", "Not Found"); } else { WarrentyItemSelction WarrentyItemSelction = new WarrentyItemSelction(); WarrentyItemSelction.Item = RecieptItem; var result = WarrentyItemSelction.ShowDialog(this); } } } else { MessageBox.Show("Please enter an Item Code or Barcode.", "Not Found"); } this.IsBusy = false; }
internal static List <WarretntySettings> WarrentySettings(RecieptItem Item) { List <WarretntySettings> WarrentySettingsList = new List <WarretntySettings>(); if (POSConnection.State != System.Data.ConnectionState.Open) { POSConnection.Open(); SqlCommand command = new SqlCommand(SQL_WARRENTY_SETTINGS, POSConnection); command.Parameters.AddWithValue(@"@ITEMID", Item.ItemId); command.CommandType = CommandType.StoredProcedure; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { WarrentySettingsList.Add(new WarretntySettings() { NumberOfYears = reader.GetInt32(0), WarrentyPercentage = reader.GetInt32(1), Brand = reader.GetInt32(2), PaymentItem = reader.GetString(3) } ); } reader.Close(); } return(WarrentySettingsList); }
internal static List <WarretntySettings> GetWarrentySettings(RecieptItem Item) { List <WarretntySettings> WarrentySettingsList = new List <WarretntySettings>(); using (Connection Connection = new Connection()) { WarrentySettingsList = Connection.WarrentySettings(Item); } if (WarrentySettingsList.Count == 0) { throw new NoWarrentySettingFoundException("No Warranty Settings Found for the Item: " + Item.ItemId + ".", "Cannot Add Warranty for Item."); } return(WarrentySettingsList); }
private void dataGridViewRecieptItems_CellClick(object sender, DataGridViewCellEventArgs e) { try { String selectedItemId = dataGridViewRecieptItems.Rows[e.RowIndex].Cells["ItemId"].Value.ToString(); foreach (RecieptItem item in Reciept) { if (item.ItemId == selectedItemId) { this.SelectedItem = item; this.textBoxItem.Text = item.ItemId; } } } catch (Exception) { } }
internal Reciept Reciept(string RecieptNumber, string Selection) { Reciept Reciept = null; if (POSConnection.State != System.Data.ConnectionState.Open) { POSConnection.Open(); SqlCommand command = new SqlCommand(SQL_RECIEPT_DETAILS, POSConnection); command.Parameters.AddWithValue("@RECEIPTID", RecieptNumber); command.Parameters.AddWithValue("@SELECTION", Selection); SqlDataReader reader = command.ExecuteReader(); RecieptItem tempItem = null; int i = 0; while (reader.Read()) { i++; if (i == 1) { Reciept = new Reciept(); Reciept.TransactionID = reader.GetString(0); Reciept.RecieptID = reader.GetString(1); Reciept.Store = reader.GetString(2); Reciept.Staff = reader.GetString(3); Reciept.StaffName = reader.GetString(4); Reciept.TransactionDate = reader.GetDateTime(5); } try { tempItem = new RecieptItem(); tempItem.LineNumber = (int)reader.GetDecimal(6); tempItem.ItemId = reader.GetString(7); tempItem.Quantity = (int)reader.GetDecimal(8); tempItem.NetAmount = reader.GetDecimal(9); tempItem.Description = reader.GetString(10); tempItem.Barcode = reader.GetString(11); Reciept.Add(tempItem); } catch (Exception ex) { throw ex; } } reader.Close(); } return(Reciept); }
public Reciept ApplyRule(Reciept reciept) { if (reciept == null || reciept.RecieptItems.Count == 0) { throw new ArgumentException("Price list is null or empty."); } RecieptItem recieptItem = reciept.RecieptItems.FirstOrDefault(i => String.Compare(i.Name, "orange", StringComparison.OrdinalIgnoreCase) == 0); if (recieptItem == null || recieptItem.Quantity == 0) { return(reciept); } int quantitywithoffer = (int)recieptItem.Quantity / 3; int leftover = recieptItem.Quantity - quantitywithoffer * 3; recieptItem.Quantity = quantitywithoffer * 2 + leftover; return(reciept); }
private void textBoxItem_KeyPress(object sender, KeyPressEventArgs e) { this.SelectedItem = null; if (e.KeyChar == Convert.ToChar(Keys.Enter)) { if (Reciept != null) { foreach (RecieptItem item in Reciept) { if ((item.Barcode == this.textBoxItem.Text) || (item.ItemId == this.textBoxItem.Text)) { this.SelectedItem = item; this.textBoxItem.Text = item.ItemId; } } if (SelectedItem == null) { String ItemId = LSExtendedWarrenty.AppBase.DataHelper.DataProvider.GetItemId(textBoxItem.Text, Reciept.TransactionID); foreach (RecieptItem item in Reciept) { if (item.ItemId == ItemId) { this.SelectedItem = item; this.textBoxItem.Text = item.ItemId; } } } if (SelectedItem == null) { MessageBox.Show(this, "Item not found in the selected Receipt", "Item Not Found"); } } else { MessageBox.Show(this, "No Receipt selected.", "No Receipt"); } } }
private void textBoxItemSearch_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == Convert.ToChar(Keys.Enter)) { this.IsBusy = true; if (this.buttonWarrentyPriceCheck.Enabled) { RecieptItem RecieptItem = LSExtendedWarrenty.AppBase.DataHelper.DataProvider.GetItem(this.textBoxItemSearch.Text); if (RecieptItem == null) { MessageBox.Show(this, "Item not found.", "Not Found"); } else { WarrentyItemSelction WarrentyItemSelction = new WarrentyItemSelction(); WarrentyItemSelction.Item = RecieptItem; var result = WarrentyItemSelction.ShowDialog(this); } } this.IsBusy = false; } }