private void button4_Click(object sender, EventArgs e) { classRetrieveSeatCatPrice r = new classRetrieveSeatCatPrice(); MessageBox.Show("A" + r.CatSeat_A); MessageBox.Show("B" + r.CatSeat_B); MessageBox.Show("C" + r.CatSeat_C); MessageBox.Show("D" + r.CatSeat_D); MessageBox.Show("E" + r.CatSeat_E); MessageBox.Show("F" + r.CatSeat_F); MessageBox.Show("G" + r.CatSeat_G); }
void RetrievePrices() { classRetrieveSeatCatPrice r = new classRetrieveSeatCatPrice(); lblPriceA.Text = r.CatSeat_A.ToString(); PriceA = r.CatSeat_A; lblPriceB.Text = r.CatSeat_B.ToString(); PriceB = r.CatSeat_B; lblPriceC.Text = r.CatSeat_C.ToString(); PriceC = r.CatSeat_C; lblPriceD.Text = r.CatSeat_D.ToString(); PriceD = r.CatSeat_D; lblPriceE.Text = r.CatSeat_E.ToString(); PriceE = r.CatSeat_E; lblPriceF.Text = r.CatSeat_F.ToString(); PriceF = r.CatSeat_F; lblPriceG.Text = r.CatSeat_G.ToString(); PriceG = r.CatSeat_G; }
void CreateColumn() { dataGridView1.DataSource = null; dataGridView1.Rows.Clear(); dataGridView1.ColumnCount = 5; dataGridView1.Columns[0].Name = "Category."; dataGridView1.Columns[1].Name = "Seat No."; dataGridView1.Columns[2].Name = "Price"; dataGridView1.Columns[3].Name = "Quantity"; dataGridView1.Columns[4].Name = "Ammount"; classRetrieveSeatCatPrice r = new classRetrieveSeatCatPrice(); PriceA = r.CatSeat_A; PriceB = r.CatSeat_B; PriceC = r.CatSeat_C; PriceD = r.CatSeat_D; PriceE = r.CatSeat_E; PriceF = r.CatSeat_F; PriceG = r.CatSeat_G; for (int i = 1; i <= 308; i++) { if (seatNo.Contains(i)) { if (i >= 1 && i <= 56) { strSeatNoA += i + ", "; intQtyA++; } else if ((i >= 57 && i <= 65) || (i >= 85 && i <= 93) || (i >= 113 && i <= 121)) { strSeatNoB += i + ", "; intQtyB++; } else if ((i >= 66 && i <= 75) || (i >= 93 && i <= 103) || (i >= 122 && i <= 131)) { strSeatNoC += i + ", "; intQtyC++; } else if ((i >= 76 && i <= 84) || (i >= 104 && i <= 112) || (i >= 132 && i <= 140)) { strSeatNoD += i + ", "; intQtyD++; } else if ((i >= 141 && i <= 154) || (i >= 169 && i <= 182) || (i >= 197 && i <= 210)) { strSeatNoE += i + ", "; intQtyE++; } else if ((i >= 155 && i <= 168) || (i >= 183 && i <= 196) || (i >= 197 && i <= 210)) { strSeatNoF += i + ", "; intQtyF++; } else if (i >= 225 && i <= 308) { strSeatNoG += i + ", "; intQtyG++; } } } totalA = intQtyA * PriceA; totalB = intQtyB * PriceB; totalC = intQtyC * PriceC; totalD = intQtyD * PriceD; totalE = intQtyE * PriceE; totalF = intQtyF * PriceF; totalG = intQtyG * PriceG; lblTotalAm.Text = (totalA + totalB + totalC + totalD + totalE + totalF + totalG).ToString(); if (totalA >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "A"; row.Cells[1].Value = strSeatNoA; row.Cells[2].Value = PriceA; row.Cells[3].Value = intQtyA; row.Cells[4].Value = totalA; dataGridView1.Rows.Add(row); } if (totalB >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "B"; row.Cells[1].Value = strSeatNoB; row.Cells[2].Value = PriceB; row.Cells[3].Value = intQtyB; row.Cells[4].Value = totalB; dataGridView1.Rows.Add(row); } if (totalC >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "C"; row.Cells[1].Value = strSeatNoC; row.Cells[2].Value = PriceC; row.Cells[3].Value = intQtyC; row.Cells[4].Value = totalC; dataGridView1.Rows.Add(row); } if (totalD >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "D"; row.Cells[1].Value = strSeatNoD; row.Cells[2].Value = PriceD; row.Cells[3].Value = intQtyD; row.Cells[4].Value = totalD; dataGridView1.Rows.Add(row); } if (totalE >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "E"; row.Cells[1].Value = strSeatNoE; row.Cells[2].Value = PriceE; row.Cells[3].Value = intQtyE; row.Cells[4].Value = totalE; dataGridView1.Rows.Add(row); } if (totalF >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "F"; row.Cells[1].Value = strSeatNoF; row.Cells[2].Value = PriceF; row.Cells[3].Value = intQtyF; row.Cells[4].Value = totalF; dataGridView1.Rows.Add(row); } if (totalG >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "G"; row.Cells[1].Value = strSeatNoG; row.Cells[2].Value = PriceG; row.Cells[3].Value = intQtyG; row.Cells[4].Value = totalG; dataGridView1.Rows.Add(row); } }
//public void GetData(List<string> seatNo, String Date, String screen, String SelSchedTime) // { // foreach (string seat in seatNo) // { // if (seat != null) // { // //newSeatNo += " " + seat + ","; // this.seatNo.Add(int.Parse(seat)); // } // } // lblDate.Text = Date; // lblScreen.Text = screen; // lblTime.Text = SelSchedTime; // //this.SelSchedTime = SelSchedTime; // //lblSeatNo.Text = "Seat No: " + newSeatNo; // //newDate = Date; // //newScreen = screen; // } void CreateColumn() { dataGridView1.DataSource = null; dataGridView1.Rows.Clear(); dataGridView1.ColumnCount = 5; dataGridView1.Columns[0].Name = "Category"; dataGridView1.Columns[1].Name = "Seat No."; dataGridView1.Columns[2].Name = "Price"; dataGridView1.Columns[3].Name = "Quantity"; dataGridView1.Columns[4].Name = "Ammount"; dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGridView1.Columns.Cast <DataGridViewColumn>().ToList().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable); dataGridView1.DefaultCellStyle.Font = new Font("Tahoma", 12, FontStyle.Regular); classRetrieveSeatCatPrice r = new classRetrieveSeatCatPrice(); PriceA = r.CatSeat_A; PriceB = r.CatSeat_B; PriceC = r.CatSeat_C; PriceD = r.CatSeat_D; PriceE = r.CatSeat_E; PriceF = r.CatSeat_F; PriceG = r.CatSeat_G; for (int i = 0; i < seatNo.Count; i++) //for (int i = 1; i <= 308; i++) { if (seatNo[i].Contains("A")) { strSeatNoA += seatNo[i].ToString() + ", "; intQtyA++; } else if (seatNo[i].Contains("B")) { strSeatNoB += seatNo[i].ToString() + ", "; intQtyB++; } else if (seatNo[i].Contains("C")) { strSeatNoC += seatNo[i].ToString() + ", "; intQtyC++; } else if (seatNo[i].Contains("D")) { strSeatNoD += seatNo[i].ToString() + ", "; intQtyD++; } else if (seatNo[i].Contains("E")) { strSeatNoE += seatNo[i].ToString() + ", "; intQtyE++; } else if (seatNo[i].Contains("F")) { strSeatNoF += seatNo[i].ToString() + ", "; intQtyF++; } else if (seatNo[i].Contains("G")) { strSeatNoG += seatNo[i].ToString() + ", "; intQtyG++; } else { MessageBox.Show(seatNo[i]); } //if (seatNo.Contains(i)) //{ // if (i >= 1 && i <= 56) // { // strSeatNoA += i + ", "; // intQtyA++; // } // else if ((i >= 57 && i <= 65) || (i >= 85 && i <= 93) || (i >= 113 && i <= 121)) // { // strSeatNoB += i + ", "; // intQtyB++; // } // else if ((i >= 66 && i <= 75) || (i >= 93 && i <= 103) || (i >= 122 && i <= 131)) // { // strSeatNoC += i + ", "; // intQtyC++; // } // else if ((i >= 76 && i <= 84) || (i >= 104 && i <= 112) || (i >= 132 && i <= 140)) // { // strSeatNoD += i + ", "; // intQtyD++; // } // else if ((i >= 141 && i <= 154) || (i >= 169 && i <= 182) || (i >= 197 && i <= 210)) // { // strSeatNoE += i + ", "; // intQtyE++; // } // else if ((i >= 155 && i <= 168) || (i >= 183 && i <= 196) || (i >= 197 && i <= 210)) // { // strSeatNoF += i + ", "; // intQtyF++; // } // else if (i >= 225 && i <= 308) // { // strSeatNoG += i + ", "; // intQtyG++; // } // //} } totalA = intQtyA * PriceA; totalB = intQtyB * PriceB; totalC = intQtyC * PriceC; totalD = intQtyD * PriceD; totalE = intQtyE * PriceE; totalF = intQtyF * PriceF; totalG = intQtyG * PriceG; double SubTotal = totalA + totalB + totalC + totalD + totalE + totalF + totalG; DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt.Columns.Add("Category"); dt.Columns.Add("Seat No", typeof(string)); dt.Columns.Add("Price", typeof(string)); dt.Columns.Add("Quantity", typeof(string)); dt.Columns.Add("Ammount", typeof(string)); if (totalA >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "A"; row.Cells[1].Value = strSeatNoA; row.Cells[2].Value = PriceA; row.Cells[3].Value = intQtyA; row.Cells[4].Value = totalA; dataGridView1.Rows.Add(row); dt.Rows.Add("A", strSeatNoA, PriceA, intQtyA, totalA); } if (totalB >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "B"; row.Cells[1].Value = strSeatNoB; row.Cells[2].Value = PriceB; row.Cells[3].Value = intQtyB; row.Cells[4].Value = totalB; dataGridView1.Rows.Add(row); dt.Rows.Add("B", strSeatNoB, PriceB, intQtyB, totalB); } if (totalC >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "C"; row.Cells[1].Value = strSeatNoC; row.Cells[2].Value = PriceC; row.Cells[3].Value = intQtyC; row.Cells[4].Value = totalC; dataGridView1.Rows.Add(row); } if (totalD >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "D"; row.Cells[1].Value = strSeatNoD; row.Cells[2].Value = PriceD; row.Cells[3].Value = intQtyD; row.Cells[4].Value = totalD; dataGridView1.Rows.Add(row); dt.Rows.Add("D", strSeatNoD, PriceD, intQtyD, totalD); } if (totalE >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "E"; row.Cells[1].Value = strSeatNoE; row.Cells[2].Value = PriceE; row.Cells[3].Value = intQtyE; row.Cells[4].Value = totalE; dataGridView1.Rows.Add(row); dt.Rows.Add("E", strSeatNoE, PriceE, intQtyE, totalE); } if (totalF >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "F"; row.Cells[1].Value = strSeatNoF; row.Cells[2].Value = PriceF; row.Cells[3].Value = intQtyF; row.Cells[4].Value = totalF; dataGridView1.Rows.Add(row); dt.Rows.Add("F", strSeatNoF, PriceF, intQtyF, totalF); } if (totalG >= 1) { DataGridViewRow row = (DataGridViewRow)dataGridView1.Rows[0].Clone(); row.Cells[0].Value = "G"; row.Cells[1].Value = strSeatNoG; row.Cells[2].Value = PriceG; row.Cells[3].Value = intQtyG; row.Cells[4].Value = totalG; dataGridView1.Rows.Add(row); dt.Rows.Add("G", strSeatNoG, PriceG, intQtyG, totalG); } ds.Tables.Add(dt); ds.WriteXmlSchema("OrderDetails.xml"); //FormViewerTesting cd = new FormViewerTesting(); //cd.Show(); DataGridViewRow Divider = (DataGridViewRow)dataGridView1.Rows[0].Clone(); Divider.DividerHeight = 1; dataGridView1.Rows.Add(Divider); DataGridViewRow rowSubTotal = (DataGridViewRow)dataGridView1.Rows[0].Clone(); rowSubTotal.Cells[3].Value = "SubTotal : "; rowSubTotal.Cells[4].Value = SubTotal.ToString(); rowSubTotal.Cells[4].Style.Alignment = DataGridViewContentAlignment.MiddleLeft; dataGridView1.Rows.Add(rowSubTotal); DataGridViewRow rowTax = (DataGridViewRow)dataGridView1.Rows[0].Clone(); rowTax.Cells[3].Value = "Add VAT(12%): "; rowTax.Cells[4].Value = String.Format("{0:0.00}", SubTotal * .12); rowTax.Cells[4].Style.Alignment = DataGridViewContentAlignment.MiddleLeft; rowTax.DividerHeight = 2; dataGridView1.Rows.Add(rowTax); DataGridViewRow rowTotalAmmount = (DataGridViewRow)dataGridView1.Rows[0].Clone(); rowTotalAmmount.DefaultCellStyle.Font = new Font("Tahoma", 14, FontStyle.Bold); rowTotalAmmount.Cells[3].Value = "Total Ammount: "; double TotalAmmount = SubTotal * 1.12; rowTotalAmmount.Cells[4].Value = String.Format("{0:0.00}", TotalAmmount); rowTotalAmmount.Cells[4].Style.Alignment = DataGridViewContentAlignment.MiddleLeft; dataGridView1.Rows.Add(rowTotalAmmount); classTransaction c = new classTransaction(); c.setTotalAmmount(TotalAmmount); }