private void Button1_Click(object sender, EventArgs e)
{
try
{
string forward = Convert.ToString(cmboxforward.Text);
string transfertoemployee = Convert.ToString(cmbotransfer.Text);
transfer.transferto(transfertoemployee);
transfer.transferto(forward);
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "insert into transfer values (@employeetransfer, @forward, @title, @date, @approval, @discription,@note )";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.cmd.Parameters.AddWithValue("@employeetransfer", cmbotransfer.Text);
obj.cmd.Parameters.AddWithValue("@forward", cmboxforward.Text);
obj.cmd.Parameters.AddWithValue("@title", txttitletra.Text);
obj.cmd.Parameters.AddWithValue("@date", dateTimePicker1tra.Text);
obj.cmd.Parameters.AddWithValue("@approval", txtapprovaltra.Text);
obj.cmd.Parameters.AddWithValue("@note", txtnotetra.Text);
obj.cmd.Parameters.AddWithValue("@discription", txtrichtra.Text);
//obj.cmd.Parameters.AddWithValue("@transfernum", txtnum.Text);
obj.cmd.ExecuteNonQuery();
obj.con.Close();
MessageBox.Show("Data Saved Successfully");
}
catch
{
MessageBox.Show("there is an Error", "oops!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
//double oldsal = Convert.ToDouble(txtoldsalary.Text);
pro.oldsalary = Convert.ToDouble(txtoldsalary.Text);
txtcursalary.Text = pro.calculatecurrentsalary().ToString();
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "insert into promotions values (@promotion, @forward, @title, @date,@currentsal,@oldsal,@approval, @discription,@note )";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.cmd.Parameters.AddWithValue("@promotion", txtpromotion.Text);
obj.cmd.Parameters.AddWithValue("@forward", txtforwardpro.Text);
obj.cmd.Parameters.AddWithValue("@title", txttitlepro.Text);
obj.cmd.Parameters.AddWithValue("@date", dateTimePicker1pro.Text);
obj.cmd.Parameters.AddWithValue("@approval", txtapppro.Text);
obj.cmd.Parameters.AddWithValue("@note", txtnotepro.Text);
obj.cmd.Parameters.AddWithValue("@discription", txtrichpro.Text);
obj.cmd.Parameters.AddWithValue("@currentsal", txtcursalary.Text);
obj.cmd.Parameters.AddWithValue("@oldsal", txtoldsalary.Text);
obj.cmd.ExecuteNonQuery();
obj.con.Close();
MessageBox.Show("data saved ");
}
catch
{
MessageBox.Show("there is an Error", "sorry!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
achievment.employeename = txtemployeeach.Text;
achievment.forwarapp = txtforwardach.Text;
achievment.achievmenttitle = txttitleach.Text;
achievment.approval = txtapprovalach.Text;
achievment.discription = richboxach.Text;
achievment.note = txtnoteach.Text;
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "insert into achievements values (@employee, @forward, @title, @date, @approval, @discription,@note )";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.cmd.Parameters.AddWithValue("@employee", txtemployeeach.Text);
obj.cmd.Parameters.AddWithValue("@forward", txtforwardach.Text);
obj.cmd.Parameters.AddWithValue("@title", txttitleach.Text);
obj.cmd.Parameters.AddWithValue("@date", dateTimePicker1.Value.ToString());
obj.cmd.Parameters.AddWithValue("@approval", txtapprovalach.Text);
obj.cmd.Parameters.AddWithValue("@note", txtnoteach.Text);
obj.cmd.Parameters.AddWithValue("@discription", richboxach.Text);
obj.cmd.ExecuteNonQuery();
obj.con.Close();
MessageBox.Show("Data Saved Successfully");
}
catch
{
MessageBox.Show("there is an Error", "sorry!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "select employee, forward,title,date,approval from achievements where employee like '%'+ '" + txtsearch.Text + "' + '%'";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.dr = obj.cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(obj.dr);
DataGridView1.AutoGenerateColumns = true;
DataGridView1.DataSource = dt;
DataGridView1.Refresh();
obj.con.Close();
}
void filldata()
{
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "select * from achievements order by employee";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.dr = obj.cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(obj.dr);
DataGridView1.AutoGenerateColumns = true;
DataGridView1.DataSource = dt;
DataGridView1.Refresh();
obj.con.Close();
}
private void Button1_Click(object sender, EventArgs e)
{
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "insert into achievements values (@employee, @forward, @title, @date, @approval, @discription,@note )";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.cmd.Parameters.AddWithValue("@employee", txtemployeeach.Text);
obj.cmd.Parameters.AddWithValue("@forward", txtforwardach.Text);
obj.cmd.Parameters.AddWithValue("@title", txttitleach.Text);
obj.cmd.Parameters.AddWithValue("@date", dateTimePicker1.Value.ToString());
obj.cmd.Parameters.AddWithValue("@approval", txtapprovalach.Text);
obj.cmd.Parameters.AddWithValue("@note", txtnoteach.Text);
obj.cmd.Parameters.AddWithValue("@discription", richboxach.Text);
obj.cmd.ExecuteNonQuery();
obj.con.Close();
MessageBox.Show("Data Saved Successfully");
}
private void transfer2_Load(object sender, EventArgs e)
{
cmbotransfer.Items.Clear();
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "select name from information order by id";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(obj.cmd);
da1.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
cmbotransfer.Items.Add(dr["name"]).ToString();;
}
obj.con.Close();
}
private void button2_Click(object sender, EventArgs e)
{
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "insert into information values (@id, @name, @type, @dept, @campany, @Age, @Gender, @category, @phone, @email, @date, @username, @password )";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.cmd.Parameters.AddWithValue("@id", txtid.Text);
obj.cmd.Parameters.AddWithValue("@name", txtname.Text);
obj.cmd.Parameters.AddWithValue("@type", txttype.Text);
obj.cmd.Parameters.AddWithValue("@date", DateTimePicker1.Value.ToString());
obj.cmd.Parameters.AddWithValue("@dept", txtdept.Text);
obj.cmd.Parameters.AddWithValue("@email", txtemail.Text);
obj.cmd.Parameters.AddWithValue("@phone", txtphone.Text);
obj.cmd.Parameters.AddWithValue("@Gender", txtcombo.Text);
obj.cmd.Parameters.AddWithValue("@campany", txtcomname.Text);
obj.cmd.Parameters.AddWithValue("@category", txtcat.Text);
obj.cmd.Parameters.AddWithValue("@username", txtuser.Text);
obj.cmd.Parameters.AddWithValue("@password", txtpass.Text);
obj.cmd.Parameters.AddWithValue("@Age", txtage.Text);
obj.cmd.ExecuteNonQuery();
obj.con.Close();
MessageBox.Show("Data Saved Successfully");
txtid.Text = " ";
txtname.Text = " ";
txttype.Text = " ";
txtdept.Text = " ";
txtemail.Text = " ";
txtphone.Text = " ";
txtcombo.Text = " ";
txtcat.Text = " ";
txtuser.Text = " ";
txtpass.Text = " ";
txtage.Text = " ";
txtcomname.Text = " ";
}
private void btnLogIn_Click(object sender, EventArgs e)
{
Myconnection obj = new Myconnection();
obj.con.Open();
obj.qry = "select * from information where username='******'" + " and password='******'";
obj.cmd = new SqlCommand(obj.qry, obj.con);
obj.dr = obj.cmd.ExecuteReader();
if (obj.dr.Read() == true)
{
this.Hide();
main_form main = new main_form();
main.Show();
obj.con.Close();
}
else
{
obj.con.Close();
MessageBox.Show("Your User Name or Password is Incorrect Pls Try Again");
txtUserName.Text = "";
txtPassword.Text = "";
txtUserName.Focus();
}
}
