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));
}
