private void GenerateConsignmentResultsForm_Load(object sender, EventArgs e) { //set title labelTitleDisplay.Text = "Checking Lost Items for Consignment Period " + ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(consignmentPeriod); //load unsold - items data from the period context.Items.Where(item => item.ItemStatus == ConsignmentStoreBusinessLogic.ITEM_STATUS_UNSOLD && item.ConsignedDate.Month == consignmentPeriod % 100 && item.ConsignedDate.Year == consignmentPeriod / 100).Load(); //setup datagridview FormHelper.InitializeDataGridViewSettings(dataGridViewItems); //binding to dataGridView dataGridViewItems.DataSource = context.Items.Local.ToBindingList(); dataGridViewItems.Columns["SoldItem"].Visible = false; dataGridViewItems.Columns["Employee"].Visible = false; dataGridViewItems.Columns["Consignor"].Visible = false; //toggle status of item by double-click dataGridViewItems.CellDoubleClick += ToggleItemStatusLostOrUnsold; //filter by consignorId textBoxSearch.TextChanged += SearchByConsignorId; //button finish is clicked buttonFinishGenerateConsignmentResults.Click += GenerateConsignmentResults; }
private void GenerateConsignmentResults(object sender, EventArgs e) { //change all local items that have status "unsold" to "returned" and save to database foreach (var item in context.Items.Local.Where(i => i.ItemStatus.Trim() == ConsignmentStoreBusinessLogic.ITEM_STATUS_UNSOLD)) { item.ItemStatus = ConsignmentStoreBusinessLogic.ITEM_STATUS_RETURNED; } context.SaveChanges();//save to database //generate consignment results if (ConsignmentStoreBusinessLogic.GenerateConsignmentResultsForPeriod(consignmentPeriod)) { FormHelper.ShowInfoMessageBox("Consignment Results for Period " + ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(consignmentPeriod) + " are creared!"); //success then close the form Close(); } else { FormHelper.ShowErrorMessageBox("Consignment Results for Period " + ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(consignmentPeriod) + " cannot creared. Please try again!"); } }
private string GetConsignmentResultDetails(ConsignmentResult result) { if (result == null) { return(""); } stringBuilder.Clear(); stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Id", result.Consignor.ConsignorId)); stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Name", result.Consignor.ConsignorName.Trim())); stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor DOB", ((DateTime)result.Consignor.ConsignorDOB).ToString("dd MMMM yyyy"))); stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Phone", result.Consignor.ConsignorPhone.Trim())); stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Email", result.Consignor.ConsignorEmail.Trim())); stringBuilder.AppendLine(string.Format("{0,-20} {1}", "Consignor Period", ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(result.ConsignmentPeriod))); stringBuilder.AppendLine(string.Format("{0,-20} {1:n0}", "Returned Items", result.NumberOfReturnedItems)); stringBuilder.AppendLine(string.Format("{0,-20} {1:c}", "Value Items", result.TotalValueOfReturnedItems)); stringBuilder.AppendLine(string.Format("{0,-20} {1:c}", "Consignment Result", result.TotalValueReceivedByConsignor)); return(stringBuilder.ToString()); }
private void UserControlManageConsignmentResults_Load(object sender, EventArgs e) { //add consignment periods to combox box (format: month/year) foreach (var period in context.ConsignmentSummaries.Local.ToList()) { comboBoxConsignmentPeriods.Items.Add( ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(period.ConsignmentPeriod)); } //binding datagridview FormHelper.InitializeDataGridViewSettings(dataGridViewConsignmentResults); FormHelper.InitializeDataGridViewSettings(dataGridViewConsignmentSummaries); dataGridViewConsignmentResults.DataSource = context.ConsignmentResults.Local.ToBindingList();//binding to dataGridView dataGridViewConsignmentResults.Columns["ConsignmentSummary"].Visible = false; dataGridViewConsignmentResults.Columns["Consignor"].Visible = false; dataGridViewConsignmentResults.Columns["Employee"].Visible = false; foreach (int colNum in new int[] { 3, 5, 7, 8 })// format money { dataGridViewConsignmentResults.Columns[colNum].DefaultCellStyle.Format = "N2"; dataGridViewConsignmentResults.Columns[colNum].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } dataGridViewConsignmentSummaries.DataSource = context.ConsignmentSummaries.Local.ToBindingList();//binding to dataGridView dataGridViewConsignmentSummaries.Columns["ConsignmentResults"].Visible = false; foreach (int colNum in new int[] { 1, 2, 4, 7, 9 })// format number { dataGridViewConsignmentSummaries.Columns[colNum].DefaultCellStyle.Format = "N0"; } foreach (int colNum in new int[] { 3, 5, 6, 8, 10, 11 })// format money { dataGridViewConsignmentSummaries.Columns[colNum].DefaultCellStyle.Format = "N2"; dataGridViewConsignmentSummaries.Columns[colNum].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } //combobox comboBoxConsignmentPeriods.SelectedIndexChanged += UpdateConsignmentPeriod; //button generate consignment results buttonGenerateConsignmentResults.Click += GenerateConsignmentResults; }
private void GenerateConsignmentResults(object sender, EventArgs e) { //consignment period must //1. must be greater than the largest consignmentPeriod (e.g. current is 201901) //2. must less than current month (e.g. 201904) //valid consignmentPeriods are 201902, 201903 //convert selected item in combobox to consignmentPeriod int consignmentPeriod = ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromString( (int)numericUpDownMonth.Value + "/" + (int)numericUpDownYear.Value); int upLimitConsignmentPeriod = ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromString( DateTime.Now.Month + "/" + DateTime.Now.Year); int downLimitConsignmentPeriod = context.ConsignmentSummaries.Max(summary => summary.ConsignmentPeriod); if (!ConsignmentStoreBusinessLogic.ValidateConsignmentPeriod(consignmentPeriod)) { FormHelper.ShowErrorMessageBox("Period must greater than " + ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(downLimitConsignmentPeriod) + " and less than " + ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(upLimitConsignmentPeriod)); return; } //Checking lost items GenerateConsignmentResultsForm generateConsignmentResultsForm = new GenerateConsignmentResultsForm(consignmentPeriod); generateConsignmentResultsForm.ShowDialog(); generateConsignmentResultsForm.Dispose(); //Load combobox again comboBoxConsignmentPeriods.Items.Clear(); //add consignment periods to combox box (format: month/year) foreach (var period in context.ConsignmentSummaries.Local.ToList()) { comboBoxConsignmentPeriods.Items.Add( ConsignmentStoreBusinessLogic.GetConsignmentPeriodFromInt(period.ConsignmentPeriod)); } }