private void button1_Click(object sender, EventArgs e)
{
DBManager manager=new DBManager();
SqlConnection connection = manager.Connection();
TempOrderGateway gateway=new TempOrderGateway();
List<TempOrder> orders = gateway.GetempOrders();
InvoiceUI invoice = new InvoiceUI(orders);
invoice.ShowDialog();
System.Windows.Forms.DialogResult dialog = MessageBox.Show("Did you print the document?", "Print Message",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialog == DialogResult.Yes)
{
String deletequery = "delete from Temp_Order_Hold";
SqlCommand command1 = new SqlCommand(deletequery, connection);
connection.Open();
command1.ExecuteNonQuery();
string que = "DBCC CHECKIDENT (Temp_Order_Hold,Reseed,0)";
command1=new SqlCommand(que,connection);
command1.ExecuteNonQuery();
string que1 = "set identity_insert Temp_Order_Hold on";
command1=new SqlCommand(que1,connection);
command1.ExecuteNonQuery();
string insQuery = "insert into Order_Memo_Counter values(@date)";
command1 = new SqlCommand(insQuery, connection);
command1.Parameters.Clear();
command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
command1.ExecuteNonQuery();
memoNumver = GetLastMemoNumber();
//string insQuery = "insert into Due_Memo_Counter values(@date)";
//command1 = new SqlCommand(insQuery, connection);
//command1.Parameters.Clear();
//command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
//command1.ExecuteNonQuery();
//memoNumver = GetLastMemoNumber();
}
else if (dialog == DialogResult.No)
{
System.Windows.Forms.DialogResult dialog1 = MessageBox.Show("Are you want to print now?",
"Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialog1 == DialogResult.Yes)
{
invoice = new InvoiceUI(orders);
invoice.ShowDialog();
String deletequery = "delete from Temp_Order_Hold";
SqlCommand command1 = new SqlCommand(deletequery, connection);
connection.Open();
command1.ExecuteNonQuery();
string que = "DBCC CHECKIDENT (Temp_Order_Hold,Reseed,0)";
command1 = new SqlCommand(que, connection);
command1.ExecuteNonQuery();
string que1 = "set identity_insert Temp_Order_Hold on";
command1 = new SqlCommand(que1, connection);
command1.ExecuteNonQuery();
string insQuery = "insert into Order_Memo_Counter values(@date)";
command1 = new SqlCommand(insQuery, connection);
command1.Parameters.Clear();
command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
command1.ExecuteNonQuery();
memoNumver = GetLastMemoNumber();
DialogResult d2= MessageBox.Show(" Print Sucessful! Are you want ot exit? ", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (d2==DialogResult.Yes)
{
this.Close();
}
else if (d2==DialogResult.No)
{
//OrderUI odUi=new OrderUI();
//odUi.ShowDialog();
}
}
else if (dialog1 == DialogResult.No)
{
this.Close();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
TempOrderGateway gateway = new TempOrderGateway();
List <TempOrder> orders = gateway.GetempOrders();
InvoiceUI invoice = new InvoiceUI(orders);
invoice.ShowDialog();
System.Windows.Forms.DialogResult dialog = MessageBox.Show("Did you print the document?", "Print Message",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialog == DialogResult.Yes)
{
String deletequery = "delete from Temp_Order_Hold";
SqlCommand command1 = new SqlCommand(deletequery, connection);
connection.Open();
command1.ExecuteNonQuery();
string que = "DBCC CHECKIDENT (Temp_Order_Hold,Reseed,0)";
command1 = new SqlCommand(que, connection);
command1.ExecuteNonQuery();
string que1 = "set identity_insert Temp_Order_Hold on";
command1 = new SqlCommand(que1, connection);
command1.ExecuteNonQuery();
string insQuery = "insert into Order_Memo_Counter values(@date)";
command1 = new SqlCommand(insQuery, connection);
command1.Parameters.Clear();
command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
command1.ExecuteNonQuery();
memoNumver = GetLastMemoNumber();
//string insQuery = "insert into Due_Memo_Counter values(@date)";
//command1 = new SqlCommand(insQuery, connection);
//command1.Parameters.Clear();
//command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
//command1.ExecuteNonQuery();
//memoNumver = GetLastMemoNumber();
}
else if (dialog == DialogResult.No)
{
System.Windows.Forms.DialogResult dialog1 = MessageBox.Show("Are you want to print now?",
"Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialog1 == DialogResult.Yes)
{
invoice = new InvoiceUI(orders);
invoice.ShowDialog();
String deletequery = "delete from Temp_Order_Hold";
SqlCommand command1 = new SqlCommand(deletequery, connection);
connection.Open();
command1.ExecuteNonQuery();
string que = "DBCC CHECKIDENT (Temp_Order_Hold,Reseed,0)";
command1 = new SqlCommand(que, connection);
command1.ExecuteNonQuery();
string que1 = "set identity_insert Temp_Order_Hold on";
command1 = new SqlCommand(que1, connection);
command1.ExecuteNonQuery();
string insQuery = "insert into Order_Memo_Counter values(@date)";
command1 = new SqlCommand(insQuery, connection);
command1.Parameters.Clear();
command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
command1.ExecuteNonQuery();
memoNumver = GetLastMemoNumber();
DialogResult d2 = MessageBox.Show(" Print Sucessful! Are you want ot exit? ", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (d2 == DialogResult.Yes)
{
this.Close();
}
else if (d2 == DialogResult.No)
{
//OrderUI odUi=new OrderUI();
//odUi.ShowDialog();
}
}
else if (dialog1 == DialogResult.No)
{
this.Close();
}
}
}