private void button1_Click(object sender, EventArgs e)
{
EmpDetails obj = new EmpDetails();
obj.EmpId = Convert.ToInt32(textemp.Text);
obj.EmpName = textName.Text;
obj.Age = Convert.ToInt32(textAge.Text);
if (radioButton1.Checked)
{
obj.Gender = radioButton1.Text;
}
else
if (radioButton2.Checked)
{
obj.Gender = radioButton2.Text;
}
//MessageBox.Show(obj.Gender);
obj.Location = textLocation.Text;
obj.Mobile = Convert.ToInt64(textMobile.Text);
obj.Email = textMail.Text;
obj.Address = textAddress.Text;
int result = obj.getDetails(obj.EmpId, obj.EmpName, obj.Age, obj.Gender, obj.Location, obj.Mobile, obj.Email, obj.Address);
if (result == 1)
{
MessageBox.Show("Details Added");
}
else
{
MessageBox.Show("Company not Added");
}
}
public List<EmpDetails> viewBang()
{
List<EmpDetails> old = new List<EmpDetails>();
string name = "bangalore";
SqlConnection connect = new SqlConnection("server=D11-PC\\SQLEXPRESS; database=employee; Integrated Security=true");
SqlCommand command = new SqlCommand("select * from Emp where Location='" + name + "'", connect);
connect.Open();
SqlDataReader readers = command.ExecuteReader();
while (readers.Read())
{
EmpDetails obj = new EmpDetails();
obj.EmpId = Convert.ToInt32(readers["EmpID"]);
obj.EmpName=Convert.ToString(readers["EmpName"]);
obj.Age = Convert.ToInt32(readers["Age"]);
obj.Gender=Convert.ToString(readers["Gender"]);
obj.Location = Convert.ToString(readers["Location"]);
obj.Mobile = Convert.ToInt64(readers["Mobile"]);
obj.Email = Convert.ToString(readers["Email"]);
obj.Address = Convert.ToString(readers["Address"]);
old.Add(obj);
}
//old.Add(obj);
return old;
}
