private static void SaveFileDetails(UploadedLogoInfo fileDetails)
{
string query = "Update Company set LogoName=@FileName, LogoContent=@FileContent, ContentType=@ContentType where id = @Id;";
using (SqlConnection connection = new SqlConnection(ConfigurationManager.
ConnectionStrings["IWSConnectionString"].ToString()))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
try
{
List <SqlParameter> p = new List <SqlParameter>
{
new SqlParameter("@Id", fileDetails.Id),
new SqlParameter("@FileName", fileDetails.FileName),
new SqlParameter("@FileContent", fileDetails.FileContent),
new SqlParameter("@ContentType", fileDetails.ContentType)
};
connection.Open();
AddParameters(command, p.ToArray());
command.ExecuteScalar();
command.Parameters.Clear();
}
catch (Exception ex)
{
IWSLookUp.LogException(ex);
}
finally
{
if (connection.State.Equals(ConnectionState.Open))
{
connection.Close();
}
}
}
}
}
public static void FileUploadComplete(object sender, DevExpress.Web.FileUploadCompleteEventArgs e)
{
if (e.UploadedFile.IsValid)
{
string itemId = (string)(HttpContext.Current.Session["compId"]);
string resultFilePath = HttpContext.Current.Request.MapPath(UploadDirectory + e.UploadedFile.FileName);
IUrlResolutionService urlResolver = (IUrlResolutionService)sender;
if (urlResolver != null)
{
UploadedLogoInfo fileInfo = new UploadedLogoInfo()
{
Id = itemId,
FileName = e.UploadedFile.FileName,
FileContent = e.UploadedFile.FileBytes,
ContentType = e.UploadedFile.ContentType
};
SaveFileDetails(fileInfo);
e.CallbackData += fileInfo.FileName;
}
}
}
