public void TestCreate() { Business b = new Business(); ent.Employeeid = 27; ent.Firstname = "Prakash"; ent.Lastname = "Pawar"; ent.Birthdate = "5/5/1945"; ent.Sex = "Male"; int i= b.CreateEmp(ent); Assert.AreEqual(1, i); }
public int CreateEmp(Entity emp) { //con.Open(); //SqlCommand cmd = new SqlCommand("insert into Emp(Employeeid,Firstname,Lastname,Birthdate,Sex) values(@Eid,@First,@Last,@Birth,@Esex)", con); //cmd.Parameters.AddWithValue("@Eid", emp.Employeeid); //cmd.Parameters.AddWithValue("@First", emp.Firstname); //cmd.Parameters.AddWithValue("@Last", emp.Lastname); //cmd.Parameters.AddWithValue("@Birth", emp.Birthdate); //cmd.Parameters.AddWithValue("@Esex", emp.Sex); //int i = cmd.ExecuteNonQuery(); //con.Close(); //if (i > 0) //{ // return "Record Insert Successfully"; //} //else //{ // return " Error In Record Insertion"; //} Business bl = new Business(); return bl.CreateEmp(emp); }
public int Employee(Entity ent) { Business b = new Business(); return b.CreateEmp(ent); }