public bool Delete(AttachmentObject attachment) { try { Config.Conn.Execute("DELETE FROM dat_AttachmentFile WHERE AttachmentId = @AttachmentId", attachment); Config.Conn.Execute("DELETE FROM dat_Attachment WHERE AttachmentId = @AttachmentId", attachment); } catch { return(false); } return(true); }
public AttachmentObject SaveAttachment(AttachmentObject attachment) { if (attachment.AttachmentId > 0) // Update { string sql = @" UPDATE dat_Attachment SET IsDeleted = @IsDeleted, DeletedByEmployeeId = @DeletedByEmployeeId, DeletedDate = @DeletedDate WHERE AttachmentId = @AttachmentId"; Config.Conn.Execute(sql, attachment); } else { string sql = @" INSERT INTO dat_Attachment ( MainId, UploadDate, UploadEmployeeId, FileName, Note, IsDeleted, DeletedByEmployeeId, DeletedDate, Size, NumberPages, AdminOnly ) VALUES ( @MainId, @UploadDate, @UploadEmployeeId, @FileName, @Note, @IsDeleted, @DeletedByEmployeeId, @DeletedDate, @Size, @NumberPages, @AdminOnly ) SELECT CAST(SCOPE_IDENTITY() AS INT)"; attachment.AttachmentId = Config.Conn.Query <int>(sql, attachment).Single(); } return(attachment); }
public static AttachmentObject AddAttachment(int mainId, string fileName, string description, int?size, int?numberPages, bool adminOnly = false, string employeeId = null) { string sizeStr = string.Empty; if (size.HasValue) { double num = (double)size.Value / 1024.0; if (num > 999999.99) //GigaBytes { sizeStr = $"{(num / 1000000.0):F3} GB"; } else if (num > 999.99) //MegaBytes { sizeStr = $"{(num / 1000.0):F2} MB"; } else //KiloBytes { sizeStr = $"{num:F2} KB"; } } var sao = new AttachmentObject() { MainId = mainId, FileName = fileName, Note = description, IsDeleted = false, Size = sizeStr, NumberPages = numberPages, UploadEmployeeId = employeeId, AdminOnly = adminOnly }; sao.Save(); MainObject.UpdateActivityDateToNow(mainId); return(sao); }