public List <Employee1> GetRecordbyId(int id) { List <Employee1> li = new List <Employee1>(); DataTable dt1 = new DataTable(); string query = "select * from Employee where EmpId='" + id + "'"; dt1 = myobject.Getdata(query); if (dt1.Rows.Count > 0) { for (int i = 0; i < dt1.Rows.Count; i++) { Employee1 emp = new Employee1 { EmpId = Convert.ToInt32(dt1.Rows[i]["EmpId"]), EmpLastName = dt1.Rows[i]["EmpLastName"].ToString(), EmpFirstMidName = dt1.Rows[i]["EmpFirstMidName"].ToString(), EmpEmail = dt1.Rows[i]["EmpEmail"].ToString(), CompanyName = dt1.Rows[i]["CompanyName"].ToString(), Location1 = dt1.Rows[i]["Location1"].ToString(), Dept = dt1.Rows[i]["Dept"].ToString() }; li.Add(emp); } return(li); } else { return(li); } }
public List <Employee1> ShowAll() { List <Employee1> li = new List <Employee1>(); string s = "select * from Employee"; DataTable dt = new DataTable(); dt = myobject.Getdata(s); for (int i = 0; i < dt.Rows.Count; i++) { Employee1 emp = new Employee1 { EmpId = Convert.ToInt32(dt.Rows[i]["EmpId"]), EmpLastName = dt.Rows[i]["EmpLastName"].ToString(), EmpFirstMidName = dt.Rows[i]["EmpFirstMidName"].ToString(), EmpEmail = dt.Rows[i]["EmpEmail"].ToString(), CompanyName = dt.Rows[i]["CompanyName"].ToString(), Location1 = dt.Rows[i]["Location1"].ToString(), Dept = dt.Rows[i]["Dept"].ToString() }; li.Add(emp); } return(li); }
public bool UpdateData(Employee1 obj) { string query = "update Employee set EmpLastName='" + obj.EmpLastName + "',EmpFirstMidName='" + obj.EmpFirstMidName + "',EmpEmail='" + obj.EmpEmail + "',CompanyName='" + obj.CompanyName + "',Location1='" + obj.Location1 + "',Dept='" + obj.Dept + "' where EmpId='" + obj.EmpId + "' "; bool x = myobject.DML(query); return(x); }
public bool DeleteData(Employee1 obj) { string query = "Delete from Employee where EmpId='" + obj.EmpId + "'"; bool x = myobject.DML(query); return(x); }
public bool InsertData(Employee1 obj) { string query = "insert into Employee(EmpLastName,EmpFirstMidName,EmpEmail,CompanyName,Location1,Dept) values('" + obj.EmpLastName + "','" + obj.EmpFirstMidName + "','" + obj.EmpEmail + "','" + obj.CompanyName + "','" + obj.Location1 + "','" + obj.Dept + "')"; bool x = myobject.DML(query); return(x); }