private void button5_Click(object sender, EventArgs e) { int numberOfBill; ClientBill clientB = context.ClientBills.OrderByDescending(c => c.ID).FirstOrDefault(); if (clientB == null) { numberOfBill = 1; labelNumberBill.Text = numberOfBill.ToString(); } else { numberOfBill = int.Parse(clientB.ID.ToString()); numberOfBill++; labelNumberBill.Text = numberOfBill.ToString(); } }
private void FormOfClient_Load(object sender, EventArgs e) { int numberOfBill; ClientBill clientB = context.ClientBills.OrderByDescending(c => c.ID).FirstOrDefault(); if (clientB == null) { SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-9HH57Q0\MSSQLSEVEREX;Initial Catalog=project;Integrated Security=True"); SqlCommand command = new SqlCommand(); connection.Open(); command.Connection = connection; command.CommandText = "DBCC CHECKIDENT ('clientBills',RESEED,0)"; command.ExecuteNonQuery(); connection.Close(); numberOfBill = 1; labelNumberBill.Text = numberOfBill.ToString(); } else { numberOfBill = int.Parse(clientB.ID.ToString()); numberOfBill++; labelNumberBill.Text = numberOfBill.ToString(); } List <Representitive> rep = context.Representitives.ToList(); rpresentiveCombo.DataSource = rep; rpresentiveCombo.DisplayMember = "Name"; //------------------------fill name of product------------ List <Product> ProductList = context.Products.ToList(); productComboFromRepresentive.DataSource = ProductList; productComboFromRepresentive.DisplayMember = "Name"; }