private void button2_Click(object sender, EventArgs e)
{
if (i == 0)
{
ClanWork db = new ClanWork();
db.NewMembTabs.Load();
NewMembTab nm = new NewMembTab();
try
{
nm.FirstName = textBox1.Text;
nm.LastName = textBox2.Text;
nm.Log = textBox3.Text;
nm.Pass = textBox4.Text;
nm.WantedPosition = comboBox1.SelectedItem.ToString();
db.NewMembTabs.Add(nm);
db.SaveChanges();
label6.Visible = true;
i++;
}
catch (Exception ex)
{
label7.Visible = true;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (ActionForm.Pos == "Pawn")
{
MessageBox.Show("You don't have rights to do given action!");
}
else
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-J8I3ABH,1433;Initial Catalog=ClanWork;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("SELECT TOP 1 * FROM Members ORDER BY ID DESC", con);
int i = cmd.ExecuteNonQuery();
con.Close();
if (dataGridView1.SelectedRows.Count > 0)
{
int index = dataGridView1.SelectedRows[0].Index;
int id = 0;
bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
if (converted == false)
{
return;
}
ClanWork db = new ClanWork();
NewMembTab nm = db.NewMembTabs.Find(id);
Login lg = new Login {
Log = nm.Log, Pass = nm.Pass, Memberid = i + 1
};
Member mb = new Member {
FirstName = nm.FirstName, LastName = nm.LastName, Position = nm.WantedPosition, Job = "Not yet", id = i + 1
};
db.Logins.Add(lg);
db.Members.Add(mb);
db.NewMembTabs.Remove(nm);
try
{
db.SaveChanges();
dataGridView1.Update();
dataGridView1.RefreshEdit();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
MessageBox.Show("Object: " + validationError.Entry.Entity.ToString());
foreach (DbValidationError err in validationError.ValidationErrors)
{
MessageBox.Show(err.ErrorMessage + "");
}
}
}
string connectionString = @"Data Source=.\MSSQLSERVER,1433;Initial Catalog=ClanWork;Integrated Security=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand c = new SqlCommand("Insert into History VALUES(@1,@2)", connection);
c.Parameters.AddWithValue("@1", ActionForm.Pos + " " + LoginForm.Namez + " " + "invited " + mb.Position + " " + mb.FirstName);
c.Parameters.AddWithValue("@2", DateTime.Now);
c.ExecuteNonQuery();
connection.Close();
}
}
}
}