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