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