public Employee getObject(string id) { Employee e = new Employee(); SqlDataReader reader = MyConnect.getReader("select * from Employee where ID_Emp=N'" + id + "'"); while (reader.Read()) { Image image = null; if (!reader.IsDBNull(6)) { image = ImageSQL.ByteArrayToImage((byte[])reader[6]); } e = new Employee(reader.GetString(0), reader.GetString(1), reader.GetDateTime(2), reader.GetBoolean(3), reader.GetString(4), long.Parse(reader.GetInt64(5).ToString()), image); } reader.Close(); return(e); }
//Get list emp public List <Employee> getList() { List <Employee> mList = new List <Employee>(); try { SqlDataReader reader = MyConnect.getReader("select * from Employee"); while (reader.Read()) { Image image = null; if (!reader.IsDBNull(6)) { image = ImageSQL.ByteArrayToImage((byte[])reader[6]); } Employee e = new Employee(reader.GetString(0), reader.GetString(1), reader.GetDateTime(2), reader.GetBoolean(3), reader.GetString(4), long.Parse(reader.GetInt64(5).ToString()), image); mList.Add(e); } MyConnect.Disconncet(); reader.Close(); } catch { return(null); } return(mList); }
public bool UpdateObject(Employee o) { byte[] image = o.EmpImage == null ? null : ImageSQL.ImageToByteArray(o.EmpImage); return(MyConnect.MyExecuteQuery("update Employee set Name_Emp=N'" + SolveInput.StandardizedString(o.Name) + "',BirthDate='" + o.BirthDate.ToString("yyyy-MM-dd") + "',Sex=" + (o.Sex ? 1 : 0) + ",Address=N'" + o.Address + "',PhoneNumber=" + o.PhoneNumber + ",EmpImage=@image where ID_Emp=N'" + o.Id + "'", image)); }
public bool AddObject(Employee o) { byte[] image = o.EmpImage == null?null: ImageSQL.ImageToByteArray(o.EmpImage); return(MyConnect.MyExecuteQuery("insert into Employee values(N'" + o.Id + "',N'" + SolveInput.StandardizedString(o.Name) + "','" + o.BirthDate.ToString("yyyy-MM-dd") + "'," + (o.Sex ? 1 : 0) + ",N'" + o.Address + "'," + o.PhoneNumber + ",@image)", image)); }