public Image GetEmployeePhoto(string employeeNumber) { string sql = "select Photo from Photo where EmployeeNumber=@en"; var reader = SqlHelper.ExecuteReader(conn, System.Data.CommandType.Text, sql, new SqlParameter("@en", employeeNumber)); try { if (reader.Read()) { if (!Convert.IsDBNull(reader["Photo"])) { byte[] bImg = (byte[])reader["Photo"]; return(AnnualPartySqlHelper.GetImage(bImg)); } else { return(GetNoPhotoImage()); } } return(GetNoPhotoImage()); } finally { reader.Close(); } }
public void LoadWithPhoto(Photo reader) { if (reader != null) { byte[] bImg = reader.PhotoData; this.Photo = AnnualPartySqlHelper.GetImage(bImg); } }
public void LoadWithPhoto(IDataReader reader) { LoadBasic(reader); if (!Convert.IsDBNull(reader["Photo"])) { byte[] bImg = (byte[])reader["Photo"]; this.Photo = AnnualPartySqlHelper.GetImage(bImg); } }
public Image GetEmployeePhoto(string employeeNumber) { AnnualPartyEntities entities = new AnnualPartyEntities(); var photo = entities.Photo.SingleOrDefault(e => e.EmployeeNumber == employeeNumber); if (photo != null) { byte[] bImg = photo.PhotoData; return(AnnualPartySqlHelper.GetImage(bImg)); } else { return(GetNoPhotoImage()); } // string sql = "select Photo from Photo where EmployeeNumber=@en"; //var reader = SqlHelper.ExecuteReader(conn, System.Data.CommandType.Text, sql, new SqlParameter("@en",employeeNumber)); //try //{ // if (reader.Read()) // { // if (!Convert.IsDBNull(reader["Photo"])) // { // byte[] bImg = (byte[])reader["Photo"]; // return AnnualPartySqlHelper.GetImage(bImg); // } // else // { // return GetNoPhotoImage(); // } // } // return GetNoPhotoImage(); //} //finally //{ // reader.Close(); //} }