private void Load_Profile_Picture()
{
string sql = "SELECT * FROM USERS WHERE PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND USER_NAME='" + Session["USER_NAME"].ToString() + "'";
string FilePath = "";
string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/";
using (OracleConnection conn = WebTools.GetIpmsConnection())
{
using (OracleCommand cmd = new OracleCommand(sql, conn))
{
using (OracleDataReader dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
if (dataReader["ACCOUNT_PIC"] != DBNull.Value)
{
Random rnd = new Random();
string file_name = rnd.Next(1000, 9999).ToString() + "." + dataReader["ACCOUNT_PIC_EXT"];
FilePath = WebTools.SessionDataPath() + file_name;
if (File.Exists(FilePath))
{
File.Delete(FilePath);
}
byte[] byteArray = (Byte[])dataReader["ACCOUNT_PIC"];
using (FileStream fs = new FileStream(FilePath, FileMode.CreateNew, FileAccess.Write))
{
fs.Write(byteArray, 0, byteArray.Length);
AccountImage.ImageUrl = baseUrl + "SessionData/" + Session.SessionID.ToString() + @"/" + file_name;
AccountImage.DataBind();
}
}
}
}
}
}
}
