private void btn_new_project_Click(object sender, EventArgs e)
{
SqlConnection conn = ConnectionClass.GetConnection_jodan_quote();
SqlCommand select_max_project = new SqlCommand(Statementsclass.select_max_project_id, conn);
SqlDataReader read_max_project_id = select_max_project.ExecuteReader();
if (read_max_project_id.Read())
{
Valuesclass.project_id = (Convert.ToInt32(read_max_project_id["Project ID"])) + 1;
read_max_project_id.Close();
}
ConnectionClass.Dispose_connection(conn);
SqlConnection conn2 = ConnectionClass.GetConnection_jodan_quote();
SqlCommand select_max_quote_id = new SqlCommand(Statementsclass.select_max_quote_id, conn2);
SqlDataReader read_max_quote_id = select_max_quote_id.ExecuteReader();
if (read_max_quote_id.Read())
{
Valuesclass.quote_id = (Convert.ToInt32(read_max_quote_id["Quote ID"])) + 1;
read_max_quote_id.Close();
}
Valuesclass.new_item_identifier = 1;
SqlCommand insert_new_project = new SqlCommand(Statementsclass.insert_new_project, conn2);
insert_new_project.Parameters.AddWithValue("@customer_id", Valuesclass.customer_account_ref);
insert_new_project.Parameters.AddWithValue("@quote_date", DateTime.Now);
insert_new_project.Parameters.AddWithValue("@created_by", loginclass.Login.globalFullName.ToString());
insert_new_project.ExecuteNonQuery();
ConnectionClass.Dispose_connection(conn2);
this.Hide();
FrmQuote project = new FrmQuote();
project.Show();
}
private void FrmQuoteReport_FormClosed(object sender, FormClosedEventArgs e)
{
FrmQuote quote = new FrmQuote();
quote.Show();
}
private void grid_quote_list_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int i = e.RowIndex;
Valuesclass.new_item_identifier = 0;
Valuesclass.customer_name = grid_quote_list.Rows[i].Cells["Customer Name"].Value.ToString();
Valuesclass.project_id = Convert.ToInt32(grid_quote_list.Rows[i].Cells["Project ID"].Value);
try
{
if (e.ColumnIndex == grid_quote_list.Columns["btn_open"].Index && e.RowIndex >= 0)
{
FrmQuote quote = new FrmQuote();
quote.Show();
this.Hide();
}
if (e.ColumnIndex == grid_quote_list.Columns["btn_copy"].Index && e.RowIndex >= 0)
{
Valuesclass.new_item_identifier = 1;
Valuesclass.project_id = Convert.ToInt32(grid_quote_list.Rows[i].Cells["Project ID"].Value);
DialogResult confirm = MessageBox.Show("Are You Sure You Want To Copy Quotation?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (confirm == DialogResult.Yes)
{
Valuesclass.customer_name = "";
if (Valuesclass.jodan_y_n == 0)
{
FrmCustomerSelect select = new FrmCustomerSelect();
select.ShowDialog();
}
else
{
Valuesclass.customer_name = "JODAN CONTRACTS LTD ";
Valuesclass.customer_account_ref = "JODAN CONTRACTS LTD ";
}
if (string.IsNullOrEmpty(Valuesclass.customer_name) == true)
{
return;
}
SqlConnection conn = ConnectionClass.GetConnection_jodan_quote();
SqlCommand copy_project = new SqlCommand(Statementsclass.copy_project, conn);
copy_project.Parameters.AddWithValue("@project_Id", Valuesclass.project_id);
SqlDataReader reader = copy_project.ExecuteReader();
if (reader.Read())
{
SqlConnection conn2 = ConnectionClass.GetConnection_jodan_quote();
SqlCommand insert_copied_project = new SqlCommand(Statementsclass.insert_copied_project, conn2);
insert_copied_project.Parameters.AddWithValue("@convertion_id", Valuesclass.project_id);
insert_copied_project.Parameters.AddWithValue("@customer_ref", Valuesclass.customer_account_ref);
insert_copied_project.Parameters.AddWithValue("@site_ref", reader["site_ref"].ToString());
insert_copied_project.Parameters.AddWithValue("@project_ref", reader["project_ref"].ToString());
insert_copied_project.Parameters.AddWithValue("@date_created", DateTime.Now);
insert_copied_project.Parameters.AddWithValue("@quote_status", reader["quote_status"].ToString());
insert_copied_project.Parameters.AddWithValue("@jodan_y_n", Valuesclass.jodan_y_n);
insert_copied_project.ExecuteNonQuery();
ConnectionClass.Dispose_connection(conn);
ConnectionClass.Dispose_connection(conn2);
}
Copy_Item();
// Copy_converted_hardware();
MessageBox.Show("Quotation Successfully Converted", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
FrmQuote quote = new FrmQuote();
quote.Show();
this.Hide();
}
else
{
return;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "");
}
}
