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