private void financial_Click(object sender, EventArgs e)
{
finace s = new finace();
s.Show();
s.sendid(eid);
}
public void Createprofit(string psname, string pdesi, string pnunii, string punici, string ptoti, string peid)
{
try
{
con.Open();
SqlCommand Cmd = new SqlCommand("INSERT INTO Profit (scrname , descp, nouni, unico, tot,eid) VALUES (@1, @2, @3, @4, @5,@6)", con);
Cmd.Parameters.AddWithValue("@1", psname);
Cmd.Parameters.AddWithValue("@2", pdesi);
Cmd.Parameters.AddWithValue("@3", pnunii);
Cmd.Parameters.AddWithValue("@4", punici);
Cmd.Parameters.AddWithValue("@5", ptoti);
Cmd.Parameters.AddWithValue("@6", peid);
Cmd.ExecuteNonQuery();
con.Close();
finace c = new finace();
c.profdis();
MessageBox.Show("Event Added");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void CreateCost(string pfname, string pdes, string pnuni, string punic, string ptot, string peid)
{
con.Open();
try
{
SqlCommand Cmd = new SqlCommand("INSERT INTO Cost (FacName , Descp, Nouni, unico, tot, eid) VALUES (@1, @2, @3, @4, @5,@6)", con);
Cmd.Parameters.AddWithValue("@1", pfname);
Cmd.Parameters.AddWithValue("@2", pdes);
Cmd.Parameters.AddWithValue("@3", pnuni);
Cmd.Parameters.AddWithValue("@4", punic);
Cmd.Parameters.AddWithValue("@5", ptot);
Cmd.Parameters.AddWithValue("@6", peid);
Cmd.ExecuteNonQuery();
finace d = new finace();
d.disp();
MessageBox.Show("Event Added");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
con.Close();
}