private void btnExceleAktar_Click(object sender, EventArgs e) { EMasa m = BLLMasa.MasaBul(Form1.masaAdi); Microsoft.Office.Interop.Excel.Application xla = new Microsoft.Office.Interop.Excel.Application(); xla.Visible = true; Microsoft.Office.Interop.Excel.Workbook wb = xla.Workbooks.Add(Microsoft.Office.Interop.Excel.XlSheetType.xlWorksheet); Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)xla.ActiveSheet; int i = 1; int j = 1; foreach (ListViewItem item in lvSiparisler.Items) { ws.Cells[i, j] = item.Text.ToString(); foreach (ListViewItem.ListViewSubItem subitem in item.SubItems) { ws.Cells[i, j] = subitem.Text.ToString(); j++; ws.Cells[i + 1, 1] = "Toplam: " + BLLMasaUrun.ToplamSiparis(m.TableName).ToString("c2"); } j = 1; i++; } }
public void Doldur() { lvSiparisler.Items.Clear(); EMasa m = BLLMasa.MasaBul(Form1.masaAdi); foreach (ESiparisler item in BLLSiparisler.SiparisleriBul(m.TableName)) { ListViewItem lvi = new ListViewItem(); lvi.Text = item.ProductName.ToString(); lvi.SubItems.Add(item.Quantity.ToString()); lvSiparisler.Items.Add(lvi); } lblToplam.Text = BLLMasaUrun.ToplamSiparis(m.TableName).ToString("c2"); }
public static EMasa MasaBul(string masaAdi) { SqlCommand cmd = new SqlCommand("sp_MasaBul", baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; baglanti.conn.Open(); cmd.Parameters.AddWithValue("masaAdi", masaAdi); SqlDataReader dr = cmd.ExecuteReader(); EMasa m = new EMasa(); while (dr.Read()) { m.ID = Convert.ToInt32(dr["ID"]); m.TableName = dr["TableName"].ToString(); } dr.Close(); baglanti.conn.Close(); return(m); }
//public static void MasalariOlustur(int masaNo) //{ // SqlCommand cmd = new SqlCommand("Insert into Tables (TableName) values (@masaAdi)", baglanti.conn); // string masaNosu = "M" + masaNo; // cmd.Parameters.AddWithValue("masaAdi", masaNosu); // baglanti.conn.Open(); // cmd.ExecuteNonQuery(); // baglanti.conn.Close(); //} public static List <EMasa> Listele() { SqlCommand cmd = new SqlCommand("sp_MasaListele", baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; baglanti.conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); List <EMasa> liste = new List <EMasa>(); while (dr.Read()) { EMasa m = new EMasa(); m.ID = Convert.ToInt32(dr["ID"]); m.TableName = dr["TableName"].ToString(); liste.Add(m); } dr.Close(); baglanti.conn.Close(); return(liste); }